SaT-DnA-Data Engineer-Assistant Director

At EY youll have the chance to build a career as unique as you are with the global scale support inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better too. Join us and build an exceptional experience for yourself and a better working world for all.

EYStrategy and Transactions (SaT) DnA Assistant Director

EYs Data n Analytics team is a multidisciplinary technology team delivering client projects and solutions across Data Management Visualization Business Analytics and Automation. The assignments cover a wide range of countries and industry sectors.

The opportunity

Were looking for Assistant Director Data Engineering. The main objective of the role is to support cloud and onprem platform analytics and data engineering projects initiated across engagement teams. The role will primarily involve conceptualizing designing developing deploying and maintaining complex technology solutions which help EY solve business problems for the clients. This role will work closelywith technical architects product and business subject matter experts (SMEs) backend developersand other solution architects and is also onshore facing.

This role will be instrumental in designing developing and evolving the modern data warehousing solutions and data integration buildouts using cutting edge tools and platforms for both onprem and cloud architectures. In this role 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 ETL processing to collect and scrub both structured and unstructured data providing selfserve capabilities (OLAP) in order to create impactful decision analytics reporting.

Your key responsibilities

• Evaluating and selecting data warehousing tools for business intelligence data population data management metadata management and warehouse administration for both onprem and cloudbased engagements
• Strong working knowledge across the technology stack including ETL ELT data analysis metadata data quality audit and design
• Design develop and test in ETL tool environment (GUI/canvas driven tools to create workflows)
• Experience in design documentation (data mapping technical specifications production support data dictionaries test cases etc.
• Provides technical leadership to a team of data warehouse and business intelligence developers
• Coordinate with other technology users to design and implement matters of data governance data harvesting cloud implementation strategy privacy and security
• Adhere to ETL/Data Warehouse development Best Practices
• Responsible for Data orchestration ingestion ETL and reporting architecture for both onprem and cloud (MS Azure/AWS/GCP)
• Assisting the team with performance tuning for ETL and database processes

Skills and attributes for success

• 1214 years of total experience with 8 years in Data warehousing/ Business Intelligence field
• Solid handson 8 years of professional experience with creation and implementation of data warehouses on client engagements and helping create enhancements to a data warehouse
• Strong knowledge of data architecture for staging and reporting schemas data models and cutover strategies using industry standard tools and technologies
• Architecture design and implementation experience with medium to complex onprem to cloud migrations with any of the major cloud platforms (preferably AWS/Azure/GCP)
• 5 years experience in Azure database offerings Relational NoSQL Datawarehouse
• 5 years handson experience in various Azure services preferred Azure Data Factory Kafka Azure Data Explorer Storage Azure Data Lake Azure Synapse Analytics Azure Analysis Services & Databricks
• Minimum of 8 years of handson database design modeling and integration experience with relational data sources such as SQL Server databases Oracle/MySQL Azure SQL and Azure Synapse
• Knowledge and direct experience using business intelligence reporting tools (Power BI Alteryx OBIEE Business Objects Cognos Tableau MicroStrategy SSAS Cubes etc.
• Strong creative instincts related to data analysis and visualization.
• Aggressive curiosity to learn the business methodology data model and user personas.
• Strong understanding of BI and DWH best practices analysis visualization and latest trends.
• Experience with the software development lifecycle (SDLC) and principles of product development such as installation upgrade and namespace management
• Willingness to mentor team members
• Solid analytical technical and problemsolving skills
• Excellent written and verbal communication skills
• Strong project and people management skills with experience in serving global clients

To qualify for the role you must have

• Masters Degree in Computer Science Business Administration or equivalent work experience.
• Fact driven and analytically minded with excellent attention to details
• Handson experience with data engineering tasks such as building analytical data records and experience manipulating and analysing large volumes of data
• Relevant work experience of minimum 12 to 14 years in a big 4 or technology/ consulting set up
• Help incubate new finance analytic products by executing Pilot Proof of Concept projects to establish capabilities and credibility with users and clients. This may entail working either as an independent SME or as part of a larger team

Ideally youll also have

• Ability to think strategically/endtoend with resultoriented mindset
• Ability to build rapport within the firm and win the trust of the clients
• Willingness to travel extensively and to work on client sites / practice office locations
• Strong experience in SQL server and MS Excel plus atleast one other SQL dialect e.g. MS AccessPostgresqlOracle PLSQLMySQLStrong in Data Structures & Algorithm
• Experience of interfacing with databases such as Azure databases SQL server Oracle Teradata etc
• Preferred exposure to JSON Cloud Foundry Pivotal MatLab Spark Greenplum Cassandra Amazon Web ServicesMicrosoft Azure Google Cloud Informatica Angular JS Python etc.
• Experience with Snowflake

What we look for

• A Team of people with commercial acumen technical experience and enthusiasm to learn new things in this fastmoving environment
• An opportunity to be a part of marketleading multidisciplinary team of 1400 professionals in the only integrated global transaction business worldwide.
• Opportunities to work with EY SaT practices globally with leading businesses across a range of industries

What working at EY offers

At EY were dedicated to helping our clients from startups 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 thats right for you

EY Building a better working world

EY exists to build a better working world helping to create longterm 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.