Senior Azure Data Engineer and Power BI Consultant

EY; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Support & coaching

Skills development

Flexible work style

Job summary

EY is seeking a senior Azure Data Engineer with Power BI expertise to join our GDS Data Insights team in Consulting. You will deliver Microsoft BI solutions, design end-to-end ETL pipelines, and build interactive dashboards for global clients using Power BI, Azure Data Factory, and Databricks.

You will collaborate with stakeholders, lead engagements, and mentor junior team members while ensuring high-quality deliverables within timelines.

Qualifications

• Bachelor's or master's degree in a relevant field.
• 4–7 years of experience, preferably in a professional services firm.
• Excellent communication skills; consulting experience preferred.
• Analytical ability to manage multiple projects and prioritize tasks.
• Operate independently or with minimal supervision.

Responsibilities

• Manage multiple client engagements.
• Analyse business requirements with stakeholders and define information architecture.
• Gather requirements and perform data cleansing, extraction and loading.
• Translate business requirements into technical code.
• Create dashboards and reports in Power BI, connecting to varied data sources with DAX.
• Design and build ETL/Azure Data Factory processes for ODS, Staging, and Data Warehousing.
• Develop solutions in Databricks, Scala/Spark, and T-SQL to process large datasets.
• Design SQL schema, database objects, and T-SQL queries.

Skills

Power BI

Azure Data Factory

Databricks

Azure Synapse

Data Modelling

DAX

Power Query

SQL

SSAS

Azure ML

Education

Bachelor's/Master's degree

Tools

Azure Databricks

Scala

Spark

SQL

Job description

DE-NCLC-PBI Developer-GDSN02 At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Azure Data Engineer + Power BI Senior– Consulting

As part of our GDS Consulting team, you will be part of NCLC team delivering specific to Microsoft account. You will be working on latest Microsoft BI technologies and will collaborate with other teams within Consulting services.

The opportunity

We’re looking for resources with expertise in Microsoft BI, Power BI, Azure Data Factory, Data Bricks to join the group of our Data Insights team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of our service offering.

Your key responsibilities

• Responsible for managing multiple client engagements.
• Understand and analyse business requirements by working with various stakeholders and create the appropriate information architecture, taxonomy and solution approach.
• Work independently to gather requirements, cleansing extraction and loading of data.
• Translate business and analyst requirements into technical code.
• Create interactive and insightful dashboards and reports using Power BI, connecting to various data sources and implementing DAX calculations.
• Design and build complete ETL/Azure Data Factory processes moving and transforming data for ODS, Staging, and Data Warehousing.
• Design and development of solutions in Data Bricks, Scala, Spark, SQL to process and analyze large datasets, perform data transformations, and build data models.
• Design SQL Schema, Database Schema, Stored procedures, function, and T-SQL queries.

Skills and attributes for success

• Collaborating with other members of the engagement team to plan the engagement and develop work program timelines, risk assessments and other documents/templates.
• Able to manage Senior stakeholders.
• Experience in leading teams to execute high quality deliverables within stipulated timeline.
• Skills in PowerBI, Azure Data Factory, Databricks, Azure Synapse, Data Modelling, DAX, Power Query, Microsoft Fabric.
• Strong proficiency in Power BI, including data modelling, DAX, and creating interactive visualizations.
• Solid experience with Azure Databricks, including working with Spark, PySpark (or Scala), and optimizing big data processing.
• Good understanding of various Azure services relevant to data engineering, such as Azure Blob Storage, ADLS Gen2, Azure SQL Database/Synapse Analytics.
• Strong SQL Skills and experience with of one of the following: Oracle, SQL, Azure SQL.
• Good to have experience in SSAS or Azure SSAS and Agile Project Management.
• Basic Knowledge on Azure Machine Learning services.
• Excellent Written and Communication Skills and ability to deliver technical demonstrations.
• Quick learner with “can do” attitude.
• Demonstrating and applying strong project management skills, inspiring teamwork and responsibility with engagement team members.

To qualify for the role

• A bachelor's or master's degree
• A minimum of 4-7 years of experience, preferably background in a professional services firm.
• Excellent communication skills with consulting experience preferred.
• Ideally, you’ll also have Analytical ability to manage multiple projects and prioritize tasks into manageable work products.
• Can operate independently or with minimum supervision.

What working at EY offers

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.