Capital.com

Data Engineer – Financial Analytics

Capital.com

full-time

Posted on:

Location Type: Hybrid

Location: Melbourne • Australia

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowApacheETLPostgres

About the role

  • 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
Benefits
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PostgreSQLstored proceduresfunctionscomplex CTEswindow functionsSCD2 patternsquery plan analysisdata warehouse architectureELT pipelinesETL pipelines
Soft Skills
collaborationproblem-solvingcommunicationautonomyownership