Data Manager

ABOUT THE ROLE

The Data Manager role sits within the Data and Process Team and is responsible for building, developing, and optimising the conceptual and logical data systems under the direction of the Group’s Data Architect. Duties may include developing and preparing business information reports, system monitoring and performing system migrations.

This role supports the Group Data Strategy by understanding requirements and delivering reporting and insights primarily utilising SQL and Microsoft Power BI.

This role requires a high standard of skills in Power BI to create visualisations and ensure reports are intuitive.

To succeed in this role, you should have a background in data and business analysis, with excellent analytical and problem-solving abilities.

An excellent communicator, you will also know how to examine new data system requirements and implement migration models.

KEY ACTIVITIES

• Design and implement effective database solutions and models to store and retrieve company data.
• Designing, developing, and maintaining business intelligence solutions.
• Knowledge and working of Power BI will be essential to visualise data that provides compelling and actionable stories relevant for business goals.
• Translate data into valuable insights that inform decisions. Translate business needs to technical specifications.
• Create tools to store data (e.g. OLAP cubes).
• Evaluate and improve existing BI systems.
• Develop and execute database queries and conduct analyses.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.
• Oversee the migration of data from legacy systems to new solutions.
• Monitor system performance by performing regular tests and troubleshooting.
• Recommend solutions to improve new and existing database systems.
• Understands data governance and how it works in relation to organisational governance structures.
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.
• To adhere to the company’s Equal Opportunities policy and Dignity at work policy in all activities and to actively promote equality of opportunity wherever possible.
• To be responsible for your own health and safety and that of your colleagues, in accordance with the company’s’ Health and Safety policy.
• To adhere to the company’s Quality policy and Environmental policy.
• To undertake other duties as may be reasonably required.

KEY SKILLS

Essential

• Substantial proven experience in a similar role.
• Strong knowledge of database structure, data warehouse design (e.g. dimensional modelling) and data mining using:
• SQL Server 2012 / 2014 / 2016 / 2019
• Azure SQL Data Warehouse
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• Power BI
• Solid data analysis experience.
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Excellent organisational and analytical abilities.
• Outstanding problem solver.
• Strong written, verbal and presentational communication skills.
• Advanced skills in MS office software especially Excel, PowerPoint and Word.
• Analytical mind with a problem-solving aptitude.

Desirable

• Educated to honours degree (2.1) in a numeracy or science-based discipline.
• Understanding of GDPR.
• Familiarity with data visualization tools (e.g. Tableau, D3.js and R).
• Strong interpersonal skills and emotional intelligence.

KEY WORKING RELATIONSHIPS

Internal

• All department managers within the group to ensure their reporting requirements are being met.

External

• IT Suppliers.

ADDITIONAL INFORMATION

• The successful candidate will be based at our Cardiff offices. There is the potential for travel our other sites for project work.

COMPETENCIES 

Analytical – Enjoys analysing qualitative data but also considers quantitative and seeks to identify and explore they key elements in information before making commitments.  Tends to like to use facts and figures when planning and reporting and is concerned about accuracy and detail.

Information Gathering – Enjoys dealing with and refers to factual data.  Likes to be well informed and drills down into details.  Prefers to access wide range of information and opinion before making decisions and when solving problems.

Planning and Organising – Thinks things through well in advance and maps out future activities, taking the key stages and requirements into account.  Likes to monitor to ensure that things are implemented and delivered effectively.

Quality Orientation – Is precise, pays attention to details, checks things and ties up ‘loose ends’.  Has a strong conscience about getting things right and seeks to ensure that decisions and solutions do not involve undue risk, adheres to policy and standards.

Resilience – Can work under pressure, remains calm, thinks clearly and manages emotion under pressure. Addresses issues without being aggressive or controlling and can easily bounce back from setbacks. Is open to feedback and doesn’t dwell on past events.

Supporting Others – Enjoys supporting other people and is prone to getting involved and trying to help them when they have problems. Is comfortable to contribute to joint endeavours and enjoys teamwork.  Is willing to let other people depend on them.

Team Working – Enjoys participating in group activities and likes to work in close proximity with other people.  Is ready to collaborate with and support others and is willing to co-operate and compromise for the overall good.

Technical expert – Full breadth of technical knowledge and can operate as a technical advisor, influencing others to achieve goals without relying on hierarchy. Keeps up to date on changes within their field and implements plans to ensure organisation is in a state of readiness.  Participates in industry and professional associations.