Data Scientist- Mid Level

ALL IT Solutions; Raleigh (NC); Presencial; USD 69 000 - 124 000; Tempo integral

Resumo da oferta

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.

Qualificações

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

Responsabilidades

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

Conhecimentos

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

Ferramentas

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

Descrição da oferta de emprego

Work onsite in Raleigh, NC as a mid-level Data Scientist supporting a client engagement focused on modern enterprise analytics. This contract role centers on building and improving enterprise data pipelines, data warehouses, and analytics solutions in Microsoft Azure, while integrating AI and machine learning insights for reporting and predictive analytics.

What you will do

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

Key skills and experience

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

Tools you will work with

Microsoft Azure, Azure Synapse Analytics, Microsoft Fabric, Azure AI services, Azure Data Factory, Synapse Pipelines, PL/SQL, SQL, Azure Machine Learning, Azure OpenAI Service, Microsoft Purview, Microsoft Entra ID, RBAC, PySpark, Python, Scala, Power BI, Power BI semantic models, Power BI dataflows, ETL/ELT, and stored procedures, packages, and functions, including Spark pools and Microsoft Fabric Lakehouse.