Data Manager (BI)

Berkley; London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading company in the data and analytics sector is seeking a Data Manager to join their team in London. The role will involve managing data processes, designing and developing data solutions, and supporting data governance. The candidate should possess strong experience with Microsoft technologies and data warehousing practices, ensuring compliance and data integrity across projects.

Qualifications

• Solid hands-on experience with Microsoft Technology Stack.
• Extensive experience of SQL/data warehousing.
• Proven experience of data engineering activities.

Responsibilities

• Support the Head of Data and Analytics.
• Manage ETL/ELT pipelines and ensure data integrity.
• Develop and maintain Management Information and reports.

Skills

Data modeling

Problem solving

Information analysis

Attention to detail

Flexibility

Tools

Microsoft SQL Server

Python

DAX

MDX

Kimball data modelling

Job description

Social network you want to login/join with:

• Solid hands-on experience with Microsoft Technology Stack (2022)
• Extensive experience of SQL/ data warehousing
• Proven experience of data engineering activities such as release management, environment controls, CICD pipeline orchestration
• Experience working with Python and Power BI
• Proven ability of Microsoft BI software development including database / reporting development, full development cycle
• Strong data modelling, problem solving, information analysis, attention to detail, flexibility of approach
• The ability to deal directly with business functions and interpret their thoughts into successful data & analytics solutions
• The ability to design and develop complex BI/MI solutions in line with agreed architectural principles and toolsets
• Capable of working closely with the business and delivering complex requirements to tight timescales
• Strong interest in latest data engineering technologies, best practices, techniques and trends in the data industry

Required Toolsets:

• Kimball data modelling
• Microsoft SQL Server
• Python, MDX, DAX

Responsibilities

The Data Manager will be responsible for supporting the Head of Data and Analytics and the wider business to build and deliver components of an enterprise data management platform for WRBU, utilizing Microsoft Technology stack for data ingestion, transformation & storage, and Power BI for analytics and reporting. The role includes:

1. Data Support: Acting as a Subject Matter Expert in Data, managing ETL/ELT pipelines, peer/code reviews, ensuring data integrity and accuracy.
2. Data Warehousing: Managing data warehousing solutions, designing and developing ETL/ELT processes, data lakes, data marts, reports, and dashboards.
3. MI Development and Maintenance: Developing and maintaining Management Information, gathering requirements, developing reports, and supporting their deployment.
4. Data Validation: Developing validation checks for data entry based on business rules, ensuring compliance with Solvency II, Sox, and business needs.
5. Data Governance: Supporting data governance policies, managing data in line with regulatory requirements, and ensuring transparency of progress.
6. Market Messages: Processing market messages and resolving issues efficiently.
7. MI Projects: Reviewing project requirements, developing data solutions, and supporting project lifecycle activities.