Senior Azure Data Scientist: ETL, AI & Analytics Lead

InstantServe LLC; Raleigh (NC); On-site; USD 120,000 - 160,000; Full time

Job summary

InstantServe LLC is seeking an experienced Data Scientist/Data Analyst to design, develop, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions using Microsoft Azure technologies. The role emphasizes Azure Synapse Analytics, Azure Data Factory, Fabric Lakehouse, and advanced SQL/PL-SQL with Python-based data processing.

The candidate will integrate AI/ML capabilities to transform complex data into actionable business insights, build Power BI-ready datasets,

Qualifications

• 7+ years in enterprise data analytics, data engineering and ETL design.
• 4+ years with Azure Synapse Analytics, Data Factory and cloud DW.
• 7+ years SQL/PL-SQL experience with optimization and indexing.
• 6+ years Python/PySpark/Scala.
• 3+ years with Azure OpenAI or Generative AI data integration is desirable.

Responsibilities

• Design, develop, and manage enterprise ETL/ELT pipelines on Azure.
• Optimize Azure Synapse SQL, Spark pools, and Fabric Lakehouse.
• Develop and optimize SQL/PL-SQL scripts, stored procedures, and functions.

Skills

Azure Data Factory

Azure Synapse Analytics

SQL/PL-SQL

Python/PySpark/Scala

Power BI

Azure OpenAI / Generative AI

Data modeling

Agile methods

Data governance & security

Tools

Microsoft Fabric Lakehouse

Azure Data Factory pipelines

Microsoft Purview & Entra ID

Spark pools

Job description

InstantServe LLC is seeking an experienced Data Scientist/Data Analyst to design, develop, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions using Microsoft Azure technologies. The role emphasizes Azure Synapse Analytics, Azure Data Factory, Fabric Lakehouse, and advanced SQL/PL-SQL with Python-based data processing.

The candidate will integrate AI/ML capabilities to transform complex data into actionable business insights, build Power BI-ready datasets,