EY Jobs

Job Information

EY Data Engineer (Senior Consultant / Manager), Strategy & Transactions in Sydney, Australia

Data Engineer (Senior Consultant / Manager), Strategy & Transactions

Strategy and Transactions

Requisition # SYD0045B

Post Date Sep 09, 2020

The Covid-19 pandemic is creating seismic challenges around the world. Our purpose, to build a better working world, has never been more important. Life at EY has been transformed dramatically but our strong culture of flexible and remote working has helped EY people navigate new ways of working and remain connected with each other and our clients.

A better working world truly starts with the people at EY who are building it every day. Now more than ever we need talented people from diverse backgrounds to help our clients navigate the complexities of this Transformative Age: people with the passion, curiosity and drive to make things better.

The opportunity

Due to growth, we currently have an opportunity for a Senior Consultant / Manager level Data Engineer to join our Analytics team in Sydney. This role will be instrumental in designing, developing, and evolving the modern data warehousing solutions and data integration build-outs using cutting edge tools and platforms for both on-prem and cloud architectures. You will be coming up with design specifications, documentation, and development of data migration mappings and transformations for a modern Data Warehouse set up/data mart creation and define robust processing to collect and scrub both structured and unstructured data providing self-serve capabilities in order to create impactful decision analytics reporting.

Your key responsibilities

  • Evaluating and selecting data warehousing tools for businessintelligence, data population, data management, metadata management andwarehouse administration for both on-prem and cloud-based engagements

  • Design, develop, and test in ETL toolenvironment (GUI/canvas driven tools to create workflows)

  • Provide technical leadership to a team of datawarehouse and business intelligence developers

  • Coordinate with other technology users todesign and implement matters of data governance, data harvesting, cloudimplementation strategy, privacy, and security

  • Adhere to ETL/Data Warehouse development BestPractices

  • Responsible for Data orchestration, ingestion,ETL and reporting architecture for both on-prem and cloud (MS Azure)

  • Assisting the team with performance tuning forETL and database processes

Skills and attributes for success


  • Experience in design documentation (datamapping, technical specifications, production support, data dictionaries,test cases, etc.)

  • Strong working knowledge across the technologystack including ETL, ELT, data analysis, metadata, data quality, audit anddesign

  • Experience withcreation and implementation of data warehouses on client engagements andhelping create enhancements to a data warehouse

  • Strong knowledge ofdata architecture for staging and reporting schemas, data models and cutoverstrategies using industry standard tools and technologies

  • Architecture designand implementation experience with medium to complex on-prem to cloudmigrations with any of the major cloud platforms (preferably Azure)

  • Hands-on databasedesign, modelling and integration experience with relational data sources,such as SQL Server databases, Oracle/MySQL, Azure SQL and Azure Synapse

  • 2+ years hands-onexperience in various Azure services preferred – Azure Data Factory, Kafka,Azure Data Explorer, Storage, Azure Data Lake, Azure Synapse Analytics, AzureAnalysis Services & Databricks, Azure Data Science

Ideally, you’ll also have

  • Knowledge and directexperience using business intelligence reporting tools (Power BI, Alteryx,OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, SSAS Cubes etc.)

  • Strong creativeinstincts related to data analysis and visualization

  • Strong understandingof BI and DWH best practices, analysis, visualization, and latest trends

  • Experience with thesoftware development lifecycle (SDLC) and principles of productdevelopment such as installation, upgrade and namespace management

What working at EY offers

Our Total Rewards package includes:

  • e.g. remoteworking, flexible start and finish times

  • career and learning development e.g., career mentoring

  • an extensive range of wellbeing and benefitofferings e.g. Salary packaging, parental leave and support, health checks

Who we are

EY is anoffering a vast range of internal networks including Ability EY, our disability network, Unity, our LGBTI network and our Aboriginal and Torres Strait Islander network enabling us all to embrace and value the diverse society we live within. If you have any support or access requirements, we encourage you to advise us at the time of application via contactrecruitment@au.ey.com or +61 1800 017 666.

Make your mark. Apply Now!

The preferred applicant will be subject to employment screening by EY or by their external third-party provider.

© 2020 Ernst & Young Australia. All Rights Reserved. Liability limited by a scheme approved under Professional Standards Legislation.