Remote Senior ETL Data Engineer

Description:

• This is a full-time work from home opportunity for a star 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 company is listed on the NYSE, employs over 1300 people across 20+ countries, and has revenues exceeding $1.5 billion.
• The role involves performing data analysis, ELT/ETL design, and support functions to deliver on strategic initiatives that 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, extracting data from multiple sources, integrating disparate data into a common data model, and collaborating with Quality Assurance resources to ensure timely product delivery.
• The candidate should be willing to explore and learn new technologies and concepts, be target and result-oriented, and possess 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 for business intelligence and analytics.
• 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, along with hands-on experience in relational database systems and cloud-based database services such as Oracle, MySQL, Amazon RDS, Snowflake, and Amazon Redshift 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 skills working on Unix/Linux/Windows Operating systems, along with experience in Agile methodologies is expected.
• Proficiency in version control systems, with experience in managing code repositories, branching, merging, and collaborating within a distributed development environment is necessary.
• Excellent English communication skills are required.
• An interest in business operations and a comprehensive understanding of how robust BI systems drive corporate profitability through data-driven decision-making and strategic insights is essential.

Benefits:

• The position offers maximum flexibility in choosing a location to work.
• The opportunity to work with a leading telecommunications company that values innovation and strategic impact.
• The role provides a chance to be part of a dynamic BI engineering team and contribute to significant organizational goals.
• Employees will have the opportunity to learn and explore new technologies and concepts in the field of data engineering.
• The company promotes a collaborative work environment that encourages professional growth and development.