Power BI and Data Engineer: 1+Yr Project Raleigh NC: Remote Now, Hybrid/Onsite later: $ 65-83/hr C2C/1099 or $ 60-77/hr W2 depending on exp level + interview results
Quick Overview
Job Description
NCFAST 806590: 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 / Desired Skills
Skill | Required / Desired | Amount | of Experience |
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 |
|
|
Question 1 | Please provide a brief description of recent hands-on development work in building data pipeline using Azure Synapse Analytics. |
Question 2 | Please provide a brief description of recent hands-on development work in building and managing Power BI dashboards. |
Similar jobs
- SA
Data Ops Engineer Senior
SAIC
Halawa, HI🇺🇸$120.0k - $160k/yrRemote2 weeks agoMicrosoft WordEngineering - PE
Data Manager with Security Clearance
Peraton
Bethesda, MD🇺🇸$135k - $216k/yrOn-site6 weeks agoSQLConfluenceHTTPS+2Technology - PE
Data & AI Integration Engineer - Mid-Level with Security Clearance
Peraton
Reston, VA🇺🇸$86k - $138k/yrHybrid6 weeks agoSQLSQL ServerAWS+9Technology - KA
Sr Data Analyst / Data Engineer ( Snowflake, Tableau ,ITSM data and analytics, ServiceNow)
NewK Anand Corporation
Sunnyvale, CA🇺🇸On-siteYesterdaySnowflakeTableauTechnology - LM
Database Engineer - Entry Level with Security Clearance
Lockheed Martin
Annapolis Junction, MD🇺🇸$70.1k - $123.6k/yrOn-site6 weeks agoOracleSQLRedisTechnology - MG
Principal Database Engineer
NewMedical Guardian
Philadelphia, Pennsylvania🇺🇸Hybrid9 hours ago401kSQLSQL Server+23Technology