Data Scientist - Mid Level | Raleigh, NC (Local candidates only)

We are looking for an experienced Data Scientist to design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure.

The role involves transforming complex data into meaningful business insights and driving advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services.

Key Responsibilities

Design, build, and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, and PL/SQL procedures.

Manage and optimize Azure Synapse Analytics (SQL and Spark pools) and Microsoft Fabric Lakehouse.

Develop, test, and optimize complex SQL/PLSQL scripts, stored procedures, packages, and functions.

Collaborate with business stakeholders to define analytical requirements and build Power BI-ready datasets.

Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service.

Implement data governance, quality, and security using Microsoft Purview and Microsoft Entra ID.

Develop cross-functional reports, dashboards, and predictive analytics models.

Must-Have Skills

Azure, Cloud, Power BI, SQL

Required Skills & Experience

7+ years of experience in enterprise data analytics, data engineering, and designing complex ETL workflows.

4+ years of expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing.

7+ years of advanced SQL and PL/SQL, including query optimization, performance tuning, and indexing strategies.

6+ years of hands-on experience with PySpark, Python, or Scala.

4+ years of experience in data modeling, performance tuning, and Azure cost optimization.

3+ years of experience with Microsoft Entra ID, RBAC, and cloud security.

3+ years of experience with Power BI semantic models and dataflows.

7+ years of experience organizing, prioritizing, and following complex technical procedures.

3+ years of experience with Agile methodologies (Scrum, Kanban, or SAFe).

Preferred Skills

3+ years of experience with Azure OpenAI or Generative AI data integration.

Interview Process

In-person interview only.

Note: Local candidates to Raleigh, NC only.