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