Power BI & Databricks ETL Architect — Remote

Gainwell Technologies; Illinois; On-site; USD 95,000 - 136,000; Full time

Job summary

Gainwell Technologies is seeking a highly skilled Power BI & Databricks ETL Engineer to design, build, and maintain scalable data pipelines and analytics solutions. This role will transform raw data into reliable datasets using Databricks and deliver impactful business insights through Power BI dashboards and reports.

The ideal candidate has strong expertise in ETL development, cloud data platforms, and data visualization best practices.

Qualifications

• 6+ years of experience in ETL, data engineering or BI.
• Experience with Databricks, SQL, and cloud platforms.
• Healthcare analytics experience, especially PBM/PBA data.

Responsibilities

• Design, build, and maintain robust ETL/ELT pipelines using Databricks.
• Ingest data from multiple sources including relational databases, APIs, files, and cloud storage.
• Implement data transformation, cleansing, validation, and enrichment logic to ensure data quality and consistency.
• Optimize Spark jobs for performance, scalability, and cost efficiency.
• Implement data models using Data Lake, ensuring reliability, versioning, and auditability.
• Design and develop Power BI semantic models, dashboards, and reports to support business decision‑making.
• Implement performance‑optimized DAX calculations, measures, and KPIs.
• Apply dimensional modeling concepts (star/snowflake schemas) for analytics use cases.
• Partner with stakeholders to translate business requirements into technical solutions and visual insights.
• Maintain data mapping documents, transformation specifications, and runbook inputs.
• Support multi‑environment deployment activities across DEV / STG / UAT / PRD.
• Work with cloud data platforms (primarily Microsoft Azure) including Azure Data Lake Storage and related services.
• Implement data governance, security, and access controls (e.g., row‑level security in Power BI).
• Support CI/CD pipelines for data and BI artifacts.
• Provide technical input on feasibility, risks, and delivery trade-offs to engagement leadership.
• Enforce delivery standards across documentation, peer reviews, testing, and release readiness.
• Monitor data pipelines and resolve data quality or performance issues proactively.
• Healthcare domain experience with PBM/PBA data, including pharmacy and program analytics.

Skills

ETL development

Databricks

Power BI

Azure

DAX calculations

Tools

SQL

Spark

Job description

Gainwell Technologies is seeking a highly skilled Power BI & Databricks ETL Engineer to design, build, and maintain scalable data pipelines and analytics solutions. This role will transform raw data into reliable datasets using Databricks and deliver impactful business insights through Power BI dashboards and reports.

The ideal candidate has strong expertise in ETL development, cloud data platforms, and data visualization best practices.