NC FAST Data Engineer

DHHS-ITD is seeking a Senior Synapse Data Engineer to lead the development and optimization of end-to-end solutions using Microsoft Azure Synapse Analytics, ensuring data accessibility, performance, and security for the Child Welfare Program.

The Department of Health and Human Services (DHHS) requires the assistance of a contract resource to serve as a Senior Synapse Data Engineer. Theprimary purpose of this position is to lead the development and optimization of our data pipelines, analytics solutions, and cloud-based data platforms. This role will be instrumental in designing and implementing end-to-end data solutions using Microsoft Azure Synapse Analytics, ensuring data accessibility, performance, and security.

Key Respo

Develop and maintain data models in Synapse to support reporting and analytics

Develop ETL solutions using Azure Synapse Analytics Pipelines and dedicated SQL pools for extraction, transformation and aggregation from Salesforce objects.

Analyze the source system and design the ETL data load.

Ability to create and configure Azure Synapse Analytics workspace.

Create pipelines in Azure Synapse using Linked Services / Datasets / Pipeline to Extract, Transform and Load data from different sources.

Perform regular monitoring, troubleshooting, and maintenance of the data architecture and pipelines.

Contribute to cloud infrastructure and security (Azure storage, networking, security, cost management)

• Power BI Tools
• Collaborate with data scientists, analysts, and stakeholders to gather requirements, design visualizations, and provide training to use self-service BI Tools.
• Salesforce and MuleSoft

Knowledge of Salesforce object and data structures

Design and implement data integrations between Salesforce and Azure Synapse using APIs, ETL tools, and integration platforms like MuleSoft and Azure Data Factory / Azure Synapse Analytics.

Strong knowledge of Salesforce APIs (REST, SOAP), Apex, and Lightning Web Components

Familiarity with integration tools like MuleSoft, Informatica, or similar.

• Governance

Implement and maintain best practices for data governance, security, and compliance.

Maintain data documentation (data model updates; data dictionary upkeep)

Required / Desired Skills

Skill

Required / Desired

Amount

of Experience

Experience with Azure Synapse Analytics

Required

Years

Experience designing, developing, and managing Synapse pipelines

Required

Years

Experience with Azure Data Platform (Azure Data Factory, Azure Data Lake, and Azure SQL Database)

Required

Years

Familiarity with Event Hubs, Azure Stream Analytics, and Azure Functions

Desired

Years

Experience with Data Modeling and Warehousing (star schema, snowflake schema)

Desired

Years

Experience with ETL / ELT processes

Desired

Years

Experience with Programming and Scripting (SQL, T-SQL, and data query optimization)

Desired

Years

Experience with Salesforce Integrations

Desired

Years

Experience with Integrations tools (MuleSoft, Informatica, or similar)

Desired

Years

Experience with DevOps and CI / CD (Git and automation tools)

Desired

Years

Experience with infrastructure as code (IaC) tools like Terraform

Desired

Years

Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage

Desired

Years

Experience with Lightning Web Components for Salesforce reports

Desired

Years

Experience with Salesforce APIs (REST, SOAP), Apex

Desired

Years

Experience with Cloud Computing

Desired

Years

Experience with Power BI

Desired

Years

Questions

Question

Question1

Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement?

Question2

Please list candidate's email address HERE that will be used when submitting E-RTR.

Question3

Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.

Question4

Will the candidate be subcontracted at the time of submission (Yes or No)?

Question5

Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?

Question6

Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume.

Question7

Please provide candidate's current location (City and state), NOT a Yes or No response.

Question8

Please list all Professional Certifications (ex. Azure Data Engineer Associate, Azure Solutions Architect Expert, Microsoft Certified : Azure Fundamentals) and the year they were received. The certifications will be validated.

Question9

Please provide a brief description of recent professional development work with Azure Synapse Analytics integrating with Salesforce Objects.

Question10

Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?

Question11

Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?

Question12

Candidates submitted above the rate of -10 may not be considered. Do you accept this requirement?