Data Engineer (On-Site)

Position Summary:

We are seeking a skilled Reporting & Analytics Specialist with strong expertise in SSRS, Power BI, and ETL knowledge to support our enterprise reporting needs within a complex healthcare environment. This role requires close collaboration with offshore development teams, business stakeholders, and subject matter experts to gather, validate, and clarify reporting requirements. The ideal candidate will possess strong analytical skills, the ability to translate business needs into technical specifications, and a solid understanding of healthcare data structures and workflows.

Key Responsibilities:

Reporting & Dashboard Development

• Design, develop, and maintain SSRS reports and Power BI dashboards to support operational, clinical, and financial reporting needs.
• Perform data modeling, DAX calculations, and visualization optimization in Power BI.
• Ensure reports meet accuracy, performance, security, and usability standards.

ETL & Data Management

• Support ETL processes, including requirements gathering, data mapping, data validation, and quality reviews.
• Collaborate with data engineering teams to ensure data pipelines are aligned with reporting needs.
• Validate data integrity across various source systems (EMR, billing, claims, CRM, etc.).

Requirements Gathering & Stakeholder Engagement

• Work directly with business units (clinical, operations, compliance, finance) to collect and document detailed reporting requirements.
• Provide requirement clarification to offshore teams and ensure timely delivery of reporting solutions.
• Convert ambiguous business requirements into clear technical specifications.

Coordination with Offshore Team

• Serve as the primary liaison with the offshore development group.
• Review work delivered by offshore teams for accuracy, alignment with requirements, and compliance with healthcare reporting standards.
• Facilitate knowledge transfer, manage task prioritization, and ensure timely issue resolution.

Quality Assurance & Compliance

• Conduct thorough testing and validation of reports, dashboards, and ETL outputs.
• Ensure compliance with healthcare regulatory requirements (HIPAA, PHI handling, data governance).
• Maintain documentation for reporting processes, data definitions, and business logic.