Why This Role Stands Out
This hybrid Power BI and Data Engineer role offers a fantastic opportunity to shape a cloud-based analytics environment using Azure and Power BI, impacting crucial health and human services programs. You'll thrive here if you're skilled in ETL/ELT pipelines, Azure Synapse, and Power BI development, eager to contribute to meaningful projects within a supportive team. Apply now to leverage your expertise and grow your career in a dynamic tech environment.
Quick Overview
Job Description
Job Description:
***Crop to Crop resumes are accepted
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.
Required Skills:
Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI |
Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models. |
Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.). |
Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows |
SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization. |
Programming Languages: Strong proficiency in Python or Scala for data processing. |
Hands-on experience in developing efficient PL/SQL procedures |
Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) |
Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools). |
Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema) |
Similar jobs
- OT
Senior Database Developer / Data Engineer with Oracle Database Exp ( Hybrid - Secaucus, NJ.)
NewOMG Technologies
Secaucus, NJ🇺🇸HybridYesterdayOraclePL/SQLSQL+5Technology - AE
Power BI and Data engineer
NewAtash Enterprises, LLC
Raleigh, NC🇺🇸HybridYesterdayOraclePL/SQLSQL+8Technology - RI
AWS Data Engineer
NewRivago infotech inc
Newark, NJ🇺🇸HybridYesterdaySQLScalaShell+7Technology - WC
Senior Data Engineer - Ab Initio / Snowflake
NewWest Coast Consulting LLC
United States🇺🇸RemoteYesterdaySQLShellETL+5Technology - HT
Power BI and Azure Data engineer
HonorVet Technologies
Raleigh, NC🇺🇸Hybrid5 days agoPL/SQLSQLScala+9Technology - TP
SQL DATABASE ENGINEER
NewTheron Partners Inc.
Miramar Beach, FL🇺🇸On-siteYesterdaySQLSQL ServerShell+5Technology