Senior Data Analyst

Ethereum Technologies LLC; Raleigh (NC); On-site; USD 96,000 - 124,000; Full time

Job summary

Ethereum Technologies in Raleigh, NC, seeks a Senior Data Analyst to design and optimize enterprise data pipelines, data warehouses, and analytics solutions using Azure technologies such as Azure Synapse Analytics, Microsoft Fabric, and AI services.

The role focuses on designing ETL/ELT pipelines, managing Synapse SQL and Spark pools, and delivering Power BI-ready datasets while ensuring governance, data quality, and security. This is a 12-month engagement with US work authorization required.

Qualifications

• We are looking for an experienced Senior Data Analyst to design, develop, and optimize enterprise data pipelines and analytics solutions using Azure technologies.
• Candidate will develop and optimize SQL/PLSQL queries and collaborate with stakeholders to deliver Power BI-ready datasets.
• Experience implementing data governance, quality, and security with cloud tools is required.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory and Synapse.
• Manage Azure Synapse Analytics including SQL and Spark pools.
• Develop, test, and optimize complex SQL/PLSQL queries and procedures.
• Collaborate with stakeholders to create Power BI datasets and reports.
• Integrate AI/ML capabilities using Azure ML and Azure OpenAI Service.
• Implement data governance and security with Purview and Entra ID.
• Develop dashboards and predictive analytics models.

Skills

Analytical thinking

Stakeholder collaboration

Problem solving

Attention to detail

Tools

Azure Data Factory

Azure Synapse Analytics

Microsoft Fabric

Lakehouse architecture

SQL

PL/SQL

Power BI

Azure Machine Learning

Azure OpenAI Service

Microsoft Purview

Microsoft Entra ID

Data security

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.