Senior ETL Developer in Remote (Ukraine)

We are looking for ETL Developer who will join our customer team. Our Customer is the leading company in the Arts & Crafts industry in the US. As a top art supply company, it provides artists, educators, and students with the tools, assistance, and training needed to grow, innovate, and reach their creative potential. 

The ETL Developer will be responsible for designing, developing, and implementing data integration solutions. The ideal candidate will have experience in data warehousing, ETL development, and maintaining ETL processes and data pipelines.

The role also requires deep expertise in AWS Redshift, strong SQL and Python proficiency, and experience working with cloud-based data warehousing platforms. In addition to technical skills, the candidate should be capable of communicating effectively with business stakeholders, understanding requirements, and driving projects to completion.

What We’re Looking For:

• Bachelor's degree in Computer Science, Information Systems, or related field.


• 5+ years of experience in ETL development and data warehousing.


• Deep AWS Redshift knowledge and experience are required for this position. This includes data population and transformation best practices, orchestration, security, and data governance.  


• Strong knowledge of ETL tools and technologies, such as SSIS, AWS Glue, or Informatica. 


• Proficient in SQL and database technologies, such as Microsoft SQL Server, Oracle, or MySQL.


• Understanding of data modeling, data integration, and data warehousing concepts.


• Proficiency in programming languages such as Python, SQL, or Java is a big plus.


• Working experience and strong knowledge of data warehousing and data modeling concepts.


• Experience working in an Agile development environment is a plus.


• Strong communication abilities are essential for this role, as it involves frequent interactions with the business team and demands a proficient grasp of business discussions, along with the capability to effectively convey concepts in return.


• Excellent problem-solving and analytical skills.


• Upper Intermediate level of English.

• Design, develop, test, and implement data integration solutions using ETL tools and techniques.


• Very strong understanding of Data warehouses, DW design best practices, and DW population. 


• Collaborate with data analysts, data architects, and business stakeholders to understand data requirements and design appropriate solutions. 


• Create and maintain ETL documentation including data mappings, data dictionaries, and ETL workflows.


• Troubleshoot ETL issues and performance-tune ETL jobs as needed.


• Monitor and maintain the ETL system to ensure optimal performance and data accuracy.


• Participate in code reviews, testing, and deployment of ETL jobs.


• Lead Junior ETL Developers on complex projects.