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:
1. Career development including professional qualifications and accreditation
2. Health & Wellbeing Benefits:Employee Assistance Programme including mental health support and access to counselling Access to 24/7 virtual GP Occupational Health support
3. Tax efficient benefits via salary exchange (salary sacrifice): Cycle to WorkGroup Personal Pension Scheme
4. Employee Discount Scheme – discounts on hundreds of retailers including supermarkets, mobile phone/broadband providers, gym memberships and more!
5. Established local social committees with calendar of regular social events
6. Life assurance cover
7. Flexible working
8. Long service awards
9. 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:
10. Development and maintenance of data pipelines between business systems and data warehouse
11. Development and maintenance of Power BI reporting to meet business needs
12. Monitoring alerting from data pipelines to ensure issues are rectified quickly
13. Optimisation of Power BI DAX to produce well performing reports
14. Connecting XMLA endpoint and examining execution plans to understand and improve performance
15. Managing version control of all components in data pipelines: integration, data warehouse, reports to ensure a robust governance process
16. Testing of all components in data pipelines
17. 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
18. Ensuring all data solutions are designed to a high standard using modern cloud first principles
19. 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
20. Driving the delivery of the data and business intelligence business requirements across multiple projects
21. Working in close collaboration with the business to drive positive change in data drive decisions and report usage
22. Working across all business units and departments to understand their data challenges
23. Creating, developing and delivering multiple data quality improvement roadmaps for core applications
24. Working closely with internal teams within IT including service desk, infrastructure and security, onshore and offshore software engineers
25. Proactively putting ideas forward to showcase how fixing poor data quality can aid the business
26. Constructively challenging requirements to ensure the requested features are in line with the data strategy
27. Managing the delivery of the current sprints within our existing agile project management guidelines to ensure the timely delivery of data solutions
28. Closely understanding users needs of the products and systems they use daily to help make more informed decisions
About you
29. 30. Essential qualifications/ skills/ experience
31. Bachelor's degree in Computer Science, Information Systems, or other relevant field or equivalent.
32. Solid experience at a scripting language (ideally Python or face="Arial"> Excellent SQL skills, ideally Redshift/OLAP experience
33. Understanding of DDL + DML + DQL + TCL + DCL
34. Understanding of query optimisation, hints, SARGability
35. Understanding what a PLAN means and how to rectify performance issues from one
36. Liquibase experience
37. Exceptional data modelling skills
38. Infrastructure as Code experience (ideally Terraform)
39. Experience using version control systems, ideally Git/GitHub
40. Understanding of modern DevOps principles and ideally experience using GitOps/GitHub actions
41. 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
42. Experience with ETL/ELT integrations
43. Knowledge of AWS serverless infrastructure, especially API Gateway / Lambda / SQS / SNS / Kinesis
44. Knowledge of ERP and financial systems, general financial awareness of how ledgers work
45. Experience working in a fast paced agile environment
46. Experience of agile project management principles and tooling
47. Experience explaining technical concepts to non-technical audiences at all levels throughout the organisation
48. Strong problem-solving capabilities and meticulous attention to detail.
49. Awareness of conceptual, physical and logical data modelling to aid in discussions with both technical and non-technical users
50. Solid experience of the concepts and practices of relational database management systems
51. Solid experience in technical leadership roles
52. A self-starter with the ability to work under own initiative
53. A highly proactive approach and hard-working attitude
54. Excellent communication skills, both written and verbal, ensuring stakeholders are kept in the loop on progress