Here at AMP, we are committed to supporting the energy transition by funding, developing, and delivering flexible energy solutions and helping businesses decarbonise.
Our mission is to create a smarter energy future. We are relentless in our focus on tackling the central challenge of our age – the energy transition.
The size and scale of the challenge means we must continually grow our team, bring in new ideas and new approaches and be ready to push the boundaries. At every level, we are looking for bold, ambitious, bright, and collaborative people that share our commitment to making a difference. We have a fantastic new opportunity for a Data and Automation Analyst to join our IM Team, playing a pivotal role in delivering data-driven insights and automation solutions that support smarter, faster decision-making across the business.
Interested? If you are proactive, impact-oriented, and enjoy making a difference – AMP can offer you the challenge and opportunity you’re looking for.

The role will involve:

• Designing, developing and maintaining interactive dashboards and reports using Power BI, aligned to business needs and user requirements.
• Designing and implementing data models, calculations, and KPIs to support business decision-making.
• Connecting and managing data sources within Microsoft Azure, including Azure SQL and Data Lake.
• Building and maintaining automated workflows using Power Automate to streamline reporting and communication processes.
• Working with suppliers and third parties to implement best practice data integrations
• Delivering scheduled and ad-hoc reports, including automated email summaries and PDF reports, to key stakeholders across the business.
• Collaborating with cross-functional teams to gather reporting requirements and deliver actionable insights.
• Ensuring data quality, consistency, accuracy and security across all reporting and automation platforms, adhering to data governance standards.
• Continuously evaluating and improving reporting processes and tools.

What we are looking for:

A determined and ambitious individual who enjoys working in a dynamic environment and has the following knowledge, skills and experience:

• Bachelor’s degree in a relevant field such as Data Science or Computer Science/Engineering
• Proficient in analysing datasets statistical methods using SQL, Python, R.
• Experience with Microsoft Azure data services (e.g., Azure SQL Database, Azure Data Factory).
• Ability to write and optimise SQL queries.
• Hands-on experience with automation technologies, such as Robotic Process Automation (RPA) tools like UiPath or Automation Anywhere, to streamline processes and improve efficiency.
• Proficiency in data visualization tools like Tableau or Power BI, and experience with database management systems.
• The ability to adapt to new technologies, tools, and methodologies in a rapidly changing field
• Strong analytical and problem-solving abilities to identify issues and develop effective solutions.
• Excellent communication skills to present findings clearly and collaborate with team members and stakeholders

What will we offer in return?

We’ve built a culture founded on honesty, working hard, and enjoying ourselves. And we have created a workplace where everyone feels more connected, heard, and valued. You’ll receive, ongoing training and development, be encouraged to work towards relevant accreditations and be able to map out a clear journey of progression within your role. Our employee benefits include –

• 26 days annual leave entitlement plus 8 days for public holidays (pro rota for part time)
• Life Insurance
• Employer pension contribution
• Healthcare Cash Plan
• Access to advice, counselling, and support
• Access to GP services
• Wellbeing tools and resources
• Shopping and lifestyle discounts
• Discounted gym membership

Job Types: Full-time, Permanent
Pay: From £38,000.00 per year

Benefits:

• Company pension
• Health & wellbeing programme
• Life insurance
• Referral programme

Schedule:

• Monday to Friday

Experience:

• Microsoft Azure: 1 year (preferred)

Work authorisation:

• United Kingdom (required)

Work Location: In person
Reference ID: Data and Automation Analys

The role will involve:

• Designing, developing and maintaining interactive dashboards and reports using Power BI, aligned to business needs and user requirements.
• Designing and implementing data models, calculations, and KPIs to support business decision-making.
• Connecting and managing data sources within Microsoft Azure, including Azure SQL and Data Lake.
• Building and maintaining automated workflows using Power Automate to streamline reporting and communication processes.
• Working with suppliers and third parties to implement best practice data integrations
• Delivering scheduled and ad-hoc reports, including automated email summaries and PDF reports, to key stakeholders across the business.
• Collaborating with cross-functional teams to gather reporting requirements and deliver actionable insights.
• Ensuring data quality, consistency, accuracy and security across all reporting and automation platforms, adhering to data governance standards.
• Continuously evaluating and improving reporting processes and tools

We’ve built a culture founded on honesty, working hard, and enjoying ourselves. And we have created a workplace where everyone feels more connected, heard, and valued. You’ll receive, ongoing training and development, be encouraged to work towards relevant accreditations and be able to map out a clear journey of progression within your role. Our employee benefits include –

• 26 days annual leave entitlement plus 8 days for public holidays (pro rota for part time)
• Life Insurance
• Employer pension contribution
• Healthcare Cash Plan
• Access to advice, counselling, and support
• Access to GP services
• Wellbeing tools and resources
• Shopping and lifestyle discounts
• Discounted gym membershi