DHHS-ITD is seeking a Data Engineer for design, development, and optimization of a cloud-based analytics environment built on Microsoft Azureand 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:
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 |
| No. | 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 accept 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 provide candidate's current location (City and state), NOT a Yes or No response. |
| Question7 | 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? |
| Question8 | 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? |
| Question9 | Candidates submitted above the rate of $95 may not be considered. Do you accept this requirement? |
| Question10 | Final hourly pay will be between $75 and $95 based on the candidate s level of experience and interview performance. |
| Question11 | Please provide a brief description of recent hands-on development work in building data pipeline using Azure Synapse Analytics. |
| Question12 | Please provide a brief description of recent hands-on development work in building and managing Power BI dashboards. |