BI Developer

BI Developer
Warton / Hybrid (3 days onsite / 2 days remote)
6 months initially
£74.26ph inside IR35 / Umbrella
Due to the nature of the role candidates must have active SC security clearance or be willing to undergo the security checks required for the role.
Role Description
A Business Intelligence (BI) Developer is responsible for designing, developing and maintaining business intelligence solutions within an iterative development environment.
Working closely with internal and external stakeholders to transform and present information into meaningful outputs through reports and visualisations.
Core Duties
Typical duties include (but are not limited to):
• Working with stakeholders, analysts and other developers to understand systems and collaborate on the implementation of appropriate BI solutions.
• Translate business requirements and rules in into technical design specifications.
• Build and deploy BI solutions using appropriate code standards, configuration and change management process and procedures.
• Working with multidimensional and relational data sets to support the creation of Cognos Analytics Framework Manager Models and Tableau data sources.
• Update all development activities in Air data analytics change management database and ensure all statuses follow a development lifecycle.
• Working within an Agile Development framework, participating in regular development sprints and providing updates on daily standups.
• Develop ETL pipelines and manage database queries and conduct analyses on source data. Create tools to store data following development standards.
• Ensure test plans, unit tests and peer reviews are carried out for all development.
• Working closely with key stakeholders within business functions to transition completed development to business as usual and provide the appropriate standard operating procedures.
• Ensure incidents raised are responded to and resolved within the agreed service level agreements.
• Knowledge and understanding of release and deployment process including using version control using Motio CI.
Knowledge, Skills and Qualifications
Knowledge:
• Develop in accordance with a software development lifecycle framework and have experience in working within Agile methodologies using change management and version control software.
Skills:
• Competent in development of BI solutions which include Cognos Analytics, Framework Manager, Tableau (where applicable). Knowledge and awareness of connecting to data sources and working with data held in a Data Virtualisation (DV) environment or data warehouse SQL
They must have a good understanding of modelling data using the Kimball methodology and experience in using ETL technologies.