We are looking for a ETL Developer to join our team and work on data integration for a Pharmaceutical Marketing company.
You will develop and support ETL processes that run in Docker containers. Your daily work will primarily involve writing complex SQL queries and views, performing data transformations, and ensuring accurate and timely delivery of data by monitoring notifications and logs in AWS CloudWatch. Work also involves scripting in Bash and Python for automation, SFTP data transfers, and connecting to APIs when required.
We work as a team, care about code and data quality, and like people who want to learn and improve.
Our teams have daily standups and direct communication with a client on a daily basis. The platform processes sensitive data, so development is manual, controlled, and accuracy-driven rather than highly automated.
Requirements * 3+ years of experience working with ETL processes or data pipelines * Strong SQL skills: creating and debugging complex queries, aggregations, and validation logic * Experience with a relational database (preferably PostgreSQL) * Basic understanding of data warehouse concepts (facts, dimensions, SCD, star schema) * Experience building ETL pipelines * Python knowledge (Pandas, boto3, paramiko), connecting to SFTPs, APIs, and pulling/pushing data * Understanding of clean code and good coding practices * Experience using Git and pipelines * Solid Bash scripting skills for automation and troubleshooting * Experience with Docker (images, containers, passing data between containers) * Basic knowledge of AWS, including: * Running containers in ECS * Mounting EFS volumes * Viewing logs in CloudWatch * English level B2 (can communicate and understand documentation) * Willingness to learn and improve skills * Interest in software development and data work
Nice to have * Experience with Amazon Redshift, Snowflake, Postgres * Experience using AWS CLI * Knowledge of AWS services such as: * ECR * ECS * EventBridge * CloudWatch * Lambda * Step Functions * Experience working with REST APIs * Knowledge of NoSQL databases * Experience with CI/CD tools
We offer: * Possibility to propose solutions on a project * Dynamic and challenging tasks * Team of professionals * Competitive salary * Low bureaucracy * Continuous self-improvement * Long-term employment with paid vacation and other social benefits * Bunch of perks
This vacancy is exclusively for Ukrainian developers!