BI Developer

Ipsum; North Stainmore; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

25 days leave

Holiday purchase

Pension plan

Career development

Virtual GP

Mental health support

Cycle to Work

Discount club

Life assurance

Long service recognition

Enhanced maternity pay

Volunteer opportunities

Job summary

Ipsum is hiring a BI Engineer to transform data into actionable insights. You will design scalable data models, build Power BI dashboards, and maintain ETL pipelines, ensuring data accuracy and security. You will collaborate with stakeholders to deliver data-driven solutions and promote best practices across the analytics function.

The role emphasizes hands-on development, ownership of reporting solutions, and continuous improvement within a hybrid, full-time team.

Qualifications

• We require a degree in Computer Science, Information Systems, or a related field, or equivalent experience.
• You should have a basic understanding of Python, SQL, Power BI, DAX and Power Query (M Language).
• Strong communication skills and the ability to work independently are essential.

Responsibilities

• Design, develop, and maintain data models, warehouses, and data marts to support BI and reporting.
• Create interactive Power BI reports and dashboards using DAX and Power Query.
• Develop and maintain ETL processes for multiple data sources.
• Monitor, troubleshoot, and resolve data and reporting incidents to ensure reliability.
• Ensure data quality, governance, security, and access controls.
• Optimize performance of reports and data models and improve refresh efficiency.
• Collaborate with stakeholders and colleagues to promote BI best practices.

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Power Query (M language)

DAX

SQL

Python

Job description

BI Engineer

BI Engineer

Location: North West, hybrid working pattern

Employment type: Full time

Working Hours: Monday to Friday

What’s In It For You…

We believe in looking after our people, and it shows. When you join Ipsum, you’re not just taking a job — you’re starting a career with real support behind it.

• 25 days annual leave plus bank holidays
• Option to buy up to 5 additional holidays
• Group Personal Pension Plan
• Career development & progression with the opportunity to earn professional qualifications
• 24/7 access to a virtual GP and Mental health support & counselling services
• Cycle to Work scheme
• Discount club - supermarkets, phone bills, gyms & more !
• Life assurance cover
• Long service recognition
• Enhanced Maternity Pay
• Paid volunteering opportunities in your community

About The Role…

As a BI Engineer, you will play a key role in transforming data into meaningful insights that drive business decisions. You will design and maintain scalable data solutions, develop impactful Power BI reports and dashboards, and ensure data is accurate, secure, and accessible. Working closely with stakeholders and colleagues across the business, you will help deliver data-driven solutions, promote best practices, and support continuous improvement within the data and analytics function.

As a BI Engineer you will…

• Design, develop, and maintain robust data models, data warehouses, and data marts to support business intelligence and reporting requirements.
• Create interactive and insightful Power BI reports and dashboards, leveraging data visualisation best practices, DAX, and Power Query (M language).
• Develop and maintain data integration and ETL processes, ensuring efficient data ingestion, transformation, and loading across multiple sources.
• Monitor, troubleshoot, and resolve data and reporting incidents, applying strong debugging and problem-solving skills to maintain service reliability.
• Ensure data quality, governance, security, and compliance through effective access controls, authentication, and authorisation practices.
• Optimise the performance of reports, dashboards, and data models by improving queries, refresh schedules, and overall solution efficiency.
• Collaborate closely with stakeholders and graduates within the team, sharing knowledge, promoting best practices, providing support and training, and driving adoption of BI solutions.

About You…

We're looking for a proactive and motivated individual with a degree in Computer Science, Information Systems, or a related field (or equivalent experience). You'll have a basic understanding of Python, SQL, Power BI, DAX, and Power Query (M Language), alongside strong communication skills and a willingness to learn. The ideal candidate will be able to work independently, collaborate effectively with others, and take ownership of delivering high-quality data and reporting solutions.

Our commitment to Equal Opportunities…

We’re proud to be an equal opportunities employer. We welcome applications from all backgrounds and experiences, and we’re committed to building a diverse and inclusive workforce.

Before applying, please review our Privacy Policy to understand how we process your data in line with GDPR.