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: