Data Engineer, Reporting & Analytics
Core
Design, develop, and maintain data warehouse processes, reporting datasets, ETL packages, and SQL objects to provide reliable data for analysts and business users.
Role type
Senior Data Engineer (Reporting & Analytics)
Builds
Data warehouse infrastructure, ETL pipelines, reporting datasets, and automated validation/alerting systems.
Domain
Healthcare benefits administration and insurance
Required skills
Advanced Microsoft SQL Server, ETL/SSIS, Data Warehouse Design, Data Modeling, SSRS/Power BI/Actuate, Troubleshooting, Source Control
Preferred skills
Healthcare/Insurance domain knowledge, HIPAA/PHI compliance, API/SFTP integration, Azure Data Factory/Microsoft Fabric, Python/PowerShell/C#, dbt
Technologies
Azure, SQL Server, SSIS, Power BI, Actuate/OpenText, SSRS, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, dbt, PostgreSQL, Salesforce
Responsibilities
Design and maintain data warehouse processes, ETL packages, and scheduled jobs; Develop and troubleshoot reports using Actuate/OpenText, SSRS, and Power BI; Integrate data across internal and external systems including claims and vendor feeds; Build automated validation, reconciliation, and alerting for data loads; Review legacy processes to reduce technical debt and standardize business logic; Collaborate with analysts and business owners to translate needs into technical solutions.
Seniority
Senior, hands-on IC