Senior Data Analyst

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

Job summary

Valiant Technologies LLC in Raleigh, NC seeks a Senior Data Analyst to design and optimize enterprise data pipelines, data warehouses, and analytics solutions on Microsoft Azure, including Synapse Analytics, Fabric, and AI services.

The role emphasizes building ETL/ELT pipelines, tuning SQL/PLSQL, developing Power BI-ready datasets, and integrating AI via Azure ML and OpenAI, with emphasis on data governance and security.

Qualifications

• Experience designing ETL/ELT pipelines in Azure environments.
• Strong SQL/PLSQL development and performance tuning.
• Experience preparing datasets for Power BI reporting.
• Familiarity with AI/ML integration in data platforms.

Responsibilities

• Design, develop, and maintain enterprise ETL/ELT pipelines using Azure Data Factory and Synapse.
• Manage and optimize Azure Synapse Analytics and Fabric Lakehouse solutions.
• Develop complex SQL/PLSQL queries and procedures for data integration.
• Collaborate with stakeholders to create Power BI datasets.
• Integrate AI/ML capabilities using Azure ML and OpenAI.
• Implement data governance and security per Microsoft Purview and Entra ID.

Skills

ETL/ELT pipelines design

SQL/PLSQL development

Power BI data preparation

AI/ML integration

Data governance & security

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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Senior Data Analyst

Location: Raleigh, NC

Duration: 12 Months + Extension

Bill Rate: $78/hour

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

Job Description

• We are looking for an experienced Senior Data Analyst to design, develop, manage, and optimize enterprise data pipelines, data warehouses, and advanced analytics solutions using Microsoft Azure technologies, including Azure Synapse Analytics, Microsoft Fabric, and AI services.

Key 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.

Required Technical Skills:

• Strong experience with Azure Data Factory and ETL/ELT pipeline development.
• Hands-on experience with Azure Synapse Analytics (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 Machine Learning and Azure OpenAI Service.
• Familiarity with Microsoft Purview, Microsoft Entra ID, data governance, and data security.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.