Hybrid Data Analyst – Financial Analytics

at Capital.com

• Job title: Data Analyst – Financial Analytics
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: No Education Requirement
• Tech skills: Airflow, Apache, Postgres, SQL
• Location requirements: Hybrid, Sofia City, Bulgaria

About the role

• Data Analyst with a focus on financial analytics in fintech, implementing reporting processes and collaborating with stakeholders.

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

Benefits

• 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