Data Warehouse Manager

Weightmans is a Top 45 law firm with offices throughout the UK. Having been recognised as the leading legal employer at the annual Britain's Top Employers awards and achieved record rankings in Chambers UK 2017, we are immensely proud of the work we carry out for our clients and the culture we provide to our people.

Our Information Systems team is made up of many teams that work together to support Weightmans' information systems and infrastructure. The teams include: development; operations; project services; and support.

Weightmans has an ever-growing need for management information. This information is utilised both within the firm and by our clients. The firm has recognised the need to grow the existing Business Intelligence function in order to meet the current increased demand and to prepare for future demands.

The successful candidate must be an experienced data warehouse developer and provide a technical lead for the BI developers, reporting to the Head of Data Services.  They must possess strong end to end SQL Server skills, notably analysis services, to support the team in the deployment of data cubes from the data warehouse. In addition to the development of analysis services objects, an understanding of integration services and reporting services is important. It would also be extremely beneficial if the candidate had some experience of Wherescape Red.

Main duties and responsibilities

• To control, manage and develop the Data Warehouse including responsibility for future development strategies.

• Support implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

• Provide a technical lead to the team of BI developers.

• Apply consistency of approach to report development and implementation.

• Operate within, and assist in the development of processes and controls for management of information, ensuring change is dealt with in a controlled manner.

• Work proactively with Business Managers to suggest improved ways of reporting and ensuring consistent data quality.

• To develop and apply skills in project management, business analysis, and technical excellence.

Essential

• Good understanding of BI Best Practices/Methodologies, relational structures, dimensional data modelling, structured query language (SQL) skills, data warehouse and reporting techniques

• Good knowledge of SQL Server 2016

• Ability to identify customer needs and translate them into technical requirements

• Experience of producing and maintaining appropriate documentation across the solution development lifecycle

• Ability to anticipate problems, identify risk, evaluate impact and produce appropriate solutions, or escalate as necessary

• Good time management skills

• Ability to communicate and present ideas across all areas of the organisation.

• Ability to rollout solutions that are well tested and meet the needs of the end users

• Knowledge and experience of MDX

• Knowledge and experience of DAX

• Knowledge and experience of ETL tools e.g. Integration Builder, Integration Services

Beneficial

• Knowledge and experience of using Wherescape Red

• Skill & experience in sharing knowledge and expertise

• Experience of using source control

• Experience of Integration Services

• Client and / or stakeholder-facing experience

Please note:

• Any reference to experience or PQE in our adverts or job descriptions is to be used as a guideline only. We welcome applicants from all backgrounds and with different levels of experience who can demonstrate that they fulfil the requirements of the role.

• The successful candidate appointed to this role will be subject to our standard background checking process, and any offer of employment made is conditional upon successful completion of those checks. Further details can be obtained from the Recruitment team.