Hybrid Sr. Data Analyst/Azure in Raleigh, NC

HonorVet Technologies; Raleigh (NC); On-site; USD 103,000 - 165,000; Full time

Job summary

HonorVet Technologies in Raleigh, NC seeks a Sr. Data Analyst to design, manage and optimize enterprise data pipelines, warehouses, and analytics using Azure. You will transform complex data into business insights with Synapse, Fabric Lakehouse, and Azure AI services.

Responsibilities include building robust ETL/ELT pipelines, tuning SQL/PL/PLSQL, and delivering Power BI-ready datasets. Collaboration with business users and governance via Purview/Entra ID are key to success.

Qualifications

• 7+ years in enterprise data analytics and engineering.
• 4+ years on Azure Synapse Analytics, Azure Data Factory, and data warehousing.
• 7+ years advanced SQL/PLSQL with tuning.
• 6+ years PySpark, Python, or Scala.
• 4+ years data modeling, performance tuning, cost optimization in Azure.
• 3+ years RBAC and cloud security knowledge.
• 3+ years Power BI semantic models/dataflows familiarity.
• 7+ years ability to organize and follow complex procedures.
• 3+ years Agile (Scrum/Kanban/SAFe).
• Desirable: 3 years knowledge of Azure OpenAI or generative AI data integration.

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

ETL pipelines

Azure Synapse

SQL/PLSQL

PySpark/Python/Scala

Azure data modeling

RBAC & cloud security

Power BI dataflows

Agile development

Azure OpenAI (desirable)

Tools

Power BI

Microsoft Purview

Microsoft Entra ID

Azure OpenAI Service

Job description

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001, and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn't a tagline; it's the way we work. We don't forward resumes and hope for the best. We take the time to understand where a professional like you are headed and only reach out when we genuinely believe there's a fit worth exploring.

Title: Sr. Data Analyst/Azure

Project Duration: 12 + months contract with possible extension

Location: Raleigh, NC 27609

Job Description

Client requires the services of a Senior Data Analyst that will help us design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure. This role transforms complex data into business insights and drives advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services.

The key responsibilities for this position will include the following:

• 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

Skill Matrix:

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