
ETL Developer, Python, PostgreSQL
Posted Nov 12

Posted Nov 12
This is a fully remote position, open to applicants in Poland.
β’ Create and implement Python components for ETL workflows.
β’ Transition ETL pipelines from IBM Datastage and Oracle to Python.
β’ Extract data from diverse sources, apply transformations as per business rules, and load it into PostgreSQL databases.
β’ Collaborate with data architects and stakeholders to comprehend data needs, model data streams, and establish transformation logic.
β’ Develop SQL queries, stored procedures, and functions within PostgreSQL.
β’ Enhance ETL processes for optimal performance, scalability, and resource efficiency, including PostgreSQL query optimization.
β’ Construct and uphold data validation and quality assurance checks, including automated testing, reconciliation scripts, and anomaly detection.
β’ Oversee ETL jobs and database performance, identify failures or performance challenges, and execute solutions.
β’ Document ETL workflows, data dictionaries, lineage, and operational manuals.
β’ Resolve cross-system data discrepancies and engage in incident management.
β’ Offer root cause analysis and remediation strategies.
β’ Engage in code reviews, mentor junior developers, and refine team standards and best practices.
β’ Contribute to application modernization, cloud migration, and the transition from Oracle to PostgreSQL initiatives.
β’ Strong knowledge and multiple years of hands-on experience in Python development.
β’ Proficient skills in PostgreSQL and SQL.
β’ Experience with ETL processes is a plus.
β’ Strong analytical capabilities.
β’ Solution-focused mindset.
β’ Ability to work autonomously.
β’ Experience in conceptual development.
β’ Excellent understanding of data principles.
β’ Independent and methodical work approach.
β’ Proficient command of English, both spoken and written.
β’ Flexible working hours.
β’ Remote work options (available only in Poland).
β’ An open and collaborative corporate culture with a trusting work environment.
β’ Flat hierarchies and quick decision-making processes.
β’ Individual training opportunities.
β’ Engaging technical challenges.
β’ Social benefits.
Modern Health
Banner Health
Centene Corporation
Tebra
Get handpicked remote jobs straight to your inbox weekly.