Data Scientist- Mid Level

Client requires the services of a Senior Data Analyst who will help 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.

Responsibilities

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

Skills

Required

Required Experience

Candidate Experience

Last Used

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

Description

Questions

Answers

Question 1

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?

Question 2

All work must be completed on-site. Do you agree to this requirement?

Question 3

Your candidate must be able to attend an in-person interview. Do you agree to this requirement?

Question 4

What is your candidate's email address?

Question 5

How soon can your candidate start if selected for this opportunity?

Question 10

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?

Question 11

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?

Question 12

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

Question 13

Please list all the certifications candidate has around relational databases including ORACLE, SQL Server etc. Azure and other cloud services.