NC FAST Power BI and Data engineer
About The Position
DHHS-ITD is seeking a Data Engineer for the design, development, and optimization of a cloud-based analytics environment built on Microsoft Azure and Power BI for the Child Welfare and Medicaid Program(s). The Department of Health and Human Services requires the assistance of a contract resource to serve as a Data Engineer responsible for the design, development, and optimization of data pipelines and analytics solutions/dashboards on cloud-based data platforms. This work will leverage Azure Synapse Analytics, Power BI, and integrations with Salesforce or Curam/Oracle to support program needs.
Requirements
- Experience with Azure Synapse Analytics
- Experience with Azure Data Factory
- Experience with Power BI
- Experience with ETL/ELT pipeline development
- Experience with data modeling
- Experience with SQL query optimization
- Experience with Salesforce API integrations
Nice To Haves
- Experience with Curam/Oracle integrations
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
