The Role
Build and maintain dbt data models and Snowflake transformation pipelines supporting client, regulatory, and business reporting. Ensure data quality through testing, documentation, and validation; optimize SQL performance; troubleshoot live reporting issues; and collaborate with Product, Risk, Finance, Client Delivery, and engineering teams. Help establish modeling standards and contribute to code reviews, maintainability, and reliable analytics in a fast-paced startup environment.
Summary Generated by Built In
Constantinople delivers a new era of AI-native banking. Constantinople provides banks with a fully-managed software and AI operational platform, which brings together customer experience, product, data, operations, compliance and infrastructure in a single platform.
Constantinople’s AI-native platform eliminates the need for expensive infrastructure, and replaces manual operational and compliance processes with AI at scale. By removing the operational complexity of banking, Constantinople enables our client banks to focus on their customers and the business of banking.
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. You will work closely with cross-functional teams including Product, Risk, Finance, and Client Delivery to turn raw platform data into clean, well-modelled datasets the whole company can rely on, using dbt and Snowflake as the backbone of our analytics stack. We are a small team, so you will own meaningful pieces of work end to end and help set the standard for how we build.
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. You will work closely with cross-functional teams including Product, Risk, Finance, and Client Delivery to turn raw platform data into clean, well-modelled datasets the whole company can rely on, using dbt and Snowflake as the backbone of our analytics stack. We are a small team, so you will own meaningful pieces of work end to end and help set the standard for how we build.
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
- Support the delivery of key metrics used in board, client, and regulatory reporting, where getting the numbers right matters
- Help maintain and evolve our modelling standards, naming conventions, and dbt project structure as the business grows
- Work with data and platform engineers on upstream pipelines, flagging data quality or structural issues at the source
- Take part in code reviews and help improve model quality, testing, and maintainability across the team
Who You Are
- You have hands-on experience building and maintaining data models in dbt, including tests and documentation
- You have strong SQL skills, with experience writing and optimising queries in Snowflake or a similar cloud data warehouse
- You have a solid understanding of data modelling concepts such as dimensional modelling and star schemas, and can apply them to messy real-world data
- You have worked with an orchestration tool such as Airflow to schedule and monitor pipelines
- You communicate well and are comfortable working directly with non-technical stakeholders to understand what they need
- You are detail-oriented and care about data quality, with a habit of catching issues before they become someone else's problem
- You are comfortable in a fast-paced start-up environment, pragmatic about scope and sequencing, and careful with data that people make decisions on
Application process:
If this sounds like the kind of opportunity you've been looking for, select the 'Apply Now' button below to submit your cover letter and resume. Use your cover letter to introduce us to you; we want to know who you are, what you've worked on and why you think you'd be a great addition to the Constantinople team.
Inclusion
To build technology and products that are used and loved by people and solve real-world problems, we need to build a team with many different perspectives and experiences. We are an equal-opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
We encourage candidates from all backgrounds to apply. Applicants in need of special assistance or accommodation during the interview process or in accessing our website may contact us. We will treat your request as confidentially as possible. In your email, please include your name and preferred method of contact, and we will respond as soon as possible.
Skills Required
- Hands-on experience building and maintaining dbt data models, including tests and documentation
- Strong SQL skills and experience writing and optimizing queries in Snowflake or a similar cloud data warehouse
- Understanding of dimensional modeling and star schemas, with the ability to apply them to real-world data
- Experience with an orchestration tool such as Airflow to schedule and monitor pipelines
- Strong communication skills and comfort working directly with non-technical stakeholders
- Detail-oriented approach and demonstrated commitment to data quality
- Comfort working in a fast-paced startup environment with pragmatic scope and sequencing
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Constantinople is the first of its kind: an all-in-one software and operational platform for banks. We host and manage your bank’s customers directly on our cloud-native infrastructure. We support a full-suite of banking products which are branded as your own, together with all operational services needed to run your bank. Constantinople’s state-of-the-art platform frees you from running expensive infrastructure and replaces manual operational and compliance processes with automation at scale. By removing the operational complexity of banking, Constantinople allows you to focus on your customers and the business of banking. Get in touch: https://www.cxnpl.com/
