BI Engineer

Forsyth Barnes; East Midlands; On-site; GBP 59,000 - 72,000; Full time

Job summary

Forsyth Barnes is partnering with a Derby-based automotive services group to recruit a Business Intelligence Engineer. The role will design, deliver and enhance reporting and data solutions using Power BI, SQL, Python and Snowflake, with Derby office-based 2–3 days per week.

You will transform complex business questions into trusted, scalable insights, supporting operational and commercial decisions across rental, fleet and automotive service operations.

Qualifications

• Experience delivering BI solutions in live operational or commercial environments.
• Strong Power BI capability including dashboard development and performance optimisation.
• Advanced SQL skills for transformations and analytics.
• Experience building and maintaining ETL/ELT pipelines.
• Knowledge of Snowflake or similar cloud data warehouse.
• Python for data preparation, automation or testing.
• Understanding of dimensional modelling, data quality and governance.
• Ability to translate business questions into data products.
• Clear communication with stakeholders.
• Ownership and reliable delivery.

Responsibilities

• Develop and refine Power BI dashboards, reports and semantic models for operational and commercial users.
• Engineer reliable ETL/ELT pipelines across the data environment.
• Design and optimise Snowflake data models to support analysis and reporting.
• Write and improve SQL and Python solutions used in production data workflows.
• Translate stakeholder objectives into well-defined reporting products and analytics.
• Investigate data issues and strengthen quality controls in reporting and pipelines.
• Apply data governance practices and ensure documentation and access control.
• Contribute to data architecture decisions and promote scalable BI standards.
• Identify opportunities for automation and AI-enabled analysis.
• Communicate technical findings and delivery progress to technical and non-technical audiences.

Skills

BI solution delivery

Dashboard development

Data modelling

Data governance

Stakeholder communication

Problem solving

Ownership

Tools

Power BI

SQL

Python

Snowflake

Job description

Role: Business Intelligence Engineer

Location: Derby - 2/3 days a week onsite

Salary: Up to £65,000 DOE

About Us

Operating across car and truck rental and automotive service and collision repair, our client supports customers through vehicle access, mobility services and essential vehicle care. This organisation is developing its use of data and analytics to improve operational visibility, strengthen service performance and support informed decisions across a varied consumer services environment.

The business offers a commercially relevant setting for analytics professionals who want to connect robust data delivery with measurable improvements in customer experience, fleet operations and service efficiency. Its expanding focus on business intelligence, data engineering and practical automation creates scope to influence how information is governed, interpreted and applied.

Job Description

As a Business Intelligence Engineer, you will design, deliver and enhance the reporting and data solutions that guide operational and commercial decisions. The role combines hands-on development with analytical problem-solving, covering Power BI, SQL, Python, Snowflake and dependable ETL or ELT delivery.

Success will mean turning complex business requirements into clear, trusted and scalable insight. You will work across the analytics lifecycle, from data modelling and pipeline development through to dashboard performance, stakeholder adoption and continuous improvement, while also assessing where automation and emerging AI capabilities can create practical value.

Based in Derby, you will operate in a role with broad visibility across a business serving customers through rental and automotive service operations. Your work will help establish stronger data foundations, improve reporting quality and enable teams to act with greater speed and confidence.

The position suits an engineer who is comfortable balancing technical ownership with business engagement. Alongside delivering current priorities, you will contribute ideas that advance the organisation's analytics architecture, governance and use of intelligent tooling.

Key Responsibilities

• Develop and refine Power BI dashboards, reports and semantic models for operational and commercial users.
• Engineer reliable, maintainable ETL and ELT pipelines across the organisation's data environment.
• Design and optimise Snowflake data models that support efficient analysis and consistent reporting.
• Write, test and improve SQL and Python solutions used in production data workflows.
• Translate stakeholder objectives into well-defined reporting products, analytical models and measurable outcomes.
• Investigate data issues, strengthen quality controls and improve the performance of reporting and pipeline processes.
• Apply sound practices in data governance, documentation, access management and solution lifecycle control.
• Contribute to data architecture decisions and promote scalable engineering standards across BI delivery.
• Identify suitable opportunities for automation, AI-enabled analysis and agentic workflows.
• Communicate technical findings and delivery progress clearly to both technical and non-technical audiences.

Requirements

• Demonstrable experience delivering business intelligence solutions in a live operational or commercial environment.
• Strong Power BI capability, including dashboard development, semantic modelling, visual design and performance optimisation.
• Advanced SQL skills with the ability to develop efficient queries, transformations and analytical logic.
• Practical experience building, monitoring and supporting ETL or ELT pipelines.
• Working knowledge of Snowflake or a comparable cloud data warehouse.
• Proficiency in Python for data preparation, automation, testing or engineering tasks.
• Understanding of dimensional modelling, data quality, governance and modern analytics architecture.
• Ability to gather requirements, challenge assumptions and convert business questions into usable data products.
• Clear written and verbal communication, with confidence explaining technical decisions to varied stakeholders.
• Strong ownership, structured problem-solving ability and a focus on dependable delivery.
• Desirable: Experience applying automation, generative AI or agentic AI to business processes or analytics.
• Desirable: Familiarity with cloud platforms, data orchestration tools or software delivery practices.

Benefits

• Work on data products that influence vehicle rental, fleet activity, customer service and automotive repair operations.
• Gain broad exposure to the full BI lifecycle, from data engineering and modelling through to insight adoption.
• Build experience with modern tools including Power BI, Snowflake, SQL and Python in a business-facing environment.
• Contribute to forward-looking initiatives involving automation, intelligent tooling and practical AI applications.
• Receive access to the systems, platforms and resources required to deliver reliable production solutions.
• Develop your technical and commercial perspective through direct engagement with operational stakeholders.
• Benefit from a role offering meaningful ownership within an organisation strengthening its analytics capability.
• Access a competitive reward package and opportunities for continued professional development.