Senior Analytics Engineer

About the role

As a Senior Analytics Engineer at Constantinople, you will design, build, and maintain the data models and transformation pipelines that power client reporting, regulatory reporting, and analytics across the business.

What you'll do

• Design, build, and maintain dbt models that transform raw data into clean, well-documented, analysis-ready datasets
• Write and optimise SQL in Snowflake, keeping models performant and cost-efficient as data volumes grow
• Own data quality within your models by implementing tests, documentation, and validation checks that catch issues before they reach downstream consumers
• Partner with Product, Risk, Finance, and Client Delivery to understand reporting needs and turn them into reusable data models rather than one-off queries
• Support and troubleshoot data issues affecting live customer reporting, including taking part in an on-call rotation

What you need

• Analytics
• SQL
• dbt
• Snowflake
• Data modelling
• Data warehousing
• Any graduate

Good to have

• Airflow