Geforderte Skills
Sprachen: English · Polish
Jobbeschreibung
Project overview
Hi there! If you’re looking for a high-impact position in an ambitious software house, we’ve got a match for you!
We are looking for a Data Engineer to work with our customer. Our client is a globally operating financial services provider specializing in online CFD trading across forex, commodities, indices, metals, energy, and cryptocurrencies. It combines advanced trading technology, competitive pricing, and fast trade execution to deliver a seamless trading experience for retail and institutional clients. The company operates across multiple international markets and maintains a strong focus on regulatory compliance, client satisfaction, and long-term partnerships with affiliates and introducing brokers.
The first priority is to take over and stabilise our existing data platform and bring its two parts together into one, rather than rebuild it.
rice-to-Haves:
- Take end-to-end ownership of the existing production data platform, focusing initially on stabilizing operations and consolidating two separate platform components into a single, cohesive environment.
- Architect, optimize, and maintain Snowflake as the primary data warehouse, managing warehouse sizing, clustering, query performance tuning, cost optimization, role-based access control (RBAC), and data masking.
- Design and implement scalable dimensional data models and write complex, high-performance SQL queries to support financial and regulatory reporting.
- Develop, test, and maintain production dbt pipelines following the medallion architecture, utilizing sources, snapshots, macros, exposures, automated testing, and CI/CD workflows.
- Build and maintain enterprise Power BI semantic models and reports (using DAX and Power Query/M), implementing incremental refresh strategies as well as row- and object-level security (RLS/OLS).
- Implement robust data quality monitoring, alerting, and data governance frameworks, ensuring strict compliance with FCA and UK GDPR standards—particularly when handling personal and regulatory financial data (such as client money, capital, and reconciliations).
- Substantial hands-on data engineering, including owning at least two production data platforms end-to-end.
- A track record of two years or more per engagement; full-time on UK hours, with cover for critical data feeds; able to visit London regularly for short periods.
- Snowflake in production as the primary tool: design, warehouse sizing, clustering, query profiles, cost control, role-based access and masking.
- Expert SQL (including on Snowflake) and dimensional data modelling.
- Two years or more of dbt in production: sources, snapshots, tests, macros, exposures, the medallion pattern, CI/CD.
- Experience in production Power BI: DAX, Power Query/M, semantic models with row- and object-level security and incremental refresh.
- Working knowledge of AWS for data workloads (S3, ECS/Fargate or Lambda, change data capture, IAM) and Python, working with our infrastructure engineer, who owns AWS.
- Data quality monitoring and alerting; data governance and handling of personal data under FCA and UK GDPR requirements.
Project details
- Start: ASAP
- Remote: hybrid
- Location: Remote, Warszawa, PL
- Rate: 170-220 EUR/h
- Languages: English, Polish
Indexiert von der 9am-Meta-Suche. Du bist Job-Anbieter? Listing beanspruchen oder verwalten
Gefunden auf nofluffjobs.com