BI Technical Lead - Glasgow / Hybrid working

BI Technical Lead

Glasgow / Hybrid working

Permanent opportunity with fantastic benefits 

PRINCIPAL TASKS AND RESPONSIBILITIES

Technical Skills

• Translate business needs into technical specifications, ability to communicate with both technical & non-technical stakeholders.
• Proven experience of building analytical data models and business intelligence solutions.
• Defining & documenting reference architectures, solution design patterns, solution accelerators for use in Data Solutions.
• Solid understanding of data integration, data analysis, data modelling, data visualisation best practises.
• Focus on development of ETL/data pipelines and data warehouse following industrial best practices.
• In-depth understanding of database management systems, online analytical processing and ETL (Extract, transform, load) framework.
• Utilising advanced Microsoft T-SQL knowledge to build and execute ad-hoc data queries upon request.
• Experience using PowerBI or similar visualisation tool.
• Participation in Datawarehouse design with a strong understanding of the Kimbal methodology
• Work closely with the DBA team to ensure any SQL meets stringent performance and governance standards.
• Good working knowledge of data modelling and schema patterns.
• Create and maintain a library of technical documentation and help expand the business data dictionary.

• Experience in delivering and supporting Dynamics 365 functionality
• Understanding of release management process and devops practices of continuous integration and Continuous development

Leadership

• Leading team in the definition of best practices & repeatable methodologies in Data Engineering (including Data Storage, ETL, Data Warehousing), BI, Data Visualisation, Data Presentation, Data Analytics & Data Science.
• Contribute to the development of the Data & MI team's direction and strategy
• Play a key role in in establishing, championing and supporting architectural decisions.
• Input heavily into the technical roadmap, and how it folds into the product roadmap.
• Work closely with the Product Owners, stakeholders and other Tech Leads to design high quality technical solutions which meet specified business objectives, whilst adhering to overarching business and technical requirements and constraints.
• Ensure that any solutions meet regulatory obligations set by the FCA with specific focus on GDPR and other data and non-data related regulations.
• Maintain operational resilience with robust reporting & controls on performance, contingency, and third-party management.
• Ensure all business intelligence solution design, development & delivery follow appropriate governance process and policy.
• Ensuring the branching and merging policy is adhered to.
• Focus the squad on creating interesting technical solutions to business problems, to bring a positive energy to the work done.
• Work with ART Managers to support release planning
• Work with the Application Operations team to support the build and release process
• Act as a strong voice in the definition of squad and clan OKRs.

Participating in Team Development

• Support activities to define training needs within the squad and wider team.
• Actively focus on succession planning, by identifying and supporting the development of future Tech Leads.
• Mentor members of the squad and contribute to the definition of personal OKRs.

Basic Behaviours of Squad Members

• Ensure that continuous improvement is baked into everything we do.
• Support the development of a strong squad culture focused on transparency, collaboration, and high performance
• Make time to support other members of the squad and answer questions when they need help.
• Take responsibility of your personal objectives and those of the squad.
• Take ownership of deadlines that you have agreed to, and releases of software the squad has created.
• Ensure the work you do lines up with the technical and product visions, including non-functional requirements.
• Any quality issues of the software the squad owns should be looked on as a temporary and unacceptable state of affairs. Every opportunity should be taken to rectify problems, in conjunction with the completion of squad and individual objectives.
• Swarm around issues if the squad is struggling to meet one of its objectives.

SKILLS/EXPERIENCE