Azure Data Scientist – Enterprise Analytics & AI

ALL IT Solutions; Raleigh (NC); On-site; USD 69,000 - 124,000; Full time

Job summary

ALL IT Solutions in Raleigh, NC seeks a mid-level Data Scientist to design and optimize enterprise analytics solutions on Microsoft Azure. You will build data pipelines and warehouses, integrate AI insights, and deliver Power BI-ready datasets for reporting and predictive analytics.

The role centers on Azure Synapse, Data Factory, and Fabric lakehouse workloads, requiring strong SQL/PLSQL, PySpark, and Agile experience. On-site contract position in Raleigh with governance and security focus.

Qualifications

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

Responsibilities

• Design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions on Microsoft Azure.
• Use Azure Synapse Analytics, Microsoft Fabric, and Azure AI services to transform complex data into business insights and advanced analytics.
• Design, build, and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures.
• Manage and optimize Azure Synapse Analytics across SQL and Spark pools, and support Microsoft Fabric Lakehouse workloads.
• Develop, test, and tune SQL and PL/SQL artifacts including stored procedures, packages, and functions for data integration.
• Collaborate with business users to define analytical goals and create Power BI-ready datasets.
• Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service for reporting and predictive analytics.
• Enforce data governance, quality, and security with Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models.

Skills

Enterprise data analytics

Azure Synapse Analytics

SQL & PL/SQL

PySpark / Python / Scala

Data modeling

Azure OpenAI / AI integration

Agile development

Power BI readiness

RBAC / security

Power BI dataflows

Tools

Microsoft Azure

Azure Synapse Analytics

Azure Data Factory

Synapse Pipelines

PL/SQL

SQL

Azure Machine Learning

Azure OpenAI Service

Microsoft Purview

Microsoft Entra ID

RBAC

Power BI

PySpark

Python

Scala

Spark pools

Microsoft Fabric Lakehouse

Power BI semantic models

Power BI dataflows

Job description

ALL IT Solutions in Raleigh, NC seeks a mid-level Data Scientist to design and optimize enterprise analytics solutions on Microsoft Azure. You will build data pipelines and warehouses, integrate AI insights, and deliver Power BI-ready datasets for reporting and predictive analytics.

The role centers on Azure Synapse, Data Factory, and Fabric lakehouse workloads, requiring strong SQL/PLSQL, PySpark, and Agile experience. On-site contract position in Raleigh with governance and security focus.