Senior Data Analyst

Robotics Technologies; Raleigh (NC); On-site; USD 89,000 - 126,000; Full time

Benefits offered by this job

Onsite in Raleigh, NC

Contract engagement

Job summary

Robotics Technologies in Raleigh, NC is seeking a Senior Data Analyst to design, build, and optimize enterprise analytics on Microsoft Azure. The role emphasizes ETL/ELT pipelines, Synapse Analytics, SQL/PLSQL, and creating Power BI-ready datasets for stakeholder insights.

You will integrate AI/ML capabilities with Azure Machine Learning and Azure OpenAI Service, enforce data governance with Purview and Entra ID, and deliver dashboards and predictive models in a contract, onsite setting.

Qualifications

• Strong experience with Azure Data Factory and ETL/ELT pipeline development.
• Hands-on experience with Azure Synapse Analytics, including SQL and Spark pools.
• Experience with Microsoft Fabric and Lakehouse architecture.
• Strong SQL and PL/SQL development skills, including stored procedures and performance tuning.
• Experience preparing datasets for Power BI reporting and analytics.
• Knowledge of Azure ML and Azure OpenAI Service.
• Familiarity with Purview, Entra ID, and data governance and data security.

Responsibilities

• Design, develop, and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, and PL/SQL procedures.
• Manage and optimize Azure Synapse Analytics, including SQL and Spark pools.
• Build and support Microsoft Fabric Lakehouse solutions.
• Develop, test, and optimize complex SQL/PLSQL including stored procedures, packages, and functions.
• Collaborate with business stakeholders to capture analytics requirements and produce Power BI-ready datasets.
• Integrate AI/ML capabilities and insights using Azure Machine Learning and Azure OpenAI Service.
• Implement data governance, data quality, and security standards using Purview and Entra ID.
• Deliver enterprise reporting, dashboards, and predictive analytics models.

Skills

Azure Data Factory

ETL/ELT pipelines

Azure Synapse Analytics

SQL

PL/SQL

Spark pools

Power BI datasets

Azure Machine Learning

Azure OpenAI Service

Data governance

Microsoft Purview

Microsoft Entra ID

Lakehouse architecture

Tools

Azure Data Factory

Azure Synapse

Power BI

Microsoft Fabric Lakehouse

Purview

Entra ID

Azure Machine Learning

Azure OpenAI Service

Job description

As a Senior Data Analyst in Raleigh, NC, you will build and optimize enterprise data platforms and analytics solutions on Microsoft Azure technologies.

Responsibilities

• Design, develop, and maintain enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, and PL/SQL procedures
• Manage and optimize Azure Synapse Analytics, including SQL and Spark pools
• Build and support Microsoft Fabric Lakehouse solutions
• Develop, test, and optimize complex SQL/PLSQL including stored procedures, packages, and functions
• Collaborate with business stakeholders to capture analytics requirements and produce Power BI-ready datasets
• Integrate AI/ML capabilities and insights using Azure Machine Learning and Azure OpenAI Service
• Implement data governance, data quality, and security standards using Microsoft Purview and Microsoft Entra ID
• Deliver enterprise reporting, dashboards, and predictive analytics models

Requirements

• Strong experience with Azure Data Factory and ETL/ELT pipeline development
• Hands-on experience with Azure Synapse Analytics, including SQL and Spark pools
• Experience working with Microsoft Fabric and Lakehouse architecture
• Strong SQL and PL/SQL development skills, including stored procedures and performance tuning
• Experience preparing datasets for Power BI reporting and analytics
• Knowledge of Azure Machine Learning and Azure OpenAI Service
• Familiarity with Microsoft Purview, Microsoft Entra ID, and data governance and data security

Location: Raleigh, NC (onsite)
Engagement: Contract
Compensation: USD 78 - 78 per hourly