Data Engineer

Acuity Eye Group; Santa Ana (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

Acuity Eye Group is seeking a Reporting & Analytics Specialist to design and maintain SSRS reports and Power BI dashboards for clinical, operational, and financial needs.

The role requires expertise in ETL, data modeling, DAX, and SQL scripting, with collaboration across offshore teams and business stakeholders. Knowledge of HIPAA and healthcare data governance is preferred.

Qualifications

• Bachelor's degree in information systems, Computer Science, or related field.
• 3-7 years of experience in reporting and analytics roles.
• Hands-on experience with SSRS, Power BI, SQL scripting, and ETL processes.

Responsibilities

• 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.
• Support ETL processes, including requirements gathering, data mapping, data validation, and quality reviews.
• Collaborate with offshore development teams to ensure data pipelines align with reporting needs.
• Validate data integrity across source systems (EMR, billing, claims, CRM).
• Coordinate with business units to collect and document reporting requirements, and provide clarification to offshore teams.
• Review offshore work for accuracy and compliance with healthcare reporting standards.
• Conduct testing and validation of reports, dashboards, and ETL outputs to ensure regulatory compliance.

Skills

SSRS

Power BI

SQL scripting

ETL processes

Data modeling

DAX

Offshore collaboration

Documentation skills

Healthcare data understanding

HIPAA knowledge

Education

Bachelor's degree in information systems, Computer Science, or related field

Tools

SSIS

Job description

Description

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.

Requirements

Qualifications:

Required

• Bachelor's degree in information systems, Computer Science, or related field.
• 3-7 years of experience in reporting and analytics roles.

Hands-on experience with:

• SSRS (SQL Server Reporting Services)
• Power BI (data modeling, DAX, report development)
• SQL scripting and database querying
• ETL processes (SSIS or equivalent tools)
• Strong understanding of relational databases and data warehouse concepts.
• Experience collaborating with offshore technical teams.
• Excellent communication and documentation skills.

Preferred

• Experience in a medical or healthcare organization (clinical workflows, claims, EMR systems, healthcare KPIs).
• Knowledge of HIPAA, PHI security, and data governance best practices.
• Familiarity with cloud environments (Azure preferred).

Soft Skills

• Translator Skills: The ability to take a vague request from a physician or executive and turn it into a concrete technical requirement.
• Detail Oriented: In healthcare, a decimal point in the wrong place matters. You have a "measure twice, cut once" mentality.