Data Analyst (Financial Analytics focus)

TLDR

Join a talented team developing and maintaining data pipelines and analytics for a complex financial data platform using advanced technologies like PostgreSQL and Airflow.

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
  • 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 creativity. Work alongside one of the most brilliant teams in the industry.

    Benefits

    In-office massages

    In-office massages to support wellbeing

    Health Insurance

    Private medical insurance for your peace of mind

    Company-wide events

    Annual company-wide events held in locations around the globe

    Paid Time Off

    A generous paid leave policy, supporting a healthy work–life balance

    Remote-Friendly

    The opportunity to work from almost anywhere in the world for up to 30 days per year

    Capital.com is an innovative trading platform designed for a global audience, offering top-rated financial products that emphasize a seamless user experience. We're committed to pushing the boundaries of technology in the trading industry, making it easy for users to access the financial markets and achieve their investment goals.

    View all jobs
    Ace your job interview

    Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

    Data Analyst Q&A's
    Report this job
    Apply for this job