Job description

Job ID: NC-806590 (99591012) Hybrid/Local Govt Azure Data Engineer (15+) with Power BI (must), dataflows/Direct Query/Import models, JSON/CSV/Parquet, Synapse/Snowflake/ADLS/Data Factory/Databricks, ETL/ELT, tuning, Python/Scala, PL/SQL, T-SQL, Warehousing/star schema experience Location: Raleigh, NC (NCDHHS-NCFAST) Duration: 10 Months Skills: Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI Required 5 Years Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models. Required 5 Years Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.). Required 3 Years Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows Required 3 Years SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization. Required 5 Years Programming Languages: Strong proficiency in Python or Scala for data processing. Required 3 Years Hands-on experience in developing efficient PL/SQL procedures Required 5 Years Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) Required 2 Years Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools). Required 2 Years Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema) Required 2 Years Description: DHHS-ITD is seeking a Data Engineer for 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. Key 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. NC-806590-SM.docx NC-RTR-806590.docx Hybrid/Local Govt Azure Data Engineer (15+) with Power BI (must), dataflows/Direct Query/Import models, JSON/CSV/Parquet, Synapse/Snowflake/ADLS/Data Factory/Databricks, ETL/ELT, tuning, Python/Scala, PL/SQL, T-SQL, Warehousing/star schema experience Share this: • Share on Facebook (Opens in new window) Facebook • Share on X (Opens in new window) X • Like this: Like Loading…

Requirements

Must-haves

Job ID: NC-806590 (99591012)
Location: Raleigh, NC (NCDHHS-NCFAST)
Duration: 10 Months
Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI Required 5 Years
Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models. Required 5 Years
Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.). Required 3 Years
Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows Required 3 Years
SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization. Required 5 Years
Programming Languages: Strong proficiency in Python or Scala for data processing. Required 3 Years
Hands-on experience in developing efficient PL/SQL procedures Required 5 Years
Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) Required 2 Years
Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools). Required 2 Years
Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema) Required 2 Years
DHHS-ITD is seeking a Data Engineer for 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).
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.
NC-806590-SM.docx
NC-RTR-806590.docx
Share on Facebook (Opens in new window)
Share on X (Opens in new window)
Like Loading…

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

azurepythonsqlapi

Platform: careers-html
Effort: medium