Job Description
Responsibilities
n
n
Implement enhancements and changes to existing reporting processes to improve accuracy, performance, and usability
n
Design and develop new reporting pipelines and datasets aligned with business requirements
n
Automate of data delivery processes
n
Identify and implementation of automated data quality checks
n
Resolve of issues related to data quality
n
Collaborate with business stakeholders to gather reporting requirements, clarify logic, and ensure outputs meet expectations
n
n
Requirements
n
n
4+ years in analytics engineering or similar data-focused roles
n
Advanced PostgreSQL: stored procedures and functions, complex CTEs, window functions, SCD2 patterns, query plan analysis and optimisation
n
Strong understanding of data warehouse architecture: staging, core, and data mart layers; incremental load patterns; slowly changing dimensions
n
Hands-on experience with Apache Airflow: DAG authoring, scheduling, dependency management, and failure handling
n
Proficiency with Git (GitLab or GitHub) and JIRA
n
Experience designing and evolving data warehouse architecture and data models
n
Track record of building robust, maintainable ELT/ETL pipelines in production
n
Experience implementing automated data quality checks
n
Domain fluency in financial and trading concepts,



with the ability to understand requirements and clearly explain implemented logic to business stakeholders
n
High degree of autonomy: able to reverse-engineer undocumented systems, identify root causes, and take end-to-end ownership of pipelines and calculation logic
n
Comfortable using AI-assisted development tools (e.g., Claude, Copilot, Cursor) to improve productivity
n
n
Nice to have
n
n
Hands-on experience with dbt, particularly in the context of migration or adoption initiatives
n
Exposure to Snowflake or strong interest in working with it as part of a target data architecture
n
Proficiency in Python for scripting, automation, and data pipeline tooling
n
Background in fintech or financial services in any capacity
n
n
What You Will Get In Return
n
n
Competitive compensation
n
A generous paid leave policy, supporting a healthy work-life balance
n
Two additional paid days per year dedicated to volunteering and giving back
n
Private medical insurance for your peace of mind
n
An additional versatile benefits budget, allowing you to tailor benefits to your needs
n
Flexible working mode
n
The chance to work from almost anywhere in the world for up to 30 days per year
n
Annual company-wide events held in locations around the globe
n
In-office massages to support wellbeing
n

📌 Senior Data Engineer (Financial Analytics Focus) (Victoria)
🏢 capital.com
📍 Victoria