ETL Data Architect @Idt

[Hiring] ETL Data Architect @Idt

Apr 01, 2025 - Idt is hiring a remote ETL Data Architect. đź’¸ Salary: unspecified. đź“ŤLocation: Latin America (LATAM).

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

This role involves performing data analysis, ELT/ETL design and support functions to deliver on strategic initiatives to meet organizational goals.

  • Develop, document, and test ELT/ETL solutions using industry standard tools (Snowflake, Denodo Data Virtualization, Looker).
  • Recommend process improvements to increase efficiency and reliability in ELT/ETL development.
  • Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ELT/ETL processes.
  • Collaborate with Quality Assurance resources to debug ELT/ETL development and ensure the timely delivery of products.
  • Should be willing to explore and learn new technologies and concepts to provide the right kind of solution.
  • Target and result oriented with strong end user focus.
  • Effective oral and written communication skills with BI team and user community.

Qualifications

  • 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 to support business intelligence and analytics.
  • Demonstrated experience in utilizing Python for data engineering tasks, including transformation, advanced data manipulation, and large-scale data processing.
  • Experience in data analysis, root cause analysis and proven problem solving and analytical thinking capabilities.
  • Experience designing complex data pipelines extracting 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 one or more relational database systems and cloud-based database services such as Oracle, MySQL, Amazon RDS, Snowflake, Amazon Redshift, etc.
  • Proven ability to analyze and optimize poorly performing queries and ETL/ELT mappings, providing actionable recommendations for performance tuning.
  • Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, and experience with Agile methodologies.
  • Proficiency in version control systems, with experience in managing code repositories, branching, merging, and collaborating within a distributed development environment.
  • Excellent English communication skills.
  • Interest in business operations and comprehensive understanding of how robust BI systems drive corporate profitability by enabling data-driven decision-making and strategic insights.

Requirements

  • Experience in developing ETL/ELT processes within Snowflake and implementing complex data transformations using built-in functions and SQL capabilities.
  • Experience using Pentaho Data Integration (Kettle) / Ab Initio ETL tools for designing, developing, and optimizing data integration workflows.
  • Experience designing and implementing cloud-based ETL solutions using Azure Data Factory, DBT, AWS Glue, Lambda and open-source tools.
  • Experience with reporting/visualization tools (e.g., Looker) and job scheduler software.
  • Experience in Telecom, eCommerce, International Mobile Top-up.

Education

  • BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise.

Preferred Certification

  • AWS Solution Architect
  • AWS Cloud Data Engineer
  • Snowflake SnowPro Core

Similar Remote Jobs

More jobs at Idt

More Data Analysis jobs

More jobs in Latin America (LATAM)

Before You Apply
️
đź“Ť Be aware of the location restriction for this remote position: Latin America (LATAM)
‼ Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
ETL Data Architect @Idt
Data Analysis
Salary đź’¸ unspecified
Remote Location
Latin America (LATAM)
Job Type full-time
Posted Apr 01, 2025
Apply for this position Unlock 54,823 Remote Jobs
️
đź“Ť Be aware of the location restriction for this remote position: Latin America (LATAM)
‼ Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
ETL Data Architect Apply for this position Unlock 54,823 Remote Jobs
Ă—
  • Unlock 54,823 hidden remote jobs.
  • Your shortcut to remote work. Apply before everyone else.
  • Click and apply. No middlemen, no hassle.

We’re not like the other sites. Come see why!

50% off in April 2025
  • Single payment
  • Lifetime access
  • Filter by location/skills/salary…
  • Create custom email alerts
  • Private Slack Community