DE-NCLC-PBI Developer-GDSN02

EY; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

EY is seeking a Microsoft BI professional to join the Data Insights team in India. You will work on Power BI dashboards, Azure Data Factory pipelines, and Data Bricks to deliver data-driven insights for the Microsoft account.

The role involves translating business requirements into technical solutions, building scalable ETL processes, and collaborating with cross-functional teams to drive outcomes. Strong communication and project leadership are essential.

Qualifications

• Bachelor's or master's degree.
• 4–7 years of experience, preferably in a professional services firm.
• Excellent communication skills; consulting experience preferred.

Responsibilities

• Understand and analyse business requirements by working with various stakeholders and create the appropriate information architecture, taxonomy and solution approach.
• 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

Power BI

Azure Databricks

SQL

DAX

Data Modeling

Stakeholder mgmt

Analytical skills

Education

Bachelor's degree

Master's degree

Tools

Azure Data Factory

Data Bricks

Scala

Spark

Python

Job description

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.

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

• 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.
• 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, you must have

• 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

At EY, we’re dedicated to helping our clients, from start-ups to Fortune 500 companies - and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• 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.