Open to opportunities

Colin Ratcliffe

@colinratcliffe

Message

Analytics Engineer with 9 years’ experience building source-of-truth data stacks with dbt, Snowflake, and GCP.

Spain

Message

What I'm looking for

I’m looking to help teams build trustworthy, scalable analytics by designing data models, modern transformation pipelines, and automated data quality—using stacks like dbt, Snowflake, and GCP—so stakeholders get dependable source-of-truth insights.

I’m an Analytics Engineer with 9 years of experience across analytics, data engineering, and BI roles. I’ve built and migrated complex data infrastructures, and I focus on delivering reliable “source-of-truth analytics” using modern data stacks such as dbt, Snowflake, and GCP.

In my recent work at Bitpanda, I onboarded dbt as the primary transformation tool, led end-to-end core data model design (including trades, transactions, and user events), and created the first user sessions model with in-house sessionization logic. I also designed data quality monitoring for reconciliation and built an MVP LLM knowledgebase modeled on Karpathy’s LLMWiki concept.

Experience

Work history, roles, and key accomplishments

Business Intelligence Developer

Deutsche Bank

Oct 2019 - Oct 2020 (1 year)

Designed and built a Hadoop-powered intelligent data quality system that automated generation of data quality rules for diverse datasets. Developed reconciliation ETLs and delivered self-service QlikSense/Tableau dashboards for prediction model inputs and visualizations.

Hadoop Scala Data Quality Rules Development ETL Data Reconciliation Tableau

Web Analytics Intern

Smava

Jan 2017 - Jul 2017 (6 months)

Performed ad-hoc product analyses using Google Analytics and Kissmetrics and built Tableau dashboards with alerting for multiple departments. Created Pentaho-based ETLs to sync data into a data warehouse and implemented tracking tags via Google Tag Manager.

Google Analytics Kissmetrics Tableau Alerting Pentaho ETL Google Tag Manager

Business Intelligence Analyst

Sap

Jul 2016 - Dec 2016 (5 months)

Built a partner-contract database to optimize financial forecasting and created a front-end for salespeople to query and enter contract data. Led training sessions to onboard the team to the new tool.

Financial Forecasting Database Design