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.
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 email@example.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.