Senior Azure Data Engineer and Power BI Consultant

DE-NCLC-Power Automate Desktop-GDSN02

At EY, we’re all in to shape your future with confidence. 

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. 

Join EY and help to build a better working world. 

 

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, 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 is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

Experience Level

Senior Level