Senior Analytics Engineer

RSK Group; Greater London; Hybrid; GBP 50,000 - 80,000; Full time

Benefits offered by this job

Contributory pension scheme

Life assurance

Flexible benefits programme

Job summary

RSK Group in London is seeking a Senior Analytics Engineer to join the Data & Analytics team. You will own the DBT transformation layer on the Snowflake warehouse, design semantic Power BI models, and define a single metrics layer across the business.

You will drive data quality, governance, and self-serve reporting, working in a hybrid role with at least three days in the office. A relevant degree and strong SQL/BI experience are required, with prior leadership in analytics engineering.

Qualifications

• Substantial analytics engineering or BI development experience, including time in a senior or lead role owning a transformation and metrics layer.
• Expert SQL with well-structured, maintainable data models.
• Expert DBT with macros, packages, testing, documentation and CI.

Responsibilities

• Take ownership of the DBT transformation layer on Snowflake, including architecture, standards and testing.
• Own the metrics layer with a single definition per group metric and version-controlled documentation.
• Lead the design of Power BI semantics and datasets for fast, self-serve reporting.
• Extend certified coverage as new businesses are connected and rationalise the reporting estate.
• Make data quality visible with indicators and automated issue resolution.

Skills

SQL

DBT

Power BI

Snowflake

Dimensional modelling

Metrics governance

Leadership

Education

Computer science / Engineering / Mathematics degree

Tools

Snowflake (data warehouse)

DBT (CI)

Job description

The Vacancy

As part of our continued growth, RSK Group are seeking a Senior Analytics Engineer to join our expanding Data & Analytics team.

This is a full time, hybrid role (minimum 3 days per week in the office) based at our office in London - Chancery Exchange.

You'll play a key role in shaping our data strategy, driving best practice and enabling data-driven decision-making at every level of the business.

Key Responsibilities:

• Take technical ownership of the DBT transformation layer on our Snowflake warehouse - its architecture, standards, modularity, testing and documentation.
• Own the certified metrics layer: one agreed definition per group metric, drillable by business and division, documented and version-controlled.
• Broker metric definitions with the business - getting autonomous operating companies to a single, defensible way of counting, and holding the line once it is agreed.
• Lead the design of Power BI semantic models and datasets so that reporting is fast, reliable and genuinely self-serve.
• Extend certified coverage as new businesses are connected, so that group numbers describe more of the group rather than a subset of it.
• Rationalise the reporting estate - consolidate and retire low-value assets, and make the ongoing maintenance cost of a new asset explicit before it is built.
• Make data quality visible: quality and coverage indicators on the reporting itself, and a route for recurring issues to move from flagged to automatically resolved.

Person Specification:

• A relevant degree (e.g. computer science, engineering, mathematics) or equivalent practical experience.
• Substantial analytics engineering or BI development experience, including time in a senior or lead role owning a transformation and metrics layer.
• Expert SQL, including performant queries and the design of well-structured, maintainable data models.
• Expert DBT - macros, packages, testing, documentation and CI - with a track record of keeping a large model estate clean.
• Deep Power BI experience: semantic/data modelling, DAX, performance tuning, and building reports people actually trust.
• Experience with cloud data warehouses; exposure to Snowflake is highly desirable.
• Strong grasp of dimensional modelling (star schema), metric layer design and ELT best practice.
• Demonstrable experience defining and governing business metrics across multiple business units, including navigating disagreement about definitions.

Salary and Benefits:

• £50,000 - £80,000 depending on experience
• Contributory pension scheme
• Life assurance
• Flexible benefits programme

Full Job Description Attached Under 'Documents'

RSK Group is proud to be an Equal Opportunities Employer

#Engineering

The Company:

RSK is a global leader in sustainable solutions focusing on environmental, engineering, and technical services. Working together, we address societal challenges aligned with the United Nations Sustainable Development Goals, offering integrated solutions across sectors such as water, energy, food, infrastructure, cities, mining, and waste management.

We are committed to fostering an inclusive workplace that welcomes individuals from all backgrounds, experiences, and perspectives. We firmly believe that embracing and celebrating the diversity in our workforce makes us a stronger and more innovative company.

By providing workplace adjustments, we make it easier for people to confidently explore and pursue our career opportunities and recognise that flexibility is key to fostering a dynamic and thriving workplace. Many of our office-based positions benefit from a flexible working arrangement, allowing our team members to achieve a balance between professional and personal commitments.

We actively encourage applications from candidates of all genders, races, ethnicities, ages, neurotypes, religions or beliefs, sexual orientations, and those with disabilities.

Since the beginning, our philosophy has remained the same: employ, develop and reward talented individuals. People are crucial to our company, and we recognise that our success hinges on our colleagues' growth. We're committed to preserving RSK's people-first culture, promoting innovation, and fostering a supportive and caring environment for collaboration. At RSK, we want you to be part of our successes and help you reach your career aspirations. We take pride in offering employees fulfilling and challenging careers by promoting ongoing growth and empowering individuals to excel.

If you're passionate about making a difference, join us as we work together to build a brighter, more equitable, and sustainable future for all. Do you have what it takes?