Senior Data Analyst — Azure Data & AI Solutions

RICEFW Technologies Inc; Raleigh (NC); On-site; USD 90,000 - 140,000; Full time

Job summary

NC DHHS is seeking a Senior Data Analyst to design, manage, and optimize enterprise data pipelines and data warehouses, delivering analytics solutions using Azure Synapse, Fabric, and AI services. You will transform complex data into business insights and drive advanced analytics across the organization.

Responsibilities include building ETL/ELT pipelines, managing Synapse and Fabric environments, writing complex SQL/PLSQL, and enabling Power BI-ready datasets for stakeholders.

Qualifications

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

Responsibilities

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

Skills

Azure Synapse Analytics

Azure Data Factory

SQL

PL/SQL

Python / PySpark / Scala

Power BI

Microsoft Fabric

Azure Machine Learning

Azure OpenAI Service

Data governance

RBAC / Entra ID

Data modeling

ETL/ELT pipelines

Azure Purview

Spark

Security

Agile (Scrum/Kanban/SAFe)

Tools

Power BI (semantic models)

Azure Data Factory

Azure Synapse

Azure OpenAI Service

Job description

NC DHHS is seeking a Senior Data Analyst to design, manage, and optimize enterprise data pipelines and data warehouses, delivering analytics solutions using Azure Synapse, Fabric, and AI services. You will transform complex data into business insights and drive advanced analytics across the organization.

Responsibilities include building ETL/ELT pipelines, managing Synapse and Fabric environments, writing complex SQL/PLSQL, and enabling Power BI-ready datasets for stakeholders.