Data engineer in fintech

ALTEN – A global leader in engineering and IT services. ALTEN Polska has been operating for 13 years, supporting its clients’ innovation, research and development, and IT systems. It has offices in Kraków, Warsaw, Wrocław, Gdańsk and Poznań. It serves key industries, including aviation, space, industrial, automotive, rail, energy, financial, telecommunications and sales.

• Designing, developing and maintaining a high-performance data platform for the financial market (FX)
• Creating and developing PostgreSQL-based solutions for real-time data processing
• Data structure modelling and design
• Optimising database and SQL query performance
• Creating and maintaining procedures, functions and triggers in PL/pgSQL
• Integrating data sources and ETL processes
• Handling and processing very large data volumes (approximately 40 million messages per day)
• Contributing to the integration of the platform with RabbitMQ and other streaming technologies
• Monitoring the performance of the PostgreSQL environment
• Ensuring high availability, scalability and stability of the data platform
• Supporting business teams that require access to data refreshed almost in real time

• At least 5 years of experience working with PostgreSQL
• Very good knowledge of SQL and PL/pgSQL (procedures, functions, triggers)
• Experience in data design and modelling (relational modelling, normalisation and denormalisation)
• Practical experience in optimising database and SQL query performance
• Ability to analyse query execution plans and tune indexes
• Knowledge of PostgreSQL architecture, table partitioning, and B-Tree, Hash, GIN, GiST and BRIN indexes
• Experience working with Materialized Views, VACUUM, ANALYZE, autovacuum and database performance monitoring
• Practical knowledge of ETL processes and integrations
• Experience working with large data volumes and Big Data environments
• Knowledge of Linux
• Ability to design and maintain scalable and highly available data platforms
• Будет плюсом:
  Python;
  Kafka or RabbitMQ;
  Apache Airflow;
  Knowledge of CI/CD;
  Experience in the banking or financial sector

• We offer a full-time employment contract
• Location – Warsaw/Wrocław/Poznań; work model – remote
• Stable, long-term cooperation
• A clearly defined career path at a European leader in engineering and IT consulting
• Possibility of relocation between ALTEN Polska’s local branches
• Possibility of joining another project within the company after the current project ends
• Onboarding and cooperation with a dedicated Competences Manager
• Medicover medical care
• Medicover dental care
• Medicover Benefits platform
• Medicover sports card
• Referral programme
• A welcome package for an employee’s newborn child
• Group life insurance
• Pension programme
• We also offer cooperation on a B2B or contract of mandate (UZ) basis.
• Access to professional certifications from our technology partners (e.g. Google, ISTQB)
• Access to industry events
• Access to the Knowledge Sharing Program
• Access to the referral programme