Senior Azure Data Engineer & Analytics Lead

CCS Global Tech; Raleigh (NC); On-site; USD 120,000 - 150,000; Full time

Job summary

CCS Global Tech is a rapidly growing IT company delivering Microsoft-based solutions and analytics capabilities. This role focuses on designing and maintaining robust ETL/ELT pipelines with Azure tools, building governance, and enabling data-driven decisions with Power BI-ready datasets.

You will use Azure Synapse, Data Factory, and SQL/PLSQL to optimize data warehousing, collaborate with business users, and integrate AI insights via Azure OpenAI Service, while ensuring security with Entra ID

Qualifications

• 7+ years of enterprise data analytics, engineering and ETL workflow design.
• 4+ years in Azure Synapse Analytics, Azure Data Factory and cloud data warehousing.
• 7+ years of advanced SQL and PL/SQL with optimization and indexing.
• 6+ years hands-on PySpark, Python or Scala.
• 4+ years data modeling, performance tuning and Azure cost optimization.
• 3+ years Microsoft Entra ID, RBAC and cloud security knowledge.
• 3+ years familiarity with Power BI semantic models and dataflows.
• 7+ years ability to organize, prioritize and follow complex technical procedures.
• 3+ years Experience with Agile (Scrum, Kanban, SAFe).
• 3 years knowledge of Azure OpenAI or generative AI data integration.

Responsibilities

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL.
• Manage and optimize Azure Synapse Analytics (SQL and Spark pools) and Microsoft Fabric Lakehouse.
• Develop, test, and tune complex SQL and PL/SQL scripts, stored procedures, packages, and functions.
• Collaborate with business users to define analytical goals and build Power BI-ready datasets.
• Integrate AI and machine learning insights using Azure Machine Learning and Azure OpenAI Service.
• Enforce data governance, quality, and security via Purview and Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models

Skills

ETL workflows

Azure Synapse

SQL & PL/SQL

PySpark/Python/Scala

Data modeling

RBAC & security

Power BI

Attention to detail

Agile methodologies

Azure OpenAI / Generative AI

Tools

Azure Data Factory

Azure Synapse

Microsoft Purview

Microsoft Entra ID

Azure OpenAI Service

Job description

CCS Global Tech is a rapidly growing IT company delivering Microsoft-based solutions and analytics capabilities. This role focuses on designing and maintaining robust ETL/ELT pipelines with Azure tools, building governance, and enabling data-driven decisions with Power BI-ready datasets.

You will use Azure Synapse, Data Factory, and SQL/PLSQL to optimize data warehousing, collaborate with business users, and integrate AI insights via Azure OpenAI Service, while ensuring security with Entra ID