Data engineer in finance

Astek; United States; Teletrabalho; USD 47 000 - 52 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

100% remote work

Private medical care

Life insurance

Team-building events

Career development

Mentoring Center

Resumo da oferta

Astek ищет специалиста по данным на позицию Data Engineer/PostgreSQL (M/F) для удаленной работы в финансовом секторе. Вы будете проектировать и развивать PostgreSQL‑базы, писать функции на PL/pgSQL и обеспечивать надежность данных.

Требуется глубоко разбираться в SQL, моделировании данных, настройке ETL и оптимизации запросов. Преимущества: Python, Apache Airflow, Kafka или RabbitMQ; опыт в банковском/финансовом секторе.

Qualificações

• Есть как минимум 5 лет опыта работы с PostgreSQL
• Знание SQL на продвинутом уровне и умение оптимизировать запросы
• Опыт моделирования данных, проектирования relational структур
• Умение работать с PL/pgSQL: процедуры, функции и триггеры
• Опыт работы в Linux и администрирования систем
• Понимание ETL‑процессов и оптимизации обработки данных

Responsabilidades

• Проектирование, разработка и поддержка решений на PostgreSQL
• Разработка процедур, функций и триггеров на PL/pgSQL
• Моделирование данных под бизнес и аналитические требования
• Оптимизация производительности баз данных, настройка индексов и VACUUM/ANALYZE
• Разработка и оптимизация ETL процессов и интеграций
• Работа с большими объёмами данных и обеспечение доступности и безопасности
• Сотрудничество с командами разработки, аналитики и архитектуры
• Участие в автоматизации развёртывания и CI/CD

Conhecimentos

PostgreSQL‑experts

Advanced SQL

Data modeling

ETL optimization

Linux admin

Query tuning

Ferramentas

PL/pgSQL

Stored procedures

Triggers

Partitioning

Materialized views

Indexes

VACUUM/ANALYZE

Descrição da oferta de emprego

Описание

Currently, for our client in the financial sector, we are looking for a candidate for the position of Data Engineer/PostgreSQL (M/F).

Задачи

• Designing, developing, and maintaining PostgreSQL-based database solutions. Creating and developing procedures, functions, and triggers in PL/pgSQL. Designing and developing data models that support the business and analytical needs of the organization. Analyzing database performance, identifying bottlenecks, and implementing optimization measures. Tuning SQL queries, indexes, and data processing processes to ensure high system performance. Designing and optimizing ETL processes and data integrations from various sources. Working with large volumes of data and developing solutions to support Big Data environments. Monitoring database health and ensuring the stability, security, and availability of the environment. Collaborating with development, analytics, and architecture teams on data-driven projects. Participating in the automation of deployment processes and developing CI/CD solutions. Supporting the development of data architecture and implementing best practices related to data management.

Требования

• You have at least 5 years of experience working with PostgreSQL databases. You have a very good knowledge of SQL and can create advanced queries and optimize their performance. You have experience in data modeling, designing relational structures, and normalizing and denormalizing data models. You work confidently with PL/pgSQL, creating stored procedures, functions, and triggers. You can analyze and optimize database performance, including in environments processing large volumes of data. You know PostgreSQL architecture and practically use mechanisms such as table partitioning, materialized views, and various types of indexes (B-Tree, Hash, GIN, GiST, BRIN). You have experience monitoring database performance and managing VACUUM, ANALYZE, and autovacuum processes. You have practical knowledge of ETL integration and data processing optimization. You work in a Linux environment and are comfortable administering and diagnosing systems. You can analyze query execution plans and effectively tune indexes and ETL processes. Будет плюсом: Additional assets include knowledge of Python, Apache Airflow, Kafka, or RabbitMQ, as well as experience in the banking or financial sector

Условия

• 100% remote work. Salary: from PLN 1,000 to PLN 1,100 net per day, depending on experience and competencies. Long-term cooperation. Technical training, certifications, and opportunities to improve your qualifications. Mentoring Competence Center—being part of the CC community from your first day at work is an opportunity to develop your skills, participate in various conferences, and share knowledge and experience with people who face the same challenges every day. A clear career path. Employee benefits package (Multisport, private medical care, life insurance). A friendly working atmosphere, integration events, and team-building meetings. A referral system.