ExecRecruitment

Business Intelligence (BI) Data engineer

Raleigh, NC
Full Time
Experienced

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.

Skill Matrix:

  • 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

Benefits at IntelliBee

  • 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.
Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*