Source description
About the role
4+ years in analytics engineering or similar data-focused roles
Advanced PostgreSQL: stored procedures and functions, complex CTEs, window functions, SCD2 patterns, query plan analysis and optimisation
Strong understanding of data warehouse architecture: staging, core, and data mart layers; incremental load patterns; slowly changing dimensions
Hands-on experience with Apache Airflow: DAG authoring, scheduling, dependency management, and failure handling
Proficiency with Git (GitLab or GitHub) and JIRA
Experience designing and evolving data warehouse architecture and data models
Track record of building robust, maintainable ELT/ETL pipelines in production
Experience implementing automated data quality checks
Domain fluency in financial and trading concepts, with the ability to understand requirements and clearly explain implemented logic to business stakeholders
High degree of autonomy: able to reverse-engineer undocumented systems, identify root causes, and take end-to-end ownership of pipelines and calculation logic
Comfortable using AI-assisted development tools (e.g., Claude, Copilot, Cursor) to improve productivity
More at Capital.com