Remote ETL Data Architect - LATAM

Description:

• This is a full-time work from home opportunity for an ETL Data Engineer/Architect from LATAM.
• IDT Corporation is an American telecommunications company founded in 1990 and headquartered in New Jersey, recognized as an industry leader in prepaid communication and payment services.
• The role involves performing data analysis, ELT/ETL design, and support functions to deliver on strategic initiatives to meet organizational goals.
• The individual will develop, document, and test ELT/ETL solutions using industry-standard tools such as Snowflake, Denodo Data Virtualization, and Looker.
• Responsibilities include recommending process improvements to enhance efficiency and reliability in ELT/ETL development, extracting data from multiple sources, and integrating disparate data into a common data model.
• The role requires collaboration with Quality Assurance resources to debug ELT/ETL development and ensure timely product delivery.
• Candidates should be willing to explore and learn new technologies and concepts to provide effective solutions.
• The position emphasizes a target and result-oriented approach with a strong end-user focus and effective communication skills with the BI team and user community.

Requirements:

• Candidates must have 10+ years of experience in ETL/ELT design and development, integrating data from heterogeneous OLTP systems and API solutions, and building scalable data warehouse solutions.
• Demonstrated experience in utilizing Python for data engineering tasks, including transformation, advanced data manipulation, and large-scale data processing is required.
• Experience in data analysis, root cause analysis, and proven problem-solving and analytical thinking capabilities are essential.
• Candidates should have experience designing complex data pipelines that extract data from RDBMS, JSON, API, and flat file sources.
• Demonstrated expertise in SQL and PLSQL programming, with advanced mastery in Business Intelligence and data warehouse methodologies is necessary.
• Proven ability to analyze and optimize poorly performing queries and ETL/ELT mappings, providing actionable recommendations for performance tuning is required.
• Understanding of software engineering principles and experience working on Unix/Linux/Windows operating systems, along with Agile methodologies is essential.
• Proficiency in version control systems and experience in managing code repositories, branching, merging, and collaborating within a distributed development environment is required.
• Excellent English communication skills are mandatory.
• An interest in business operations and a comprehensive understanding of how robust BI systems drive corporate profitability through data-driven decision-making is necessary.

Benefits:

• The position offers maximum flexibility in choosing a location to work.
• Candidates will have the opportunity to work with a leading telecommunications company that has a significant global presence.
• The role provides a chance to make a direct impact within the organization and contribute to strategic initiatives.
• Employees will be part of a dynamic team that encourages learning and exploration of new technologies.
• The company values a target-oriented approach, fostering a strong end-user focus and effective communication within the team.