ActiveReports Developer

No C2C Resumes allowed Candidate must be self-represented and eligible to work directly on our W2 without sponsorship 1-year hourly contract role Remote with some travel to Kansas City, MI for training Position Summary The ActiveReports Report Developer / Netsmart Reporting Analyst is responsible for designing, developing, testing, deploying, and maintaining operational, clinical, financial, and regulatory reports that integrate with the Netsmart myAvatarNx application. This position will primarily use ActiveReports / ActiveReports.NET as the enterprise reporting technology. Strong SQL and data-analysis skills with expertise in report layout, calculations, parameters, grouping, formatting, subreports, and data validation are required. The ideal candidate understands how to translate business and clinical reporting requirements into accurate, usable reports while navigating complex relational healthcare data. Experience with Netsmart myAvatar is a plus but is not required for an otherwise strong ActiveReports reporting candidate. Primary Responsibilities Report Development Design, develop, modify, and maintain reports using ActiveReports / ActiveReports.NET. Translate functional and technical requirements into production-ready reports. Develop reports containing: Tables and tablix structures Groups and nested groups Sorting and filtering Parameters Conditional formatting Calculated fields and expressions Charts and graphical elements Headers and footers Subreports Drill-down or interactive functionality where applicable Build reports designed for screen viewing, printing, PDF generation, Excel export, and other required distribution methods. Develop reusable report components and standardized report templates. Modify existing reports as operational and regulatory requirements change. Troubleshoot report rendering, formatting, pagination, performance, and data issues. Netsmart Integration & Reporting Work with technical and functional teams to develop reports utilizing information maintained within the Netsmart environment. Reporting areas may include: Patient/client demographics Admissions Discharges Transfers and movements Encounters and services Clinical documentation Assessments Diagnoses Medications Orders Laboratory information Provider information Scheduling Billing Claims Financial data Utilization Regulatory reporting Quality metrics Operational metrics Executive reporting The developer will work closely with Netsmart application analysts, solution architects, database resources, clinical subject-matter experts, and business stakeholders to understand how information is stored and how it should be represented.

Requirements

Analysis Meet with business, clinical, operational, and technical stakeholders to understand reporting needs. Convert business requests into documented report requirements and specifications. Identify: Required fields Data sources Business rules Calculations Filters Report parameters Sorting Grouping Security requirements Distribution requirements Identify discrepancies between requested information and available application data. Recommend alternative reporting approaches when requirements cannot be met directly. Report Conversion & Migration Where applicable: Analyze existing Crystal Reports, legacy reports, or reports from applications being replaced. Document existing report logic. Identify underlying data sources and SQL. Determine whether existing report requirements remain valid in the Netsmart environment. Recreate or redesign reports using ActiveReports. Validate new ActiveReports output against legacy report output. Identify reports that should be: Converted Consolidated Redesigned Replaced Retired Testing & Quality Assurance Perform unit testing of reports before business validation. Validate: Data accuracy Calculations Totals Filters Parameters Sorting Grouping Formatting Pagination Export functionality Compare report results against source application data. Support user acceptance testing. Research and resolve discrepancies identified during testing. Document test scenarios and expected results. Maintain appropriate version control and change documentation. Performance Optimization Analyze poorly performing reports and queries. Reduce unnecessary database calls and inefficient joins. Optimize stored procedures and SQL queries. Reduce report-generation time. Identify opportunities to reuse common datasets or reporting components. Work with database administrators when database-level tuning is required. Documentation Create and maintain technical documentation including: Report specifications Report inventory SQL/data sources Tables and fields used Parameters Business rules Calculations Dependencies Security requirements Change history Testing results

Required Qualifications

Minimum 3–5 years of experience developing enterprise reports using ActiveReports / ActiveReports.NET Candidate should have demonstrated experience with: SELECT statements Complex joins Subqueries Common Table Expressions UNION operations CASE statements Aggregate functions Window functions Stored procedures Views Query troubleshooting Query optimization