Power BI Data Engineer II

Job description

Power BI Data Engineer II

The opportunity

Fueled by strategic investment in technology and innovation, Client Technology seeks to drive growth opportunities and solve complex business problems for our clients through building a robust platform for business and powerful product engine that are vital to innovation at scale. As part of Client Technology, you’ll work with technologists and business experts, blending EY’s deep industry knowledge and innovative ideas with our platforms, capabilities, and technical expertise. As a catalyst for change and growth, you’ll be at the forefront of integrating emerging technologies from AI to Data Analytics into every corner of what we do at EY. That means more growth for you, exciting learning opportunities, career choices, and the chance to make a real impact.

Your key responsibilities

·  Leads the delivery of processes to extract, transform and load data from disparate sources into Power BI reporting that is consumable by end users, for projects with moderate complexity, using strong technical capabilities
·  Designs, develops and produces data models of relatively high complexity, leveraging a sound understanding of data modelling standards to ensure high quality
·  Builds networks with project teams across EY to help define and deliver business value
·  Leading the production of high-quality data engineering deliverables, helping to ensure project timelines are met, and providing informal mentoring / training to junior members of the team
·  Leading the delivery of data quality reviews including data cleansing where required to ensure integrity and quality
·  Leading the delivery of complex reporting solutions based on composite models to manage data within the organization, for a small to medium-sized project
·  Resolving escalated design and implementation issues with moderate to high complexity
·  Providing technical expertise to maximize value from current applications, solutions, infrastructure and emerging technologies and seek to continuously improve internal processes
·  Developing working relationships with peers across other engineering teams and beginning to collaborate to develop leading data engineering solutions
·  Driving adherence to the relevant data engineering and data modelling processes, procedures and standards

Skills and attributes for success

·  Data Visualization - ability to design and implement informative reporting that translates data into business value, strong analytical skills
·  Data Integration (Sourcing, Storage and Migration) - capability to design and implement models, capabilities and solutions to manage data within the enterprise (structured and unstructured, data archiving principles, data warehousing, data sourcing, etc.).  This includes the data models, storage requirements and migration of data from one system to another
·  Data Quality, Profiling and Cleansing - capability to review (profile) a data set to establish its quality against a defined set of parameters and to highlight data where corrective action (cleansing) is required to remediate the data
·  B.S. in Actuarial, Behavior Economics, Computer Science, Data Analytics, Data Science, Econometrics, Engineering, IT, Cyber Security, or related field preferred.

To qualify for the role, you must have

·  Data Visualization – Power BI, SQL Server Reporting Services, Power BI Report Server, Power BI Report Builder
·  Data Access Tools – MS SQL Server Management Studio
·  Workspace Management – Power BI App, Permissions, Pro vs Premium
·  ETL / ELT / Data Fabric Tools – Power BI Dataflows, Power Query M, Composite Models
·  Programming Languages – SQL, T-SQL, DAX
·  Source Control / Release Pipelines – Azure DevOps

Ideally, you'll also have

·  Big Data Distributed Systems – Azure Synapse Analytics
·  Data Visualization – SQL Server Reporting Services, Tableau, Spotfire
·  Data Warehousing Platforms – Azure SQL Warehouse / Azure Synapse
·  Document Database – SharePoint, MongoDB
·  ETL / ELT / Data Fabric Tools – Alteryx, Azure Data Factory, SQL Server Integration Services
·  Low Code Apps – Power Automate, Power Apps
·  Programming Languages – Node.js, React.js, Java, Python (big plus), R (big plus)

What we look for

·  Strong analytical skills and problem-solving ability
·  A self-starter, independent-thinker, curious and creative person with ambition and passion
·  Excellent inter-personal, communication, collaboration, and presentation skills
·  Customer focused
·  Excellent time management skills
·  Positive and constructive minded
·  Takes responsibility 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

What we offer

EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations – Argentina, China, India, the Philippines, Poland and the UK – and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We’ll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.

·  Continuous learning:You’ll develop the mindset and skills to navigate whatever comes next.
·  Success as defined by you:We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
·  Transformative leadership:We’ll give you the insights, coaching and confidence to be the leader the world needs.
·  Diverse and inclusive culture:You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

About EY

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.

If you can demonstrate that you meet the criteria above, please contact us as soon as possible.

The exceptional EY experience. It’s yours to build.