Senior PostgreSQL Data Engineer – Financial Sector

ITDS Business Consultants; United States; Remote; USD 78,000 - 123,000; Full time

Job summary

ITDS Business Consultants is seeking a Senior PostgreSQL / Data Engineer to design and operate high-performance PostgreSQL solutions for a major financial sector client. This role is 100% remote with a focus on real-time data processing and scalable analytics.

You will optimize queries, implement data models, and collaborate with cross-functional teams using RabbitMQ and ETL pipelines. Strong PL/pgSQL and Linux experience are required, with 5+ years in PostgreSQL and data engineering.

Qualifications

• Minimum 5 years of experience with PostgreSQL, including advanced SQL and data modeling.
• Proven expertise in PostgreSQL architecture, partitioning, indexing, and performance monitoring.
• Strong knowledge of PL/pgSQL, stored procedures, functions, and triggers.
• Practical experience with large data volumes, performance tuning, and Big Data environments.
• Hands-on experience with Linux environment setup and maintenance.

Responsibilities

• Design, develop, and maintain high-performance PostgreSQL database solutions for large-scale financial data processing.
• Optimize database performance through advanced tuning, indexing, and data modeling.
• Build and implement data models to support near real-time analytics.
• Collaborate with cross-functional teams to ensure seamless data integration using RabbitMQ and ETL processes.
• Monitor system performance and troubleshoot issues to ensure high availability and scalability.
• Automate deployment and maintenance tasks using CI/CD pipelines.
• Participate in planning and executing database migration, archiving, and data retention strategies.

Skills

PostgreSQL

SQL

Data modeling

Performance tuning

Partitioning

Indexing

PL/pgSQL

Linux

Big Data

Python scripting

Tools

RabbitMQ

Kafka

Apache Airflow

CI/CD

ETL processes

Job description

Remote

Polish

Senior

Unleash data-driven innovation - build high-performance platforms for the financial market!

100% remote work.

As a Senior PostgreSQL / Data Engineer, you will be working for our client, a leader in the financial sector, dedicated to developing a cutting-edge enterprise data platform. You will help shape the future of real-time data processing and analytics, handling millions of messages daily within a high-availability environment, contributing to impactful financial insights and decision-making.

Your main responsibilities:

• Design, develop, and maintain high-performance PostgreSQL database solutions tailored to large-scale financial data processing.
• Optimize database performance through advanced tuning, indexing, and efficient data modeling practices.
• Build and implement data models, including normalization and denormalization, to support near real-time analytics.
• Collaborate with cross-functional teams to ensure seamless data integration, using technologies like RabbitMQ and ETL processes.
• Monitor system performance and troubleshoot issues to guarantee high availability and scalability.
• Automate deployment and maintenance tasks, leveraging CI/CD pipelines for continuous improvement.
• Participate in planning and executing database migration, archiving, and data retention strategies aligned with industry standards.

You're ideal for this role if you have:

• Minimum 5 years of experience working with PostgreSQL, including advanced SQL and data modeling skills.
• Proven expertise in PostgreSQL architecture, table partitioning, indexing (B-Tree, Hash, GIN, GiST, BRIN), and performance monitoring.
• Strong knowledge of PL/pgSQL, stored procedures, functions, and triggers.
• Practical experience with large data volumes, performance tuning, and Big Data environments.
• Hands-on experience with Linux environment setup and maintenance.

It is a strong plus if you have:

• Python scripting skills.
• Experience with Kafka, RabbitMQ, or Apache Airflow.
• Familiarity with CI/CD practices.
• Background in banking or financial services sectors.

Language required for the role:

• Polish: Good command

Eligibility to work in:

Only candidates with an existing legal right to work in the European Union will be considered for this role.