Data Engineer responsible for designing, building, and optimizing data systems at a leading trading platform. Managing PostgreSQL environments and Airflow pipelines for regulatory reporting and analytics.
Responsibilities
Design, implement, and optimize database objects and complex PL/pgSQL procedures to support regulatory reporting use cases.
Build and maintain robust DB dependencies: primary/foreign keys, constraints, triggers, partitions, and scheduled maintenance routines.
Own Postgres performance and hygiene: capacity planning, index maintenance, partition strategy, VACUUM/ANALYZE, and systematic tuning using EXPLAIN and pg_stat_statements.
Develop, schedule, and operate data pipelines as DAGs (in Airflow): ingestion, transformations, validations, and deliveries to reporting targets.
Implement proactive alerting and on-failure workflows.
Requirements
2+ years’ experience as a Data Engineer (or similar) working heavily with PostgreSQL.
Expert SQL and strong PL/pgSQL: able to design, implement, and maintain complex stored procedures/functions.
Deep PostgreSQL fundamentals: schema design and normalization, indexing strategies, constraints (PK/FK/UNIQUE/CHECK), triggers, table partitioning.
Experience with EXPLAIN/ANALYZE, query optimization, VACUUM/ANALYZE, bloat detection/mitigation, and use of pg_stat_* views.
Experience building and operating DAGs (Apache Airflow), including SLAs, retries, and dependencies.
Experience with Version control & CI/CD (GitHub/GitLab), code reviews.
Data quality and governance mindset: validation checks, lineage/documentation, and auditability.
Nice to have domain familiarity with reporting in fintech/brokerage (e.g., trade/transaction reporting for CFD brokers; understanding of controls, reconciliations, and audit needs).
Benefits
Competitive Salary: We believe great work deserves great pay! Your skills and talents will be rewarded with a salary that makes you feel valued and motivated.
Work-Life Harmony: Join a company that genuinely cares about *you*—because your life outside of work matters just as much as your time on the clock.
Annual Performance Bonus: Your hard work doesn’t go unnoticed! Celebrate your achievements with a well-deserved annual bonus tied to your performance.
Generous Time Off: Need a breather? Our annual leave policy lets you recharge and enjoy life outside of work without a worry.
Employee Referral Program: Love working here? Share the love! Bring your talented friends on board and get rewarded for growing our awesome team.
Comprehensive Health & Pension Benefits: From medical insurance to pension plans, we’ve got your back. Plus, location-specific benefits and perks!
Workation Wonderland: Live your digital nomad dreams with 30 extra days to work remotely from anywhere in the world (some restrictions apply). Adventure awaits!
Volunteer Days: Make a difference! Take two additional paid days each year to support causes you care about and give back to the community.
Senior AI & Data Engineer developing and implementing AI solutions in collaboration with clients and teams. Working on projects involving generative AI, predictive analytics, and data mastery.
Consultant driving IA business growth in Deloitte's Artificial Intelligence & Data team. Delivering innovative solutions using data analytics and automation technologies.
Data Engineer responsible for managing data architecture and pipelines at Snappi, a neobank. Collaborating with teams to enable data processing and analysis in innovative banking solutions.
Data Engineer at Destinus developing the data platform to support production and analytics needs. Involves migrating Excel sources to Lakehouse and integrating ERP systems in a hybrid role.
Senior Data Engineer developing solutions within the Global Specialty portfolio at an insurance company. Engaging with diverse business partners to ensure high quality data reporting.
Data Engineer at UBDS Group focusing on designing and optimizing modern data platforms. Collaborating in a multidisciplinary team to develop reliable data assets for analytics and operational use cases.
Data Engineer (dbt) at SDG Group involved in all phases of data projects. Collaborate on data ingestion, transformation, and visualization in a hybrid environment.
Data Consultant at SDG Group specializing in Data & Analytics projects. Collaborate on technical - functional definitions, ETL, data modeling, and visualization for cloud solutions.
Senior Data Engineer responsible for growing customer - defined targeting calculations and developing key/value databases for real - time data processing.
Data Engineer developing and maintaining the Data Lakehouse platform using Microsoft Azure technology stack at RBC. Collaborating with business and technology teams to enhance data ingestion and modeling processes.