Capital1mo ago

Data Analyst (Financial Analytics focus)

Sofia CityHybridmid

Data ScienceData AnalystData & AI

0 views0 saves0 applied

Apply Now

Quick Summary

Requirements Summary

stored

Technical Tools

Data ScienceData AnalystData & AI

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).

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

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

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

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