At a Glance
- Tasks: Drive improvements in commercial activities and manage major expenditure categories.
- Company: Join a vibrant team at Ealing Council's Commercial Hub.
- Benefits: Remote work flexibility with occasional office attendance.
- Other info: Great opportunity for early career professionals to shine.
- Why this job: Make a real impact on procurement practices and data analysis.
- Qualifications: Strong Excel, Power BI skills, and analytical abilities required.
The predicted salary is between 35000 - 45000 £ per year.
An exciting opportunity has arisen for an experienced Commercial Analyst to join our Commercial Hub. This role is part of a vibrant team driving improvements in our commercial activities, introducing digital and efficient procurement practices. You will collaborate directly with the Senior Management Team, providing commercial intelligence and clear analysis to stakeholders. As Commercial Analyst, you will be responsible for managing the council’s major categories of expenditure, creating opportunities to improve, leverage and drive best practice procurement across an annual revenue spend of more than £340M.
Responsibilities:
- Support all procurement-related systems, acting as the lead user on the council’s e-procurement software.
- Produce performance dashboards and reports, and illustrate data in formats suitable for Senior Management Reports.
- Identify, collect, migrate and transform data from a variety of internal and external systems, linking different data sets as required.
- Source new datasets for Local Authorities from open sources and other data returns.
- Collaborate with the Senior Management Team and other operational team activities; act as an adaptable communicator and influencer.
Essentially a remote working post, occasional attendance at the Council Offices in Ealing, W5, will be expected.
Qualifications:
- Strong Excel, Power BI and PowerPoint skills.
- Producing performance dashboards and reports.
- Experience of identifying, collecting and migrating data to/from a range of internal and external systems to transform, manipulate and link different data sets as required.
- Sourcing new datasets for Local Authorities from a variety of sources.
- Strong analytical ability, including analysis of data sets.
- Excellent numeracy skills.
- Experience of e-procurement and finance systems.
This role is deemed customer facing and as such you must have a command of spoken English which is sufficient to enable you to effectively perform the role. This requirement relates to Part 7 of the Immigration Act 2016. We therefore welcome applications from all residents of the borough, particularly from candidates who are entering the employment market in the early stages of their career and mid-career professionals, who are currently underrepresented in Ealing’s workforce. This role is subject to Ealing Council’s enhanced vetting process.
Commercial Analyst in Ealing employer: Ealing Council
Join our dynamic team at Ealing Council as a Commercial Analyst, where you will play a pivotal role in enhancing our procurement practices while enjoying the flexibility of remote work. We foster a collaborative and inclusive work culture that prioritises employee growth, offering opportunities to engage with senior management and develop your analytical skills in a supportive environment. With a focus on innovation and community impact, we are committed to creating a workplace that values diversity and empowers all employees to thrive.
StudySmarter Expert Advice🤫
We think this is how you could land Commercial Analyst in Ealing
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Ealing Council. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Commercial Analyst in Ealing
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Ealing Council.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Ealing Council's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Ealing Council
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Ealing Council.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Ealing Council will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Ealing Council employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
