At a Glance
- Tasks: Support business users with CRM processes and manage data for projects.
- Company: Join Inspired PLC, a leading UK provider of energy and sustainability advisory services.
- Benefits: Enjoy flexible hours, training opportunities, and a 4pm finish on Fridays.
- Other info: This is a home-based role with occasional office travel.
- Why this job: Make a real impact in the climate emergency while developing your career in a supportive environment.
- Qualifications: Proficient in Microsoft Office, advanced Excel, and SQL; strong communication and problem-solving skills required.
The predicted salary is between 28800 - 43200 € per year.
Inspired is a market leading, technology-enabled provider of energy and sustainability solutions in the UK – supporting businesses to transition to net zero carbon and manage their response to climate change. Established in 2000, we became the first publicly quoted advisor following a successful AIM debut in 2011. We are now the UK’s number one destination for businesses seeking expert insight and advisory services to help them manage their energy costs, reduce their carbon emissions and prove their net zero carbon and ESG strategies to their investors and customers.
We are looking for a BPI Analyst to join our successful ESG Team. This is a home based role with occasional travel to our Kirkham (Lancashire) office required.
Responsibilities
- Technical responsibilities:
- Manage Excel-based energy/ESG reporting templates.
- Utilize advanced Excel formulas and VBA to automate, maintain, and improve templates.
- Conduct rigorous testing and debugging of templates.
- Maintain version history for all reporting frameworks.
- Provide support to peers on data solutions.
- Manage data upload and report download within the CRM.
- Soft responsibilities:
- Professional and confident manner.
- Exceptional attention to detail and ability to meet tight deadlines.
- Problem solving and analytical thinking.
- Project management skills.
- Effective face‑to‑face communicator with good telephone and written skills.
- Ability to work on their own initiative with a good “Teamwork” ethic.
- Ability to meet deadlines and prioritise activities.
- Good presentation skills.
- Ability to analyse reports and develop recommendations.
- Prepare clear and succinct reports and correspondence.
- Be able to work with colleagues, customers, suppliers and the public in general.
Qualifications
- Essential:
- Advanced technical proficiency in Excel, including VBA and complex formulas.
- Proficient with Microsoft Office packages.
- Maths and English proficiency.
- Advanced Excel proficiency, including VBA and macro development.
- Proficient with SQL to write queries that fetch data from CRM.
- Proven experience in debugging and testing complex data templates.
- Power Automate.
- Microsoft Forms.
- Desirable:
- Familiarity with GHG Protocol.
- Energy Industry experience.
- Experience with CRM Systems.
- Power BI.
Benefits
- Training and development opportunities
- Company pension
- Life insurance
- Enhanced maternity and paternity benefits
- Benefits portal, with a wide range of benefits
- 4pm finish on Friday
Contact Details
Inspired Plc
Tel: 000 000 0000
Contact: Maddy Ashurst
Email: VP9E838CE1.567@vacancyposter.com
If you require any reasonable adjustments during the recruitment process, please let us know.
BPI Analyst employer: Inspired PLC
Inspired PLC is an exceptional employer that prioritises employee growth and development, offering comprehensive training opportunities and a supportive work culture. With flexible working hours and a focus on sustainability, employees can enjoy a fulfilling career while contributing to meaningful environmental solutions. The home-based role of BPI Analyst allows for a balanced work-life dynamic, complemented by a range of benefits including a company pension and a sharesave scheme.
StudySmarter Expert Advice🤫
We think this is how you could land BPI Analyst
✨Tip Number 1
Familiarise yourself with CRM systems and their functionalities. Since the role involves supporting business users of CRM, having a solid understanding of how these systems work will give you an edge during interviews.
✨Tip Number 2
Brush up on your SQL/MySQL skills. Being proficient in these areas is essential for handling large-scale data, so consider working on some practical projects or online courses to showcase your abilities.
✨Tip Number 3
Prepare to discuss your problem-solving approach. The role requires a keen ability to identify and escalate potential business risks, so think of examples from your past experiences where you've successfully navigated challenges.
✨Tip Number 4
Practice your presentation skills. As the position involves producing reports and delivering training, being able to communicate your ideas clearly and confidently will be crucial in making a positive impression.
We think you need these skills to ace BPI Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights relevant experience and skills that align with the BPI Analyst role. Emphasise your proficiency in Microsoft Office, SQL/MySQL, and any project management experience you have.
Craft a Compelling Cover Letter:Write a cover letter that showcases your enthusiasm for the role and the company. Mention specific reasons why you want to work at Inspired PLC and how your background makes you a great fit for their team.
Highlight Relevant Skills:In your application, clearly outline your advanced Excel skills, attention to detail, and problem-solving abilities. Use examples from past experiences to demonstrate these skills effectively.
Proofread Your Application:Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your professionalism and attention to detail.
How to prepare for a job interview at Inspired PLC
✨Showcase Your Analytical Skills
As a BPI Analyst, you'll be working with large datasets and preparing reports. Be ready to discuss your experience with data analysis, particularly using Excel and SQL. Prepare examples of how you've used these skills in previous roles.
✨Demonstrate Problem-Solving Abilities
The role requires a strong problem-solving mindset. Think of specific challenges you've faced in past positions and how you overcame them. This will show your potential employer that you can handle the tough situations they might present.
✨Understand CRM Processes
Since the job involves supporting business users of CRM systems, brush up on your knowledge of CRM processes. Be prepared to discuss any relevant experience you have and how you can contribute to improving these processes.
✨Communicate Effectively
Effective communication is key for this role. Practice articulating your thoughts clearly and confidently, both verbally and in writing. You may be asked to present information or explain complex concepts, so being concise and clear will be crucial.
