Business Intelligence (BI) Data engineer

ExecRecruitment • Raleigh, NC

1d

About The Position

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

• 5 Years Experience supporting Power BI datasets, dataflows, and DirectQuery/Import models.
• 3 Years Experience working with structured and semi-structured data formats (JSON, CSV, Parquet, etc.).
• 3 Years Strong experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake or Databricks workflows
• 5 Years SQL Mastery: Advanced query writing, ETL/ELT, performance tuning, and optimization.
• 3 Years Programming Languages: Strong proficiency in Python or Scala for data processing.
• 5 Years Hands-on experience in developing efficient PL/SQL procedures
• 2 Years Experience with Programming and Scripting (SQL, T-SQL, and data query optimization)
• 2 Years Solid understanding of Azure cloud services (Synapse, Data Lake, Data Factory, Azure SQL, monitoring tools).
• 2 Years Experience in Azure Data Lake Storage (ADLS), Delta Lake, and data modeling concepts and Warehousing (star schema, snowflake schema)

Nice To Haves

• Strong Hands-on experience configuring, designing, developing and testing dashboards using Power BI

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.

Benefits

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed