Job Requirements

Data Engineer – SQL Server, SSIS & Healthcare State Reporting

Position Summary

We are seeking an experienced Data Engineer to design, develop, and support data solutions for healthcare regulatory and state reporting. This role will focus on Microsoft SQL Server, SQL Server Integration Services (SSIS), data quality, and the preparation of accurate, timely, and auditable submissions to state agencies.

The ideal candidate combines strong technical expertise with an understanding of healthcare data, regulatory reporting, and the controls required to protect sensitive information.

Key Responsibilities

- Design, develop, test, and maintain ETL workflows using SSIS and SQL Server.
- Build complex SQL queries, stored procedures, views, functions, and data-validation routines.
- Integrate data from clinical, claims, enrollment, provider, financial, and operational systems.
- Translate state reporting requirements into technical specifications, data mappings, and repeatable processes.
- Produce recurring and ad hoc regulatory reports in required state formats.
- Validate reporting data for completeness, accuracy, consistency, and compliance with submission rules.
- Investigate data discrepancies, rejected submissions, and reconciliation issues; coordinate corrections with business and technical teams.
- Maintain traceability from source systems through transformations to final reported values.
- Implement audit controls, balancing procedures, exception reporting, and submission signoffs.
- Monitor and troubleshoot scheduled ETL jobs, reporting processes, and production failures.




- Optimize SQL queries, indexes, database objects, and SSIS packages for performance and reliability.
- Maintain technical documentation, including source-to-target mappings, business rules, data lineage, runbooks, and report specifications.
- Partner with compliance, operations, finance, clinical, quality, and state-reporting subject-matter experts.
- Protect PHI and PII in accordance with HIPAA, organizational security policies, and applicable state requirements.
- Support regulatory audits, state inquiries, and changes to reporting specifications.

Required Qualifications

- Bachelor’s degree in computer science, information systems, data engineering, or a related field—or equivalent professional experience.
- Three or more years of experience in data engineering, ETL development, or database development.
- Advanced proficiency with Microsoft SQL Server and T-SQL.
- Hands-on experience developing and supporting SSIS packages.
- Experience with SQL Server Agent, job scheduling, error handling, logging, and production monitoring.
- Experience working with healthcare data such as claims, encounters, eligibility, enrollment, providers, authorizations, clinical records,



or quality measures.
- Experience supporting state, regulatory, or government-mandated reporting.
- Strong understanding of data-quality practices, reconciliation, auditability, and data lineage.
- Ability to interpret complex reporting specifications and convert them into technical rules.
- Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Qualifications

- Experience with Medicaid, Medicare, managed care, behavioral health, public health, or human-services reporting.
- Familiarity with state encounter submissions, eligibility reporting, provider reporting, quality measures, or financial reporting.
- Knowledge of healthcare data standards such as HIPAA X12, HL7, FHIR, ICD-10, CPT, HCPCS, DRG, NDC, or LOINC.
- Experience with SQL Server Reporting Services (SSRS), Power BI, Azure Data Factory, or Microsoft Fabric.
- Experience with Git, Azure DevOps, CI/CD, and formal change-management processes.
- Knowledge of data warehousing, dimensional modeling, and master-data management.
- Experience responding to audits or working in a highly regulated workplace.

Success Measures

- State reports are complete, accurate, and submitted on time.
- Reporting results reconcile to source and financial systems.
- Submission errors and data-quality exceptions decline over time.
- ETL and reporting processes operate reliably within required service levels.
- Reporting logic, lineage, and controls are sufficiently documented for audits and operational support.

📌 Data Engineer (Pune)
🏢 Xoriant
📍 Pune