Data Engineer, Reporting & Analytics - Dallas
Core
Design, develop, and maintain data warehouse processes, reporting datasets, and ETL packages to provide reliable data access for business users and analysts.
Role type
Senior Data Engineer (Reporting & Analytics)
Builds
Data warehouse infrastructure, reporting datasets, ETL pipelines, and operational data feeds.
Domain
Insurance / Pharmacy Benefit Management / Healthcare
Required skills
Advanced Microsoft SQL Server, ETL/SSIS, Data Modeling, SSRS, Power BI, Actuate/OpenText, Data Integration, Validation & Reconciliation, Source Control, DevOps
Preferred skills
Healthcare/Insurance domain knowledge, HIPAA/PHI compliance, API/SFTP integration, Azure Data Factory, Microsoft Fabric, Python, PowerShell, C#, dbt, PostgreSQL
Technologies
Azure, SQL Server, SSIS, SSRS, Power BI, Actuate/OpenText, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, dbt, PostgreSQL, Salesforce
Responsibilities
Design and maintain data warehouse processes, reporting datasets, and ETL packages; Support development and troubleshooting of reports using Actuate/OpenText, SSRS, and Power BI; Integrate data from internal and external systems including claims and vendor feeds; Automate validation, reconciliation, and monitoring for data loads and reports; Review legacy processes to reduce technical debt and standardize business logic; Collaborate with analysts and business owners to convert needs into technical solutions.
Seniority
Senior, hands-on IC