Azure Data Scientist (Mid-Level) — ETL & AI Analytics

Allitsolutions LLC; Raleigh (NC); On-site; USD 83,000 - 124,000; Full time

Job summary

All IT Solutions LLC in Raleigh, NC seeks a Data Scientist- Mid Level to join a client engagement. The role is on-site in Raleigh with responsibilities spanning data pipelines, data warehousing, and analytics using Azure Synapse, Fabric, and AI services.

You will design and optimize ETL/ELT pipelines, develop SQL/PLSQL scripts, and collaborate with stakeholders to deliver Power BI-ready datasets and predictive analytics. Familiarity with Azure OpenAI and governance tools is beneficial.

Responsibilities

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures
• 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

Job description

All IT Solutions LLC in Raleigh, NC seeks a Data Scientist- Mid Level to join a client engagement. The role is on-site in Raleigh with responsibilities spanning data pipelines, data warehousing, and analytics using Azure Synapse, Fabric, and AI services.

You will design and optimize ETL/ELT pipelines, develop SQL/PLSQL scripts, and collaborate with stakeholders to deliver Power BI-ready datasets and predictive analytics. Familiarity with Azure OpenAI and governance tools is beneficial.