Olive Jobs
capital.com logo

Senior Data Engineer (Financial Analytics focus)

capital.com

Melbourne, Victoria, AustraliaFlexibleFull-timeNo compensation foundPosted 2mo agoVerified open 4 days ago
Evaluate my fit

Most applications go out cold — see where you stand first. No sign-up to start.

Don't just apply. Show up ready.

Olive works from this exact posting — no sign-up to start.

Evaluate your fitSee where you stand — strengths, gaps, and what to fix first.Get started →Tailor your résuméRewritten against this posting, with a diff of every change.Get started →Practice the interviewA voice mock interview built from this job description.Get started →

At a glance

Compensation
No compensation found
Location
Melbourne, Victoria, AustraliaFlexible
Schedule
Full-time
Work Authorization
Not specified

Job overview

capital.com is hiring a Senior Data Engineer (Financial Analytics focus). The company seeks a Data Engineer to develop and maintain data pipelines, transformation logic, and data quality checks for a complex multi‑jurisdiction financial data platform, collaborating with stakeholders and leveraging PostgreSQL, Airflow, and AI‑assisted tools.

Key focus areas include Implement enhancements and changes to existing reporting processes to improve accuracy, performance, and usability, Design and develop new reporting pipelines and datasets aligned with business requirements, and Automate data delivery processes.

Successful candidates bring 4+ Years In Analytics Engineering Or Similar Data-Focused Roles. Important skills include PostgreSQL, Stored Procedures And Functions, Complex CTEs, Window Functions, SCD2 Patterns, and Query Plan Analysis And Optimisation. Preferred (not required): dbt, Snowflake, Python, and Fintech Background.

Skills & qualifications

RequiredNice to have

Skills

PostgreSQLStored Procedures and FunctionsComplex CTEsWindow FunctionsSCD2 PatternsQuery Plan Analysis and OptimisationData Warehouse ArchitectureStaging, Core, and Data Mart LayersIncremental Load PatternsSlowly Changing DimensionsApache AirflowDAG AuthoringSchedulingDependency ManagementFailure HandlingGitGitLabGitHubJiraData Models DesignELT/ETL PipelinesAutomated Data Quality Checks ImplementationFinancial and Trading ConceptsHigh Degree of AutonomyReverse-Engineer Undocumented SystemsIdentify Root CausesEnd-to-End OwnershipAI-Assisted Development ToolsClaudeCopilotCursorDbtSnowflakePythonFintech BackgroundFinancial Services BackgroundData Quality ChecksFinancial Domain Fluency

Qualifications

4+ Years Analytics Engineering Experience

Benefits

Medical Insurance
Paid Time Off

Full job description

We are a leading trading platform that is ambitiously expanding to the four corners of the globe. Our top-rated products have won prestigious industry awards for their cutting-edge technology and seamless client experience. We deliver only the best, so we are always in search of the best people to join our ever-growing talented team.

We are seeking a Data Engineer to join our Financial Analytics team developing and maintaining data pipelines, transformation logic, and data quality checks in a complex multi-jurisdiction financial data platform (PostgreSQL DWH + Airflow orchestration).

Responsabilities

  • Implement enhancements and changes to existing reporting processes to improve accuracy, performance, and usability
  • Design and develop new reporting pipelines and datasets aligned with business requirements
  • Automate of data delivery processes
  • Identify and implementation of automated data quality checks
  • Resolve of issues related to data quality
  • Collaborate with business stakeholders to gather reporting requirements, clarify logic, and ensure outputs meet expectations

Requirements

  • 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

Nice to have

  • Hands-on experience with dbt, particularly in the context of migration or adoption initiatives
  • Exposure to Snowflake or strong interest in working with it as part of a target data architecture
  • Proficiency in Python for scripting, automation, and data pipeline tooling
  • Background in fintech or financial services in any capacity

What you will get in return

  • Competitive compensation
  • A generous paid leave policy, supporting a healthy work–life balance
  • Two additional paid days per year dedicated to volunteering and giving back
  • Private medical insurance for your peace of mind
  • An additional flexible benefits budget, allowing you to tailor benefits to your needs
  • Flexible working mode
  • The opportunity to work from almost anywhere in the world for up to 30 days per year
  • Annual company-wide events held in locations around the globe
  • In-office massages to support wellbeing

You've read the whole posting — now see how you match it.

Evaluate my fit
Senior Data Engineer (Financial Analytics focus) | Olive Jobs