data engineer.

Analytical Data Modelling

• Design and implement scalable analytical data models in SQL used by BI tools and analytics platforms.
• Build datasets that support consistent business metrics, reporting and analysis.
• Implement modelling approaches such as star schemas, denormalised analytical tables and reusable metric layers.

Data Analysis & Profiling

• Profile complex datasets to understand data structure, quality and business meaning.
• Investigate and interpret source data to inform robust analytical modelling decisions.
• Translate business questions into well-structured analytical datasets.

SQL Engineering

• Develop robust SQL transformations to convert raw source data into trusted analytical assets.
• Ensure analytical models are scalable, performant and maintainable within a cloud data warehouse.
• Optimise SQL logic for performance and efficient data processing.

Collaboration

• Work closely with analysts, visualisation developers, data engineers and business stakeholders.
• Contribute to the development of reusable data assets and consistent analytical definitions.
• Support the evolution of the organisation's analytics data layer and self-service reporting capability.

The ideal candidate will combine strong analytical thinking with advanced SQL engineering capability, and will have experience designing analytics-ready datasets used by BI tools or semantic layers. This is not a pipeline engineering role; we are looking for someone experienced in building analytical data models that define consistent business metrics and enable self-service analytics., * Advanced SQL skills with experience engineering complex analytical transformations.

• Proven experience building analytical data models used by BI tools or reporting platforms.
• Experience designing analytics-ready datasets rather than ingestion pipelines.
• Strong experience with cloud data warehouse platforms (preferably Google BigQuery / GCP).
• Strong data analysis and data profiling capability with the ability to interpret complex datasets.
• Experience implementing analytical modelling approaches such as star schemas or wide tables.

Desirable Skills

• Experience working with semantic layers or metrics layers (e.g. Looker / LookML).
• Experience designing consistent business metrics used across reporting and analytics.
• Python experience for data analysis, automation or advanced analytics workflows.
• Exposure to AI-enabled analytics tools or modern data workflows.
• Experience working in commercial or marketing analytics environments.
• Telecommunications or subscription business experience would be advantageous.

If you're excited about application security, identity management, and creating robust, secure solutions for modern architectures, we want to hear from you!