Hybrid/Local Azure Synapse Data Analyst/Scientist (15+)

InnoSoul • Raleigh, NC

2d • Hybrid

About The Position

NC DHHS is seeking a Senior Data Analyst to design, manage, and optimize enterprise data pipelines and data warehouses, and to deliver analytics solutions using Microsoft Azure services. The role transforms complex data into business insights and supports advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services.

The position works with Azure Synapse Analytics, Azure Data Factory, Microsoft Fabric Lakehouse, SQL and Spark pools, PL/SQL, Power BI, Azure Machine Learning, Azure OpenAI Service, Microsoft Purview, and Microsoft Entra ID. The role collaborates with business users to define analytical goals and produce datasets, reporting, dashboards, and predictive analytics models. The position is hybrid/local in Raleigh, North Carolina, and has a stated duration of 12 months.

Requirements

• At least 7 years of experience in enterprise data analytics, engineering, and designing complex ETL workflows.
• At least 4 years of expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing.
• At least 7 years of advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies.
• At least 6 years of hands-on experience with PySpark, Python, or Scala.
• At least 4 years of experience with data modeling, performance tuning, and cost optimization in Azure.
• At least 3 years of strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security.
• At least 3 years of familiarity with Power BI semantic models and dataflows.
• Ability to organize, prioritize, and follow complex and/or detailed technical procedures; 7 years required.
• At least 3 years of experience with Agile development (Scrum, Kanban, or SAFe).

Nice To Haves

• At least 3 years of knowledge of Azure OpenAI or generative AI data integration.

Responsibilities

• Design, build, and maintain 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 using Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed