Senior Data Engineer – Financial Analytics & ELT (Remote)

Capital; City of Melbourne; Hybrid; AUD 120,000 - 180,000; Full time

Benefits offered by this job

Competitive compensation

Generous leave policy

Volunteer days

Private medical insurance

Flexible benefits budget

Flexible working mode

Global travel/remote time

Job summary

Capital is seeking a Data Engineer to join the Financial Analytics team. You will develop and maintain data pipelines, transformation logic, and data quality checks in a complex multi-jurisdiction data platform (PostgreSQL DWH + Airflow).

You will implement new reporting pipelines, ensure data quality, and collaborate with stakeholders to gather requirements and deliver accurate outputs. Flexible working mode and global collaboration are supported.

Qualifications

• 4+ years in analytics engineering or similar data-focused roles.
• Advanced PostgreSQL: stored procedures, complex CTEs, window functions, SCD2 patterns, plan optimisation.
• Strong understanding of data warehouse architecture: staging/core/data mart, incremental loads, slowly changing dimensions.
• Hands-on experience with Apache Airflow: DAG authoring, scheduling, dependency management, failure handling.
• Proficient with Git (GitLab/GitHub) and JIRA.
• Experience designing and evolving data warehouse architectures and data models.
• Track record of robust, maintainable ELT/ETL pipelines in production.
• Experience implementing automated data quality checks.
• Domain fluency in financial/trading concepts for clear stakeholder communication.
• High autonomy, reverse-engineering undocumented systems and end-to-end ownership.

Responsibilities

• Implement enhancements to reporting processes for accuracy, performance, usability.
• Design and develop new reporting pipelines and datasets per business requirements.
• Automate data delivery processes.
• Implement automated data quality checks.
• Resolve data quality issues and root causes.
• Collaborate with stakeholders to clarify logic and outputs.

Skills

Advanced PostgreSQL

Apache Airflow

Data warehouse design

ELT/ETL pipelines

Python

SQL

Data quality checks

Fintech domain knowledge

Autonomy

AI-assisted development tools

Tools

dbt

Snowflake

Git

JIRA

Job description

Capital is seeking a Data Engineer to join the Financial Analytics team. You will develop and maintain data pipelines, transformation logic, and data quality checks in a complex multi-jurisdiction data platform (PostgreSQL DWH + Airflow).

You will implement new reporting pipelines, ensure data quality, and collaborate with stakeholders to gather requirements and deliver accurate outputs. Flexible working mode and global collaboration are supported.