At a Glance
- Tasks: Enhance reporting processes and design new data pipelines for financial analytics.
- Company: Dynamic fintech company focused on innovation and collaboration.
- Benefits: Competitive pay, generous leave, private health insurance, and flexible work options.
- Other info: Enjoy a vibrant work culture with annual global events and wellness perks.
- Why this job: Join a team that values your input and offers global opportunities.
- Qualifications: 4+ years in data engineering with strong PostgreSQL and data warehouse skills.
The predicted salary is between 121500 - 148500 $ per year.
Responsibilities
- 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 Postgre SQL: 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 (Git Lab or Git Hub) 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
- #J-18808-Ljbffr
Senior Data Engineer employer: Capital.com
At DrivingCapital.com, we pride ourselves on being an exceptional employer that values our employees' well-being and professional growth. With a competitive salary, generous time off, and unique benefits like remote work opportunities and volunteer days, we foster a supportive work culture that prioritises work-life harmony. Join our dynamic team in Australia, where you'll not only enhance your career in the financial markets but also contribute to a company that genuinely cares about making a positive impact.
We think you need these skills to ace Senior Data Engineer
PostgreSQL
Stored Procedures
Complex CTEs
Window Functions
SCD2 Patterns
Query Plan Analysis
Data Warehouse Architecture
