Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and enhance ESG reporting frameworks using advanced Excel and VBA.
- Company: Join a leading tech provider in energy and sustainability solutions.
- Benefits: Enjoy training, a pension scheme, life insurance, and early Friday finishes.
- Other info: Home-based role with occasional travel; great career growth opportunities await!
- Why this job: Make a real impact in the fight against climate change while developing your skills.
- Qualifications: Advanced Excel skills, VBA proficiency, and a knack for problem-solving.
The predicted salary is between 35000 - 45000 £ 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.
This is a home based role with occasional travel to our Kirkham (Lancashire) office required. The ESG/BPI Analyst is responsible for the technical integrity of our ESG reporting infrastructure and managing report uploads and downloads from the CRM. This role is split between taking full ownership of complex Excel based ESG reporting frameworks, utilising VBA and advanced formulas for ESG reporting, and providing comprehensive administration and support for the department's CRM system.
The responsibilities will include but not be limited to:
- Technical Responsibilities:
- Manage Excel-based energy/ESG reporting templates.
- Utilise 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.
- 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 and Education Requirements
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.
What we offer:
- Training and development opportunities.
- Company pension.
- Life insurance.
- Enhanced maternity and paternity.
- Benefits portal, with a wide range of benefits.
- 4pm finish on Friday.
If you are interested in the role and would like to be considered, please apply now and a member of our In House Recruitment Team will be in touch. Good Luck! If you require any reasonable adjustments during the recruitment process, please let us know.
ESG BPI Analyst employer: Inspired
Contact Detail:
Inspired Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ESG BPI Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the ESG field on LinkedIn or at industry events. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Show off your skills! If you’ve got advanced Excel tricks up your sleeve, create a mini-project or a portfolio piece. Share it during interviews to demonstrate your expertise.
✨Tip Number 3
Prepare for the interview by researching Inspired and its ESG initiatives. Tailor your answers to show how your skills align with their mission to help businesses transition to net zero.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team.
We think you need these skills to ace ESG BPI Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the ESG BPI Analyst role. Highlight your advanced Excel skills, VBA experience, and any relevant project management or analytical work you've done. We want to see how your background fits with our mission!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about sustainability and how your skills can help us at Inspired. Keep it concise but impactful – we love a good story!
Show Off Your Technical Skills: Since this role involves a lot of technical work, don’t shy away from showcasing your proficiency in Excel, SQL, and CRM systems. Include specific examples of how you've used these tools to solve problems or improve processes.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it’s super easy!
How to prepare for a job interview at Inspired
✨Master Your Excel Skills
Since the role heavily relies on advanced Excel, make sure you brush up on your skills. Be prepared to discuss specific functions, VBA automation, and any complex formulas you've used in past projects. Practising with real-life scenarios can help you articulate your experience better.
✨Know Your ESG Fundamentals
Familiarise yourself with the latest trends and regulations in ESG reporting. Being able to discuss the GHG Protocol and how it applies to energy management will show that you're not just technically proficient but also understand the bigger picture of sustainability.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled complex data issues or improved reporting processes in previous roles. Highlighting your analytical thinking and project management skills will demonstrate your ability to handle the responsibilities of the BPI Analyst position.
✨Communicate Effectively
As this role requires good communication skills, practice explaining technical concepts in simple terms. Be ready to discuss how you’ve collaborated with teams or clients in the past, as effective face-to-face communication is key to success in this position.