Senior Data Analyst — Azure Data Platform & AI

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

Job summary

Robotics Technologies LLC in Raleigh, NC seeks a Senior Data Analyst to design and optimize enterprise data pipelines, warehouses and analytics using Azure technologies.

You will develop ETL/ELT pipelines with Azure Data Factory and Synapse, optimize SQL/PLSQL, prepare Power BI datasets, and integrate AI capabilities with Azure ML and Azure OpenAI Service, while enforcing data governance and security.

Qualifications

• Design and build enterprise ETL/ELT pipelines using Azure Data Factory and Synapse Pipelines.
• Optimize Azure Synapse Analytics including SQL and Spark pools.
• Develop SQL/PLSQL queries, stored procedures, packages, and functions for data integration.
• Prepare Power BI-ready datasets in collaboration with stakeholders.
• Incorporate AI/ML capabilities with Azure ML and Azure OpenAI Service.
• Apply data governance and security using Purview and Entra ID.
• Create enterprise reporting, dashboards and predictive analytics.

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, and Microsoft Fabric Lakehouse solutions.
• Develop, test, and optimize complex SQL/PLSQL queries, stored procedures, packages, and functions for enterprise data integration.
• Collaborate with business stakeholders to understand analytics requirements and develop 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.
• Develop enterprise reporting solutions, dashboards, and predictive analytics models.

Skills

Azure Data Factory

Azure Synapse Analytics

SQL/PLSQL

Power BI data prep

Azure Machine Learning

Azure OpenAI Service

Microsoft Purview

Microsoft Entra ID

Tools

Azure Data Factory

Azure Synapse Analytics

Microsoft Fabric Lakehouse

Power BI

Azure Machine Learning

Azure OpenAI Service

Microsoft Purview

Microsoft Entra ID

Job description

Robotics Technologies LLC in Raleigh, NC seeks a Senior Data Analyst to design and optimize enterprise data pipelines, warehouses and analytics using Azure technologies.

You will develop ETL/ELT pipelines with Azure Data Factory and Synapse, optimize SQL/PLSQL, prepare Power BI datasets, and integrate AI capabilities with Azure ML and Azure OpenAI Service, while enforcing data governance and security.