Sr Azure Data Analyst, Raleigh, NC, US

Intellibee; Raleigh (NC); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

Future Planning

GC Assistance

Job summary

IntelliBee is seeking a Senior Data Analyst to design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure. The role focuses on transforming complex data into business insights and driving advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services.

Responsibilities include designing ETL/ELT pipelines, managing Synapse and Fabric Lakehouse, developing SQL/PLSQL scripts, building Power BI datasets,

Qualifications

• 7+ years of enterprise data analytics experience.
• Experience in Azure Synapse, Data Factory, cloud data warehousing.
• Advanced SQL/PLSQL and performance tuning skills.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines in Azure.
• Manage and optimize Azure Synapse Analytics and Fabric Lakehouse.
• Develop and tune complex SQL/PLSQL scripts and stored procedures.
• Collaborate with business users to define analytical goals and build Power BI-ready datasets.
• Integrate AI/ML insights using Azure ML and OpenAI Service.
• Enforce data governance, quality, and security with Purview and Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models.

Skills

Azure Synapse Analytics

Azure Data Factory

SQL

PySpark / Python / Scala

Data modelling

RBAC / Entra ID security

Power BI dataflows

Azure OpenAI / generative AI data

Agile methodologies

Job description

Client requires the services of a Senior Data Analyst that will help us design, manage, and optimize enterprise data pipelines, data warehouses, and analytics solutions within Microsoft Azure. This role transforms complex data into business insights and drives advanced analytics using Azure Synapse Analytics, Microsoft Fabric, and Azure AI services. The key responsibilities for this position will include the following:

• Design, build, and maintain robust enterprise ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, or PL/SQL procedures.
• 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 to support data integration.
• 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 Microsoft Purview and Microsoft Entra ID.
• Build cross-functional reporting, dashboards, and predictive analytics models

Skill Matrix:

• Experience in enterprise data analytics, engineering, and designing complex ETL workflows. Required 7 Years
• Expertise in Azure Synapse Analytics, Azure Data Factory, and cloud data warehousing Required 4 Years
• Advanced SQL and PL/SQL skills, including query optimization, performance tuning, and indexing strategies Required 7 Years
• Hands-on experience with PySpark, Python, or Scala Required 6 Years
• Experience with data modelling, performance tuning, and cost optimization in Azure Required 4 Years
• Strong knowledge of Microsoft Entra ID, role-based access control (RBAC), and cloud security Required 3 Years
• Familiarity with Power BI semantic models and dataflows Required 3 Years
• Knowledge of Azure OpenAI or generative AI data integration Highly desired 3 Years
• Ability to organise, prioritise, and follow complex and/or detailed technical procedures Required 7 Years
• Experience with Agile (Scrum, Kanban, or SAFe) development Required 3 Years

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.