At a Glance
- Tasks: Analyse financial data, create reports, and support decision-making with actionable insights.
- Company: Join EY, a global leader in finance and consulting, committed to building a better working world.
- Benefits: Competitive salary, career growth opportunities, and a dynamic work environment.
- Other info: Fast-paced environment with continuous improvement and automation initiatives.
- Why this job: Be part of a transformative team using data to drive impactful business decisions.
- Qualifications: 2+ years in data analysis, strong SQL and Power BI skills, and a knack for problem-solving.
The predicted salary is between 45000 - 55000 £ per year.
At EY, we’re all in to shape your future with confidence.
We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Join EY and help to build a better working world.
- UKI Finance Job Description
- Role Title: Data Analyst
- Business Unit: UKI Finance
- Reports to: UKI Head of Reporting & Data Analytics
- JOB OVERVIEW
An opportunity has arisen within the UKI Finance team for a Data Analyst.
The role will support UKI Finance reporting and analytics activity across Service Lines, working closely with Finance Managers, Operations teams and business leadership to provide accurate, timely and insightful management information.
The role will involve developing and maintaining reports, dashboards and analysis, gathering and challenging stakeholder requirements, and improving existing reporting assets so they are robust, scalable and fit for purpose.
A key part of the role will be interpreting financial and operational data, explaining variances and supporting stakeholders to identify appropriate actions.
Candidates will need to demonstrate strong analytical capability, sound understanding of financial reporting, and a rigorous approach to data preparation, validation and quality assurance.
They will need to build credibility with stakeholders, manage competing priorities and use problem-solving skills to resolve issues and improve reporting processes.
This role sits within a fast-changing environment, with ongoing changes to team processes, systems and reporting tools as the firm undertakes a Global Reporting Transformation Programme.
The successful candidate will therefore need to be adaptable, comfortable working through change, and able to contribute to continuous improvement and more automated, controlled reporting solutions.
RESPONSIBILITIES
- Produce, maintain and improve regular and ad-hoc financial performance reports, dashboards and analytics using Power BI, Excel and other approved reporting tools.
- Analyse financial and operational data to identify trends, variances, risks, opportunities and actionable business insights.
- Present analysis, recommendations and key messages clearly to stakeholders, supporting Finance Managers, Operations teams and business leaders in decision-making.
- Work with stakeholders to understand, challenge and prioritise reporting requirements, translating these into robust, scalable reporting and analytical solutions.
- Integrate data from multiple business systems and sources, applying appropriate validation, quality checks and controls to maintain data integrity and consistency.
- Identify and deliver opportunities to automate, standardise and streamline reporting processes, reducing manual effort and duplication.
- Maintain documentation, support implementation and testing activity, resolve reporting issues, and contribute to business transformation and continuous improvement across UKI Finance.
REQUIREMENTS
- 2+ years' experience as a Data Analyst, Reporting Analyst, Financial Analyst or similar role, working with financial, operational or management reporting data.
- Demonstrable experience delivering end-to-end Business Intelligence and reporting solutions, from requirements gathering and data modelling through to development, testing, deployment and support.
- Advanced SQL and T-SQL development skills, including complex query development, data transformation, stored procedures, optimisation and troubleshooting.
- Advanced Power BI development skills, including semantic model design, data modelling, DAX, Power Query (M Language), report development and performance optimisation.
- Advanced Excel skills, including complex formulas, data modelling, Power Query, Pivot Tables and reporting automation.
- Practical experience using Python for data analysis, automation and reporting
- Experience working with data from multiple systems and sources, including data integration, preparation, validation, quality checking and troubleshooting.
- Good understanding of finance reporting concepts, including performance reporting, key metrics, variance analysis and data quality controls.
- Strong numerical and analytical skills, with the ability to interpret complex data and translate it into clear business insight and actionable recommendations.
- Ability to design effective visualisations and dashboards that communicate analytical findings clearly and support informed decision-making.
- Comprehensive understanding of relational databases, data structures, data governance and reporting best practices.
- Well-developed communication and stakeholder management skills, with the ability to gather, challenge and translate business requirements into scalable analytical solutions.
- Demonstrable ability to present complex analysis, recommendations and key messages clearly to business, finance and operational stakeholders.
- Highly organised, with excellent attention to detail and the ability to manage multiple priorities and deadlines in a fast-paced environment.
- Commitment to quality, accuracy, governance, controlled delivery and the responsible handling of confidential business information.
- Proven experience identifying opportunities to automate, standardise and continuously improve reporting processes, controls and ways of working.
DESIRABLE
- Exposure to Databricks and modern cloud-based data platforms, with an understanding of data engineering, data processing and analytics concepts.
- Experience using Microsoft Fabric, Azure data and analytics services, or other enterprise reporting and analytics platforms.
- Experience building Power Apps solutions and creating Power Automate workflows to improve business processes and reporting efficiency.
- Previous experience working in a project, transformation or reporting modernisation environment.
- Proven ability to own and deliver reporting, analytics or process improvement initiatives end-to-end, from requirements definition through implementation and support.
- EY | Building a better working world
EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.
Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.
EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions.
Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.
#J-18808-Ljbffr
Data Analyst - Senior Associate - Permanent - Newcastle employer: EY
EY is an exceptional employer that fosters a collaborative and innovative work culture in Manchester, where you can thrive as an Industry Strategy & Growth Lead. With comprehensive benefits including medical coverage and flexible vacation policies, alongside a strong commitment to professional development, EY empowers its employees to grow and excel in their careers while making a meaningful impact in the consumer and health sectors.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst - Senior Associate - Permanent - Newcastle
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like EY!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Analyst - Senior Associate - Permanent - Newcastle at EY.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like EY.
✨Apply Directly through Our Website
When you find a suitable opening like Data Analyst - Senior Associate - Permanent - Newcastle at EY, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Analyst - Senior Associate - Permanent - Newcastle
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at EY, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at EY. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at EY
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at EY!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
