Data Scientist

viva; Raleigh (NC); Hybrid; USD 110,000 - 117,000; Full time

Job summary

viva is hiring a Data Scientist for a hybrid role in Raleigh, NC. You will design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions using Microsoft Azure.

The role emphasizes Azure Synapse Analytics, Fabric Lakehouse, and AI integration with Azure OpenAI Service, focusing on secure data governance and scalable analytics. Collaboration with business users and cross-functional teams is essential.

Qualifications

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

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 across SQL and Spark pools, and support Microsoft Fabric Lakehouse workloads.
• Develop, test, and tune complex SQL and PL/SQL scripts, including stored procedures, packages, and functions for data integration.
• Partner with business users to define analytical objectives and produce datasets that are Power BI-ready.
• Integrate AI and machine learning insights using Azure Machine Learning and the Azure OpenAI Service.
• Apply data governance, quality, and security practices using Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting and dashboards, and develop predictive analytics models.

Skills

Azure Synapse

SQL

Python

PySpark

Power BI

Agile

RBAC

Tools

Azure Data Factory

Azure Synapse Analytics

Fabric Lakehouse

Azure OpenAI Service

Purview

Entra ID

Power BI

Job description

viva is hiring a Data Scientist for a hybrid role in Raleigh, NC. You will help design, manage, and optimize enterprise data pipelines, data warehouses, and advanced analytics solutions using Microsoft Azure. The work combines modern Azure platforms (including Azure Synapse Analytics and Microsoft Fabric) with Azure AI services to turn complex datasets into actionable business insights.

What you’ll do

• 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 across SQL and Spark pools, and support Microsoft Fabric Lakehouse workloads.
• Develop, test, and tune complex SQL and PL/SQL scripts, including stored procedures, packages, and functions needed for data integration.
• Partner with business users to define analytical objectives and produce datasets that are Power BI-ready.
• Integrate AI and machine learning insights using Azure Machine Learning and the Azure OpenAI Service.
• Apply data governance, quality, and security practices using Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting and dashboards, and develop predictive analytics models.

Required qualifications

• 7 years of experience in enterprise data analytics, 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 experience, including query optimization, performance tuning, and indexing strategies.
• 6 years hands‑on experience with PySpark, Python, or Scala.
• 4 years experience with data modeling, performance tuning, and cost optimization in Azure.
• 3 years of strong knowledge of Microsoft Entra ID, RBAC, and cloud security.
• 3 years familiarity with Power BI semantic models and dataflows.
• 7 years ability to organize, prioritize, and follow complex and/or detailed technical procedures.
• 3 years experience with Agile (Scrum, Kanban, or SAFe).

Bonus experience

• Knowledge of Azure OpenAI or generative AI data integration (highly desired, 3 years).

Tools you’ll work with

Microsoft Azure, Azure Synapse Analytics (SQL and Spark pools), Synapse Pipelines, Azure Data Factory, Microsoft Fabric / Fabric Lakehouse, Azure Machine Learning, Azure OpenAI Service, Microsoft Purview, Microsoft Entra ID, Power BI, PySpark, Python, Scala, and RBAC, with AI and Azure AI services to support analytics and predictive work.

Compensation: USD 80–85 per hour.