Data Architect

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 several top rankings in Chambers UK 2016, 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 enhance the existing Data Services function in order to prepare for future demands.

The successful candidate must possess strong end-to-end SQL Server skills 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.

Main duties and responsibilities

The Data Architect will be an integral part of the Data Services team and will be responsible for the firm’s data strategy.   This will include:  

• Responsibility for data quality, standards and governance across the firm
• Liaison across the business to establish and understand data requirements and promote confidence in the firm’s data quality
• Improve processes to ensure efficiency and consistent reporting and analysis
• Develop database solutions to store and retrieve company information analysing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Install and configure information systems to ensure functionality and efficient interaction between systems
• Analyse structural requirements for new software and applications
• Migrate data from legacy systems to new solutions
• Design conceptual and logical data models and flowcharts
• Optimise new and current database systems
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Define security and backup procedures
• Coordinate with Data Services department to identify future needs and requirements

This list is not intended to be exhaustive and you will be expected to perform other duties and have other responsibilities that fall within the wider remit of the role.

• Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
• In-depth understanding of database structure principles, data modelling and database design
• Experience gathering and analysing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in SQL
• Proficiency in MS Excel
• Familiarity with data visualization tools (e.g. Tableau and R)
• Proven analytical skills
• Problem-solving attitude
• BSc in Computer Science or relevant field

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.