Client Technology Data Engineer

Overview

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.

Join EY and help to build a better working world.

The opportunity

We’re seeking a hands on Senior BI & Automation Engineer operating at Assistant Director level to build reliable analytics, automations, and scalable data solutions that empower decision making across our technology and business functions. You’ll lead end to end delivery—data ingestion, data engineering, BI modeling, automation orchestration, and issue resolution—while demonstrating executive presence, strong relationship building, and a forward thinking mindset.

As an Assistant Director, success in this role requires not only technical excellence but also the ability to lead with authenticity, empower others, and cultivate a respectful, inclusive, and psychologically safe culture.

You will partner closely with product, operations, finance, and technology stakeholders to translate complex requirements into high quality BI and automation solutions that enhance business outcomes and operational excellence.

Your Key Responsibilities

Automation & AI

• Build and refine Power Automate flows, SharePoint integrations, and end-to-end automation solutions.
• Develop Copilot Studio / Power Automate Agent workflows, including shared mailbox scenarios, prompt logic, and exception handling.
  
  

• Design, build, and maintain Power BI datasets, semantic models, dashboards, and paginated reports, ensuring high-performing and accurate refreshes.
• Develop and optimize Azure Data Factory pipelines, Azure SQL/Synapse objects (staging, transformations, data quality, monitoring).
• Implement robust logging, alerting, and automation for data pipelines, ensuring reliability across environments.
  
  

• Proactively troubleshoot refresh failures, schema drift, permissions issues, gateway/service-account problems, and data inconsistencies.
• Partner with Infra/SecOps to resolve firewall, IR, credential, and access challenges.
  
  

• Collaborate effectively with business stakeholders to gather requirements and translate them into BI and automation solutions.
• Communicate status, risks, insights, and decisions with clarity and executive presence.
• Support UAT cycles, stakeholder demos, and production go lives with quality and attention to detail.
  
  

• 5–8+ years of experience in BI/Data Engineering roles.
• Strong hands on expertise in Power BI (DAX, semantic modeling, RLS, Performance optimization) and paginated reporting (Report Builder), along with CI/CD for BI/data assets
• Strong Azure data engineering experience: Azure Data Factory plus Azure SQL/Synapse (Databricks desirable)
• Advanced SQL skills including design and optimisation of database objects (tables/views/procs/functions), parameterised/dynamic SQL, indexing and performance tuning.
• Proven Power Automate delivery experience, SharePoint content automation, and enterprise service-account patterns.
• Demonstrated ability to resolve complex technical issues across data, infrastructure, and access layers.
• Strong communication, documentation, and cross-functional collaboration skills.
• Bonus: Microsoft Fabric, Python, Azure DevOps/Git, OLS/RLS governance, Copilot Studio prompt design.
  
  

• Distributed Systems – Azure ADLS Gen 2, Databricks, Hadoop, HDFS, Spark, Storm,
• ETL Tools – Azure Data Factory, Power BI Dataflows, Power Query, SAP Data Services, SSIS
• Programming Languages – .Net, HTML5, Java, PowerShell, Python, R, Ruby, Shell Scripting, SQL, Visual Studio, XML
• Relational SMP Databases – Azure SQL PaaS, IBM DB2, MySQL, Oracle, PostgreSQL, SQL Server
  
  

• Strong analytical skills and problem-solving ability
• A self-starter, independent-thinker, curious and creative person with ambition and passion
• Good interpersonal, communication, teamwork, and presentation skills
• Customer focused
• Excellent time leadership skills
• Positive and constructive minded
• Takes ownership for continuous self-learning
• Takes the lead and makes decisions in critical times and tough circumstances
• Attention to detail
• High levels of integrity and honesty
  
  

At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more.

Are you ready to shape your future with confidence? Apply today.

To help create an equitable and inclusive experience during the recruitment process, please inform us as soon as possible about any disability-related adjustments or accommodations you may need.

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.