Current jobs related to Business Intelligence Engineer - Chorley, Lancashire - Ipsum


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    {"h1": "SQL Business Intelligence Developer", "p": "At TVS SCS, we are seeking a skilled SQL Business Intelligence Developer to join our team. As a key member of our BI development team, you will be responsible for designing, developing, and implementing business intelligence solutions to support our business operations.Your primary focus will be on creating...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    {"h1": "SQL Business Intelligence Developer", "p": "At TVS SCS, we are seeking a skilled SQL Business Intelligence Developer to join our team. As a key member of our BI development team, you will be responsible for designing, developing, and implementing business intelligence solutions to support our business operations.Your primary focus will be on creating...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    Job OverviewThe SQL Business Intelligence Developer is responsible for creating and managing BI solutions to provide information for better business decision making. This is a technical role based mainly in SQL.Key ResponsibilitiesIdentify and resolve dataflow issues in a timely fashion.Support the need for SQL development including CTE's, Stored Procedures,...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    Job OverviewThe SQL Business Intelligence Developer is responsible for creating and managing BI solutions to provide information for better business decision making. This is a technical role based mainly in SQL.Key ResponsibilitiesIdentify and resolve dataflow issues in a timely fashion.Support the need for SQL development including CTE's, Stored Procedures,...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    Job OverviewThe SQL Business Intelligence Developer is responsible for taking a lead role in creating and managing BI solutions, to provide information for better business decision making. This is a technical role based mainly in SQL.Key ResponsibilitiesData Flow Management: Identify and resolve data flow issues in a timely fashion.SQL Development: Support...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    Job OverviewThe SQL Business Intelligence Developer is responsible for taking a lead role in creating and managing BI solutions, to provide information for better business decision making. This is a technical role based mainly in SQL.Key ResponsibilitiesData Flow Management: Identify and resolve data flow issues in a timely fashion.SQL Development: Support...


  • Chorley, Lancashire, United Kingdom TVS-SCS Full time

    TVS-SCS is seeking a skilled SQL BI Developer to join our growing team and contribute to our data-driven decision-making processes. In this role, you will play a pivotal part in designing, developing, and maintaining robust BI solutions that empower our business with actionable insights. Your expertise in SQL and related technologies will be instrumental in...


  • Chorley, Lancashire, United Kingdom Adecco Full time £30,000

    Position OverviewAre you a recent graduate in Electrical Engineering, Electronic Engineering, or a related discipline? If you have a passion for the Electronics Engineering field, we invite you to explore this opportunity.About the RoleAdecco Recruitment is seeking a dedicated Electronics/Electrical Engineer on behalf of our esteemed client. This is a...


  • Chorley, Lancashire, United Kingdom CV Library Full time

    Job Description**About the Role**CV Library is seeking a skilled Development Engineer to join our in-house technical team. As a Development Engineer, you will play a crucial role in ensuring that our residential developments are designed, approved, and constructed to the highest standards.**Key Responsibilities**Provide technical support across various...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    Precision Engineering is seeking a talented Junior Mechanical Design Engineer to join their team. As a key member of the engineering department, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation. You will apply engineering principles to solve technical challenges and deliver quality solutions....


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    Precision Engineering is seeking a talented Junior Mechanical Design Engineer to join their team. As a key member of the engineering department, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation. You will apply engineering principles to solve technical challenges and deliver quality solutions....


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering. As a key member of our engineering team, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation.Key ResponsibilitiesApply engineering principles to solve technical challenges and...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering. As a key member of our engineering department, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation.Key ResponsibilitiesApply engineering principles to solve technical challenges and...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering. As a key member of our engineering team, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation.Key ResponsibilitiesApply engineering principles to solve technical challenges and...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering. As a key member of our engineering department, you will be responsible for creating detailed engineering drawings and managing Bill of Materials (BOM) creation.Key ResponsibilitiesApply engineering principles to solve technical challenges and...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering, a well-established family-run SME with over 35 years of experience in manufacturing bespoke machinery. Our company caters to a diverse range of clients across various sectors, including Nuclear, Aerospace, Automotive, Medical, Renewable...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering, a well-established family-run SME with over 35 years of experience in manufacturing bespoke machinery. Our company caters to a diverse range of clients across various sectors, including Nuclear, Aerospace, Automotive, Medical, Renewable...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering, a well-established family-run SME with over 35 years of experience in manufacturing bespoke machinery. Our company caters to a wide range of clients across various sectors, including Nuclear, Aerospace, Automotive, Medical, Renewable Energy,...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time £28,000 - £32,000

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering, a well-established family-run SME with over 35 years of experience in manufacturing bespoke machinery. Our company caters to a wide range of clients across various sectors, including Nuclear, Aerospace, Automotive, Medical, Renewable Energy,...


  • Chorley, Lancashire, United Kingdom Precision Engineering Full time

    About the RoleWe are seeking a talented Junior Mechanical Design Engineer to join our team at Precision Engineering, a well-established family-run SME with over 35 years of experience in manufacturing bespoke machinery. Our company has a fantastic culture, which has led to a low staff turnover, and we are looking for someone who is eager to progress within a...

Business Intelligence Engineer

3 months ago


Chorley, Lancashire, United Kingdom Ipsum Full time
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 )
  • 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.