Azure Data Engineer

Capgemini; Mumbai, Bengaluru, Pune District; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

A leading technology consulting firm is looking for a data specialist to gather and analyze large datasets for business insights. Responsibilities include developing Power BI dashboards and utilizing Azure data services for data ingestion and orchestration. The ideal candidate should have strong skills in data analysis and visualization, as well as experience in data modeling. Join this innovative team to contribute to impactful data-driven decisions.

Qualifications

• Experience in gathering and analyzing large datasets.
• Proficiency in developing Power BI dashboards and reports.
• Familiarity with Azure data services is a plus.

Responsibilities

• Gather, analyze, and interpret large datasets for insights.
• Develop and maintain Power BI dashboards.
• Work with Azure data services for data ingestion and orchestration.
• Design star/snowflake schema data models.

Skills

Data Analysis

Business Insights

Power BI

DAX

Azure Data Factory

Data Modelling

Cross-Functional Collaboration

Tools

Azure Synapse Analytics

Azure SQL Database

Azure Data Lake Storage

Job description

Key Responsibilities

Data Analysis & Business Insights

• Gather, analyze, and interpret large datasets to produce meaningful insights and recommendations.
• Work closely with business stakeholders to understand requirements and translate them into analytical solutions.
• Perform exploratory data analysis (EDA) to identify trends, patterns, and anomalies.

Power BI Reporting & Visualization

• Develop, publish, and maintain Power BI dashboards and reports with advanced visualizations.
• Create DAX measures, calculated columns, and optimized data models.
• Implement row-level security (RLS) and ensure optimal dashboard performance.
• Schedule automated refreshes and manage workspace governance.

Azure Data Platform

• Work with Azure data services, including:
  • Azure Data Factory (ADF) pipelines, data ingestion, orchestration
  • Azure Synapse Analytics or Azure SQL Database
  • Azure Data Lake Storage (ADLS)
  • (Optional) Azure Databricks or Azure Functions
• Build scalable data pipelines and ETL/ELT solutions for structured and unstructured datasets.
• Manage data storage, transformation, and processing workflows in Azure.

Data Modelling & Governance

• Design and optimize star/snowflake schema data models.
• Ensure data quality, data consistency, and strong governance practices.
• Support data cataloging, metadata management, and compliance with security standards.

Cross-Functional Collaboration

• Collaborate with Product, Technology, and Business teams to define KPIs and reporting needs.
• Present findings through reports, presentations, and storytelling formats.
• Support ad-hoc analysis and business decision-making.