BI Engineer: Turn Data into Strategic Insights

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

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.