Senior Business Information Analyst

Job Purpose:

• As a Business Intelligence Analyst 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 the businesses operations and to meet business requirements.

Principal Accountabilities:

• Responsible for the development and maintenance of data pipelines between business systems and data warehouse
• Responsible for the development and maintenance of Power BI reporting to meet business needs
• Responsible for 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
• Responsible for 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
• Responsible for 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
• Responsible for 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
• Create, develop and deliver 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 challenge 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

The Person

Required Qualifications & Professional Membership(s):

• Bachelor's degree in Computer Science, Information Systems, or other relevant field or equivalent.

Knowledge & Experience:

• 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

Skills & Personal Qualities:

• Must be a self-starter and able to work under own initiative
• Must be a highly proactive person
• Must be an over communicator to ensure everyone is kept in the loop on progress