Business Intelligence Data Designer and Engineer
Core
Design, model, and maintain business intelligence solutions and reporting for a Cyber Programme, translating business requirements into Power BI and Databricks/Lakehouse outputs.
Role type
Senior IC Business Intelligence Data Designer and Engineer
Builds
Production BI reporting solutions and data pipelines for a Cyber Programme
Domain
Cybersecurity / Data Engineering
Required skills
Data modelling (multi-dimensional and relational), ETL development, Power BI development, Databricks/Lakehouse platform experience, Report writing and development, Data profiling, Data transformation and migration, Requirements gathering from business users
Preferred skills
Analytical capability to identify improvement opportunities, Experience with large and complex systems environments, Ability to work independently
Technologies
Power BI, Databricks, Lakehouse
Responsibilities
Design, model, and maintain business intelligence solutions; Produce reporting required by the Cyber Programme; Develop Power BI reporting; Undertake ETL design and development; Perform data profiling, modelling, transformation, and migration; Gather and analyse reporting and data requirements from business users; Work within the Databricks / Lakehouse platform; Determine information needs, relevant data sources, and transformation rules; Translate requirements into a development roadmap and meaningful reporting outputs; Review the veracity of relevant external information sources; Work with technical teams to maintain data integrity and security; Monitor improvements in data standards and governance; Develop and enhance BI and data analytics standards, processes, and guidelines; Identify opportunities for improvement; Collaborate with BI, database, solutions delivery, and other relevant technical teams
