EY is seeking a Manager – Data Engineering to join its Data and Analytics team in Hyderabad. This role offers the opportunity to work on diverse client projects across multiple countries and industries, focusing on cloud and on-premises platform analytics and data engineering. The successful candidate will design, develop, deploy, and maintain complex technology solutions that address business challenges for EY’s clients. Collaborating closely with technical architects, product and business subject matter experts, and developers, this position plays a key role in building modern data warehousing solutions and data integration frameworks using cutting-edge tools and platforms. The role involves creating design specifications, documentation, and developing data migration mappings and transformations to support data marts and robust ETL processes for both structured and unstructured data, enabling impactful decision analytics reporting.
Key Responsibilities
- Evaluate and select data warehousing tools for business intelligence, data management, metadata management, and warehouse administration across on-prem and cloud environments.
- Demonstrate strong expertise across the technology stack, including ETL/ELT processes, data analysis, metadata, data quality, audit, and design.
- Design, develop, and test ETL workflows using GUI-driven tools.
- Prepare detailed design documentation, including data mappings, technical specifications, production support materials, data dictionaries, and test cases.
- Provide technical leadership and guidance to a team of data warehouse and business intelligence developers.
- Collaborate with technology users to implement data governance, cloud strategies, privacy, and security measures.
- Adhere to ETL and data warehouse development best practices.
- Manage data orchestration, ingestion, ETL, and reporting architecture for both on-premises and cloud platforms (MS Azure, AWS, GCP).
- Assist with performance tuning of ETL and database processes.
Required Qualifications
- Bachelor’s degree in Computer Science or a related field; advanced degree or equivalent business experience preferred.
- Minimum of 9 years of total experience, with at least 6 years in data warehousing and business intelligence.
- Hands-on experience designing, implementing, and enhancing data warehouses on client engagements.
- Strong knowledge of data architecture, including staging and reporting schemas, data models, and cutover strategies using industry-standard tools.
- Experience with medium to complex on-premises to cloud migrations on major cloud platforms, preferably AWS, Azure, or GCP.
- At least 3 years of experience with Azure database offerings (Relational, NoSQL, Data Warehouse).
- Hands-on experience (2+ years preferred) with Azure services such as Azure Data Factory, Kafka, Azure Data Explorer, Storage, Azure Data Lake, Azure Synapse Analytics, Azure Analysis Services, and Databricks.
- Minimum 3 years of experience in database design, modeling, and integration with relational databases like SQL Server, Oracle, MySQL, Azure SQL, and Azure Synapse.
- Proficiency with business intelligence reporting tools such as Power BI, Alteryx, OBIEE, Business Objects, Cognos, Tableau, MicroStrategy, and SSAS Cubes.
- Strong analytical, problem-solving, and communication skills.
- Experience mentoring team members and working within the software development life cycle (SDLC).
Preferred Qualifications and Benefits
- Ability to think strategically with an end-to-end, result-oriented mindset.
- Strong interpersonal skills to build rapport within the firm and gain client trust.
- Willingness to travel extensively and work at client sites or practice office locations.
- Opportunity to be part of a market-leading, multi-disciplinary team of over 1,400 professionals in a global transaction business.
- Access to EY Global Delivery Services (GDS), a dynamic global network spanning six locations, offering diverse career opportunities across business disciplines.
- Continuous learning environment fostering skill development and adaptability.
- Flexible work culture enabling meaningful impact and personal success.
- Supportive leadership with coaching and confidence-building initiatives.
- Inclusive culture that embraces diversity and empowers individuals to use their voices.
EY is committed to building a better working world by creating long-term value for clients, people, and society. Enabled by data and technology, EY’s diverse teams across more than 150 countries provide trusted assurance and help clients grow, transform, and operate effectively. Join EY to contribute your unique perspective and build an exceptional career.