NC Fast Data Scientist- Mid Level

Required 7 Years Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing Required 4 Years Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies Required 7 Years Hands-on experience with PySpark, Python, or Scala Required 6 Years Experience with data modeling, performance tuning, and cost optimization in Azure Required 4 Years Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security Required 3 Years Familiarity with Power BI semantic models and dataflows Required 3 Years Knowledge of Azure OpenAI or generative AI data integration Highly desired 3 Years Ability to organize, prioritize, and follow complex and/or detailed technical procedures Required 7 Years Experience with Agile (Scrum, Kanban, or SAFe) development Required 3 Years . NC DHHS requires the services of a Senior Data Analyst that will help us design, manage, and optimize enterprise data pipelines, data warehouses, and drives advanced analytics solutions using Microsoft Azure services like Synapse, Fabric, and AI.

NC DHHS requires the services of a Senior Data Analyst that will help us design, manage, and optimize enterprise data pipelines, data warehouses, and drives advanced analytics solutions using Microsoft Azure services like Synapse, Fabric, and AI.

NC DHHS requires the services of a Senior Data Analyst that will help us design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure. This role transforms complex data into business insights and drives advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services. The key responsibilities for this position will include the following:

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures.
• Manage and optimize Azure Synapse Analytics (SQL and Spark pools) and Microsoft Fabric Lakehouse.
• Develop, test, and tune complex SQL and PL/SQL scripts, stored procedures, packages, and functions to support data integration.
• Collaborate with business users to define analytical goals and build Power BI-ready datasets.
• Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service.
• Enforce data governance, quality, and security via Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Experience in enterprise data analytics, engineering, and designing complex ETL workflows.	Required	7	Years
Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing	Required	4	Years
Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies	Required	7	Years
Hands-on experience with PySpark, Python, or Scala	Required	6	Years
Experience with data modeling, performance tuning, and cost optimization in Azure	Required	4	Years
Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security	Required	3	Years
Familiarity with Power BI semantic models and dataflows	Required	3	Years
Knowledge of Azure OpenAI or generative AI data integration	Highly desired	3	Years
Ability to organize, prioritize, and follow complex and/or detailed technical procedures	Required	7	Years
Experience with Agile (Scrum, Kanban, or SAFe) development	Required	3	Years

Questions

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 agree to this requirement?
Question2	All work must be completed on-site. Do you agree to this requirement?
Question3	Your candidate must be able to attend an in-person interview. Do you agree to this requirement?
Question4	What is your candidate's email address?
Question5	How soon can your candidate start if selected for this opportunity?
Question6	Vendors are encouraged to submit candidates that are available for the duration of the assignment. Do you anticipate your candidate being able to work until the proposed end date listed on this VectorVMS req?
Question7	Vendors must disclose to the agency if the candidate will be subcontracted at the time of submission. Is your candidate an employee of your company or a subcontractor? Please be sure to notify a CAI Account Manager if your candidate's employee status changes.
Question8	Vendors must notify the agency if any portion of the requirements listed in this task order will be outsourced to other countries. Do you anticipate outsourcing any work being done for this assignment to another country?
Question9	Candidates submitted above the hourly Vendor Rate of $$$ may not be considered for this assignment. Do you agree to this requirement?
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 Vendor to adhere to any applicable compensation laws including payment for overtime hours. Do you agree to this requirement?
Question11	Have you thoroughly validated, and attest to the accuracy of, the credentials listed throughout your candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440?
Question12	Please provide candidate's current location (City and State), NOT a Yes or No response
Question13	Please list all the certifications candidate has around relational databases including ORACLE, SQL Server etc. Azure and other cloud services.