
Job Description & Key Responsibilities
Ernst & Young (EY) is one of the worldโs leading professional services firms, offering assurance, tax, transaction and advisory services to a diverse portfolio of clients across industries. With a presence in more than 150 countries, EY combines deep industry knowledge with cuttingโedge technology to help organisations navigate complex challenges and create sustainable value. The firmโs culture is built around its purpose โ "building a better working world" โ and it invests heavily in learning, mentorship and career development for its people.
The Business Consulting Risk practice at EY focuses on helping clients identify, assess and mitigate a wide spectrum of risks, ranging from enterpriseโwide strategic risks to technologyโdriven vulnerabilities. Within this practice, the National team works across sectors, giving consultants exposure to varied business environments and the opportunity to develop a holistic riskโmanagement skill set. As an Associate Consultant, you will be part of a collaborative team that delivers dataโdriven insights and robust risk frameworks to Fortuneโ500 companies and emerging businesses alike.
**Key Responsibilities**
1. Design, develop and maintain endโtoโend data pipelines using Python, SQL and Databricks to support riskโanalytics engagements.
2. Extract, transform and load (ETL) structured and semiโstructured data from multiple sources, ensuring data quality and consistency.
3. Write optimized SQL queries and scripts for adโhoc analysis and reporting.
4. Assist senior consultants in building riskโassessment models, dashboards and visualisations for client presentations.
5. Participate in client workshops to understand business requirements and translate them into technical specifications.
6. Conduct data validation, testing and documentation to ensure productionโready deliverables.
7. Stay updated with Azureโbased data platforms and recommend cloudโenabled solutions where appropriate.
8. Contribute to knowledgeโsharing sessions within the team and help build reusable assets.
9. Support compliance and internalโcontrol reviews by providing accurate data extracts and analytical support.
10. Collaborate with crossโfunctional teams, including technology and people advisory services, to deliver integrated risk solutions.
**Tech Stack**: Python, SQL, Databricks, Azure Data Lake/SQL, Power BI/Tableau for visualisation, Git for version control.
**Growth Path**: Starting as an Associate Consultant, you can progress to Senior Consultant, Manager, Senior Manager and eventually Director or Partner, with regular performance reviews, formal training programmes and opportunities for international assignments.
**Why Join EY**: EY offers a globally recognised brand, exposure to highโimpact projects, a structured learning ecosystem (EYU โ EY University), and a culture that values diversity, inclusion and wellbeing. Fresh graduates get handsโon experience with cuttingโedge technologies, mentorship from industry leaders and a clear roadmap for career advancement.