Data Engineer
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
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.
Were looking for a skilled Data Engineer to help design build and optimize the data systems that power our regulatory reporting and analytics. Youll take ownership of our PostgreSQL environment and Airflow pipelines ensuring performance reliability and data integrity across critical reporting 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 pgstat* 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).
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 pgstatstatements.
- 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.
What you will get in return:
- 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 aboutyoubecause your life outside of work matters just as much as your time on the clock.
- Annual Performance Bonus:Your hard work doesnt 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 weve 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.
Be a key player at the forefront of the digital assets movement propelling your career to new heights!Join a dynamic and rapidly expanding company that values and rewards talent initiative and alongside one of the most brilliant teams in the industry.
We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Enjoy online trading like never before. With Capital.com’s app, you can discover investment opportunities on leading financial markets. Access the latest trading insights at the touch of a button, as well as in-depth educational features, comprehensive financial analysis and the day’s ... View more
