SQL Developer (PostgreSQL/EDB, ETL)

Quick Facts

• Role: SQL Developer (B2B)

• Focus: PostgreSQL/EDB, PL/pgSQL/PL/SQL, ETL, query performance

• Collaboration: Remote or office in Rybnik

Description

B2B contract role for an experienced SQL developer to create and optimize complex SQL queries, stored procedures, and functions in PostgreSQL/EDB. You will build and evolve ETL pipelines feeding a data warehouse, automate tasks with Python and Linux scripts, and diagnose data issues. You’ll work closely with data architects, analysts, and the development team.

Responsibilities

• Create complex SQL queries, procedures, and functions in PostgreSQL/EDB

• Optimize SQL query performance

• Build and develop ETL processes for a data warehouse

• Automate tasks using Python and Linux scripts

• Diagnose and resolve data problems

• Collaborate with data architects, analysts, and developers

Requirements

• At least 3 years of experience in SQL development

• Experience with complex queries, procedures, functions, and SQL performance optimization

• Knowledge of PostgreSQL/EDB and PL/pgSQL/PL/SQL

• Experience with data warehouse work and ETL processes

• Proficiency with GIT and practical CI/CD practices

• Knowledge of Python and Linux scripting languages

• Familiarity with JSON and database connection mechanisms (e.g., FDW)

• Strong organization, independence, and responsibility for assigned tasks

• Communication skills and curiosity in troubleshooting

Benefits

• B2B services contract (VAT invoice), monthly billing based on delivered and accepted scope

• Remote work or work from the Rybnik office (ul. Dąbrowskiego 9) based on contractor preference

• Independent planning of tasks and methods based on agreed milestones and deadlines, without fixed working hours

• Work exclusively for the contracting client due to access to sensitive/confidential data