Power BI Data Engineer
Job Summary:
This role involves designing, developing, and optimizing cloud-based analytics environments using Microsoft Azure and Power BI. The Data Engineer will focus on creating scalable data pipelines and analytics solutions to support Child Welfare and Medicaid programs, integrating data from platforms such as Salesforce and Curam/Oracle.
Responsibilities:
- Analyze source systems and design, develop, and maintain scalable ETL/ELT pipelines using Azure Synapse, Azure Data Factory, and related Azure services.
- Build and manage data ingestion workflows from Salesforce, including API integrations, schema alignment, and performance tuning.
- Develop and maintain data models, data transformations, and semantic layers to support Power BI reporting and analytics.
- Optimize Synapse pipelines, SQL queries, and data storage for performance, reliability, and cost efficiency.
- Troubleshoot pipeline failures, Salesforce API issues, and Power BI dataset/dataflow refresh problems.
- Required Skills & Certifications:
- Experience with Azure Synapse Analytics and Azure Data Factory.
- Proficiency in Power BI development and data modeling.
- Strong SQL skills and ability to optimize queries and pipelines.
- Experience integrating data from Salesforce and other cloud platforms.
- Knowledge of ETL/ELT pipeline design and development.
- Preferred Skills & Certifications:
- Familiarity with Curam/Oracle data integrations.
- Experience with cloud-based analytics environments supporting healthcare or social services programs.
- Certifications in Microsoft Azure data engineering or Power BI.Special Considerations:
- Work involves handling sensitive data related to Child Welfare and Medicaid programs.
- Contract position with a duration of 12+ months and possibility of extension.
Scheduling:
Regular shift from 8:00 AM to 5:00 PM EST.
Location: Raleigh, NC.