ETL Developer, Python, PostgreSQL

• Design and implement Python components for ETL processes
• Migrate ETL pipelines from IBM Datastage and Oracle to Python and PostgreSQL
• Extract data from various sources, transform it according to business rules, and load it into PostgreSQL databases
• Collaborate with data architects and stakeholders to understand data requirements
• Model data flows and define transformation logic
• Implement SQL queries, stored procedures, and functions in PostgreSQL
• Optimize ETL processes for performance, scalability, and resource usage
• Perform query tuning in PostgreSQL
• Build and maintain data validation and quality checks, including automated tests, reconciliation scripts, and alerting for data anomalies
• Monitor ETL jobs and database health
• Diagnose failures and performance issues and implement fixes or improvements
• Document ETL processes, data dictionaries, lineage, and operational runbooks
• Troubleshoot cross-system data issues
• Participate in incident response and provide root cause analysis and remediation plans
• Participate in code reviews, mentor junior developers, and improve team standards and best practices
• Contribute to technology refresh, legacy-system modernization, and cloud and open-source platform migration initiatives

• Good knowledge and several years of practical experience in Python development
• Solid skills in Postgres and SQL
• ETL experience is desirable
• Strong analytical skills
• A solution-oriented mindset
• Ability to work independently
• Experience in conceptual work
• Excellent understanding of data
• Independent and structured working style
• Very good command of English, both spoken and written
• Experience with IBM Datastage and Oracle
• Experience with data modeling, transformation logic, SQL queries, stored procedures, and PostgreSQL functions
• Experience with query tuning and ETL process optimization
• Experience building data validation and quality checks
• Experience monitoring ETL jobs and database health
• Experience documenting ETL processes, data dictionaries, lineage, and operational runbooks
• Experience troubleshooting cross-system data issues and participating in incident response
• Ability to participate in code reviews and mentor junior developers

• Flexible working hours
• Remote work options (Poland only)
• Open and cooperative corporate culture and a trusting working atmosphere
• Flat Hierarchies and Short Decision Paths
• Individual training opportunities
• Interesting technical challenges
• Social benefits