Business Intelligence Engineer

Chorley
Business Intelligence Engineer
Your New Company
The UK's Utility sector is ever evolving and expanding to meet increasing customer requirements. At Ipsum it's our vision to be the leading customer service focused provider of specialist utility and infrastructure solutions, operating on both public and private networks.
To support our continued growth we are looking for a Business Intelligence Engineer to join our team. We are looking for someone who is passionate, not just about the industry, but also about supporting our teams to in delivering essential services 24/7/365 that really make a difference to local people and communities.
What we offer
We are committed to supporting and developing our people to achieve their full potential. As a fast-growing ambitious business, we can offer our people opportunities to acquire a wide range of skills and gain broad and varied experience to enable them to progress in their career. Investing in our people and enhancing our expertise and flexibility enables us to deliver the highest standard of service to our customers.
Our benefits
We really value our people and so we like to look after them. If you work for us, you'll enjoy a great range of employee benefits:
Career development including professional qualifications and accreditation
Health & Wellbeing Benefits:
Employee Assistance Programme including mental health support and access to counselling
Access to 24/7 virtual GP
Occupational Health support
Tax efficient benefits via salary exchange (salary sacrifice):
Cycle to Work
Group Personal Pension Scheme
Employee Discount Scheme - discounts on hundreds of retailers including supermarkets, mobile phone/broadband providers, gym memberships and more!
Established local social committees with calendar of regular social events
Life assurance cover
Flexible working
Long service awards
Opportunities to volunteer and make a difference via local community projects and initiatives
Your new role
As a Business Intelligence Engineer you will work as part of the IT team, and take the lead on driving data driven decisions throughout the business. You will be responsible for identifying and delivering improvements to systems to refine Ipsum's operations and to meet business requirements. Principal accountabilities include:
Development and maintenance of data pipelines between business systems and data warehouse
Development and maintenance of Power BI reporting to meet business needs
Monitoring alerting from data pipelines to ensure issues are rectified quickly
Optimisation of Power BI DAX to produce well performing reports
Connecting XMLA endpoint and examining execution plans to understand and improve performance
Managing version control of all components in data pipelines: integration, data warehouse, reports to ensure a robust governance process
Testing of all components in data pipelines
Being the primary person responsible for the data solutions to ensure the business has the data they need at their fingertips to make informed decisions
Ensuring all data solutions are designed to a high standard using modern cloud first principles
Being the go-to person for supporting the data function within IT to help colleagues understand problems, design solutions and bridge the gap in knowledge between yourself and more junior members of staff
Driving the delivery of the data and business intelligence business requirements across multiple projects
Working in close collaboration with the business to drive positive change in data drive decisions and report usage
Working across all business units and departments to understand their data challenges
Creating, developing and delivering multiple data quality improvement roadmaps for core applications
Working closely with internal teams within IT including service desk, infrastructure and security, onshore and offshore software engineers
Proactively putting ideas forward to showcase how fixing poor data quality can aid the business
Constructively challenging requirements to ensure the requested features are in line with the data strategy
Managing the delivery of the current sprints within our existing agile project management guidelines to ensure the timely delivery of data solutions
Closely understanding users needs of the products and systems they use daily to help make more informed decisions
About you
Essential qualifications/ skills/ experience
Bachelor's degree in Computer Science, Information Systems, or other relevant field or equivalent.
Solid experience at a scripting language (ideally Python or Node.js)
Excellent SQL skills, ideally Redshift/OLAP experience
Understanding of DDL + DML + DQL + TCL + DCL
Understanding of query optimisation, hints, SARGability
Understanding what a PLAN means and how to rectify performance issues from one
Liquibase experience
Exceptional data modelling skills
Infrastructure as Code experience (ideally Terraform)
Experience using version control systems, ideally Git/GitHub
Understanding of modern DevOps principles and ideally experience using GitOps/GitHub actions
Experience designing and developing integrations from many different types of data source such as REST APIs, SOAP APIs, push APIs/webhooks, Emails, S/FTP servers, GraphQL APIs, bare file downloads to a centralised data warehouse
Experience with ETL/ELT integrations
Knowledge of AWS serverless infrastructure, especially API Gateway / Lambda / SQS / SNS / Kinesis
Knowledge of ERP and financial systems, general financial awareness of how ledgers work
Experience working in a fast paced agile environment
Experience of agile project management principles and tooling
Experience explaining technical concepts to non-technical audiences at all levels throughout the organisation
Strong problem-solving capabilities and meticulous attention to detail.
Awareness of conceptual, physical and logical data modelling to aid in discussions with both technical and non-technical users
Solid experience of the concepts and practices of relational database management systems
Solid experience in technical leadership roles
A self-starter with the ability to work under own initiative
A highly proactive approach and hard-working attitude
Excellent communication skills, both written and verbal, ensuring stakeholders are kept in the loop on progress
Ipsum is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, transgender status, religion or belief, marital status, or pregnancy and maternity.