Data Analyst (Financial Analytics focus) - Capital

Job Title: Data Analyst (Financial Analytics focus)
Job Location: Sofia City, Bulgaria
Job Listing URL: https://jobs.lever.co/capital/5a729f11-ad21-4e28-8019-a096032b1ca6
Job Description: 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

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