Data Analyst
Sofia City, Bulgaria / Limassol, Cyprus / Warsaw, Poland
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.
We are seeking a Data Analyst to join our Financial Analytics team developing and maintaining data pipelines, transformation logic, and data quality checks in a complex multi-jurisdiction financial data platform (PostgreSQL DWH + Airflow orchestration).
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
Identy and implementation of automated data quality checks
Resolve of issues related to data quality
Collaboorate 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
2+ years in fintech or relevant domains (retail FX/CFD, hedge or quant funds, prop trading firms, or financial services technology)
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
Practical experience implementing complex financial calculation logic in SQL (e.g., P&L, margin, equity, positions, ledger reconciliation)
Ability to interpret regulatory or business specifications and translate them into precise, testable SQL transformation logic
Solid 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
Experience with regulatory reporting frameworks: MiFID II, EMIR, FCA, CySEC, ASIC or equivalent
Domain knowledge in: risk management, compliance reporting, internal accounting, spread/commission capture, margin requirements
Tableau or equivalent BI tool — specifically experience with live datasources backed by DWH functions
dbt familiarity
Snowflake exposure or interest
Published on: 3/29/2026

Capital.com
Capital.com is a high-growth, investment trading fintech group of companies empowering people to participate in financial markets.
Please let Capital.com know you found this job on Wantapply.com. It helps us to get more jobs on our site. Thanks!





