Overall, Purpose of Job:
- The Business Intelligence Developer will support technical delivery of BTG’s reporting solutions
- Provide fit for purpose Organisational reporting and analytics services for BTG
Key Accountabilities:
- Development of new and existing data models and reporting solutions
- Development of new and existing ETL processes and data pipelines
- Working with other teams & stakeholders to identify and implement improvements or identify new requirements
- Translate business requirements into robust technical solutions
- Deployment of new releases into testing/Dev and Production environments
- Create and maintain accurate documentation of data models and processes
Measures of Success:
Successful delivery of Organisational reporting and analytics to drive value and insight for BTG.
Become a subject matter expert in BTG’s reporting data structures.
What good looks like:
- Delivers high quality, accurate and robust reporting solutions to stakeholders
- Diagnose, continually improve, and maintain current eco-system and help fix and enhance existing data pipelines, reports & dashboards
- Builds in depth knowledge of data structures & processes within BTG’s key business applications
- Ability to analyse, interpret, and organize large amounts of data
- Excellent communication skills to translate complex problems using non-technical terms
- Excellent maths, problem-solving, and analytical skills
- Focus and attention to detail
Skills & Experience:
- Experience of developing BI solutions using the Microsoft full stack (SSIS, SSRS, SSAS)
- Experience in developing Power BI dashboards. (Experience in relevant languages; DAX, M)
- Strong SQL Database development in SQL Server 2016-2019 including performance tuning
- A good understanding of ETL frameworks and processes
- Version control (GIT, DevOps)
- An understanding of data modelling, Kimball methodologies (Star Schema, Snowflake)