Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Raleigh, NC, United States
Posted
17 hours ago
OraclePL/SQLSQLScalaT-SQLETLSnowflakeAzureDatabricksPower BIPython
Job 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.
Skills Table:
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
YearsSimilar jobs
- YI
Head of Data Feeds
NewAuto ApplyYipitData
US Remote🇺🇸Remote2 hours agoMarket ResearchOnboardingSourcing - MI
SQL Database Engineer
Auto ApplyMindlance
Indianapolis, IN🇺🇸On-site10 years agoSQLSQL ServerTechnology - MI
Data Quality Lead
Auto ApplyMindlance
Detroit, MI🇺🇸On-site10 years agoOracleSQLSQL ServerTechnology - MI
Data Quality Lead
Auto ApplyMindlance
Charlotte, NC🇺🇸On-site10 years agoOracleSQLSQL ServerTechnology - MI
Oracle Database Engineer (Oracle DBA)
Auto ApplyMindlance
Washington, DC🇺🇸On-site10 years agoMongoDBOraclePL/SQL+6Technology - EP
Sr. Data Engineer with CDP, Google Cloud Platform, Cloud Spanner
NewEmpower Professionals
Atlanta, GA🇺🇸$65/hrHybrid17 hours agoSQLETLSnowflake+17Technology - TE
Data Engineer - Phoenix, AZ, St. Louis, MO, Nashville, TN, Kansas City, KS, Denver, CO.
NewTechniPros, LLC
Phoenix, AZ🇺🇸Hybrid17 hours agoDockerSQLAWS+11Technology - SW
Oracle DBA
NewSwanktek Inc
New York, NY🇺🇸Hybrid17 hours agoOracleAgileTechnology - BL
Senior Data Engineer
NewBlackRock
United States🇺🇸Hybrid2 hours agoDockerSQLAWS+7Technology - KI
DB2 Developer with Data Engineer
NewKanshe Infotech
Houston, TX🇺🇸On-site17 hours agoMicroservicesOracleSQL+3Technology - ST
AWS Data Engineer
NewSDVS Technologies LLC
United States🇺🇸Hybrid17 hours agoAWSETLGenerative AI+2Technology - LT
Lead Data Engineer
NewLorven Technologies, Inc.
Cary, NC🇺🇸On-site17 hours agoNeo4jSQLScala+10Technology