Senior Business Intelligence Architect

Summary

Join IDT, a leading telecommunications company, as a full-time, work-from-home ETL Data Engineer! Based in LATAM, you will contribute to a USA-based client's BI engineering team. This role involves designing, developing, and testing ELT/ETL solutions using tools like Snowflake, Denodo, and Looker. You will collaborate with QA, improve processes, and extract data from various sources. Success requires extensive ETL/ELT experience, proficiency in SQL and Python, and strong analytical skills. This opportunity offers maximum location flexibility.

Requirements

• 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 to support business intelligence and analytics
• Demonstrate experience in utilizing python for data engineering tasks, including transformation, advanced data manipulation, and large-scale data processing
• Have experience in data analysis, root cause analysis and proven problem solving and analytical thinking capabilities
• Have experience designing complex data pipelines extracting data from RDBMS, JSON, API and Flat file sources
• Demonstrate 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
• Have a proven ability to analyze and optimize poorly performing queries and ETL/ELT mappings, providing actionable recommendations for performance tuning
• Have an understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, and experience with Agile methodologies
• Have proficiency in version control systems, with experience in managing code repositories, branching, merging, and collaborating within a distributed development environment
• Have excellent English communication skills
• Have an interest in business operations and a comprehensive understanding of how robust BI systems drive corporate profitability by enabling data-driven decision-making and strategic insights
• Have a BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise

Responsibilities

• 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
• Be willing to explore and learn new technologies and concepts to provide the right kind of solution
• Be target and result oriented with strong end user focus
• Demonstrate effective oral and written communication skills with BI team and user community

Preferred Qualifications

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