Executive, Data Analytics, London

Key Skills

Actuarial , Alteryx, D3.js, Data Analysis, Data Analytics, Finance, Microsoft-Excel, PowerBI, Python Programming, Qlik Sense, QlikView, R Programming, Spotfire, SQL, Tableau, VBA

Job Description

The Opportunity 

You would have the opportunity to work across a breadth of sector and technical offerings, and as your career progresses you would typically expect to specialise by sector and or technical competency.

Our projects often involve managing multiple stakeholders and high degrees of complexity and uncertainty. Decision making in this environment requires strong client management and communication skills, in addition to rigorous analytical techniques and excellent data handling skills.

Our work typically includes constructing purpose-built databases storing large client datasets for our analytical models, using data transformation tools, visualisation tools, programming and statistical tools (such as R and Python), to derive insight through data modelling and simulations, in a fast-moving transaction environment.

The analytics team is based in London and Manchester. We operate as a national team and our engagements normally involve multi-national clients. This role will most likely require some travel within the UK and could require overseas working from time to time.

Role Responsibilities

• Support the project team in day-to-day activities throughout the life-cycle of an assignment – requirements definition, specification, data collection, solution design, development, testing, documentation, implementation, and user training

• Design and build complex database models and insightful visualisation dashboards to perform analysis on large diverse datasets

• Work independently or with a team in designing analytical solutions (data pipelines, visualisations, machine learning models), undertaking proof-of-concepts, and implementing these solutions to help clients to compete effectively in this dynamic environment with the support of Directors and Partners

• Work directly with clients as well as other EY specialist teams to develop formal deliverables for clients including data dashboards (Excel or other data visualisation tools), web hosted solutions, Word reports, and PowerPoint presentations

• Explain complex technical concepts underpinning your analysis in simple terms to clients to help them understand how their business needs are being addressed

• Manage stakeholders’ expectations in relation to deliverables

• Identify risk on the assignment, involving Engagement Manager/ Director / Partner appropriately in its resolution

• Take ownership of your tasks and work collaboratively with members of different grades within and across teams

Skills & Attributes

To qualify for the role you must have

• Qualification in a Highly Numerate Subject e.g. Computer Science, Operational Research, Statistics, Mathematics, Engineering, or Actuarial Science

• Experience in managing projects, from defining requirements, designing project plans, and managing performance against plan through the project lifecycle

• Experience working with large datasets (creating databases, architecting efficient structures, and writing optimised stored procedures & queries)

• Experience in building models in R, and Python programming languages and libraries in a client-facing role

• Strong oral and written communication skills – including experience of writing reports, drafting presentations and developing data visualisation dashboards to effectively communicate EY’s advice to clients

• Visually creative, with a good understanding of UX aesthetics

Ideally you'll also have some of the following:

• Experience of working with visualisation tools including Power BI, Tableau, Tibco Spotfire, RShiny, plotly-dash, D3.js, or QlikSense

• Experience in SQL (any variant), Alteryx, MS Excel and VBA

• Experience of working in a professional services environment, including exposure to high profile transactions

• Experience in applying various analytical techniques (e.g. naïve bayes, decision trees, random forest, xgboost and k-means), to calculate problems such as predictive forecasting, prescriptive action, capacity planning. 

• Experience of financial reporting, and an understanding of basic corporate finance and accounting concepts

• Experience of working in teams, managing the workload of junior team members, and coaching junior staff

• Knowledge and experience relating to one or more specific sectors is preferred

What we look for

Proactive dedicated team member willing to share skills and work collaboratively with clients and EY colleagues. With the ability to identify particular use care requirements, the ideal candidate will be able to design appropriate solutions to load data and deliver interface tools to provide repeatable visual output. If you have a strong business acumen and technical knowledge to translate commercial problems into data requirement and formulate analytics solutions, this role could be for you.