Job description

Position Summary The ActiveReports Report Developer/Reporting Analyst is responsible for designing, developing, testing, deploying, and maintaining operational, clinical, financial, and regulatory reports that integrate with an EHR 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 EHR/EMR systems 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. EHR Integration & Reporting Work with technical and functional teams to develop reports utilizing information maintained within the EHR 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 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 new EHR 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

Requirements

Must-haves

Report Development
Design, develop, modify, and maintain reports using ActiveReports / ActiveReports.NET.
Translate functional and technical requirements into production-ready reports.
Tables and tablix structures
Groups and nested groups
Sorting and filtering
Conditional formatting
Calculated fields and expressions
Charts and graphical elements
Headers and footers
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.
EHR Integration & Reporting
Work with technical and functional teams to develop reports utilizing information maintained within the EHR environment.
Patient/client demographics
Transfers and movements
Encounters and services
Clinical documentation
Laboratory information
Provider information
Financial data

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: bullhorn
Effort: medium