New Job Opening: Data Warehouse Technical Lead in London

Data Warehouse Technical Lead 

We have an exciting opportunity for a 12-month assignment to be based in our clients’ offices in Surrey. The role will be Outside of IR35 with a hybrid 3 day/2 day working pattern.

Purpose of the Role

For an experienced Data Warehouse Technical Lead to develop, support and evolve a critical on-premise ‘common data environment’ (CDE) within a wider integrated solution.

The role will involve designing, building, testing, supporting and evolving the CDE, ensuring it receives data from multiple Company systems and Client System sources

Experience and Skills:

Essential:

• Experience developing, deploying and supporting multi-data source SQL data warehouses in an on-premise environment


• Experience of the full Microsoft Stack – SSIS, SSRS and SSAS


• Experience creating, documenting and developing data models to deliver management information outcomes


• Experience developing ETL procedures from multiple data sources to one data source


• Adept at building collaborative technical and business working relationships to deliver outputs and outcomes


• Experienced in authoring technical documentation, able to write clear and maintainable artefacts to support developments


• Has demonstrated technical leadership: able to understand technical trends and convert into tactical and strategic advantages; able to explain and demystify technology to non-technical audiences


• Experienced in a second-line technical resolver support environment, able to identify technical issues and manage from root cause to rectification


• Experience of using Paginated Reports for Power BI to deploy paginated reports into Azure to management information consumers


• Experience of creating on-prem data warehouse that provides data to a Cloud Azure instance/Power BI/SharePoint


• Experienced in working with Project and Programme Management environment, assisting in creating detailed plans and ensuring these are accurate, viable and maintainable

Desirable:

• Experience working FM Integrator Environment, especially creating ETL routines from Concept Evolution to Data Warehouse


• Experience of creating ETL routines from client data sources where data quality/integrity may be an issue


• Experience of VBA and .BAT programming


• Experience of scrum teams & sprint ceremonies


• Experience of leading/contributing to technical and data governance


• Understands Agile best practices (code reviews, unit tests, TDD)


• Experienced Continuous Integration & Continuous Delivery


• Experience of collaborating in a MS Teams environment


• Knowledge of the Facilities Management industry


• Experience of delivering projects to or for public sector clients


• Core Responsibilities and Duties


• Working within the FMI ITIM Team:


• Specifying high-level/low level data models, ETL plans and data warehouse designs


• Building and unit testing data warehouses as part of wider integrated solution


• Developing suite of paginated reports and dashboards to deliver multi-organisational management information requirements


• Assisting project management activities in planning, effort estimating and progress reporting


• Supporting and developing build solution as part of BAU service management


• Working with the FMI BI/MI Lead


• Agreeing MI Operating Model that ensures future MI requirements for stakeholders are captured, assessed, developed and delivered in a structured, auditable and repeatable manner


• Working with the FMI Technical Product Owner


• Advising on and contributing toward development of strategic Technical Product set, especially the data & reporting layer strategy


• Supporting associated technical transformation/mobilisation projects through all phases from definition through development to close