Remote Business Intelligence Engineer

Summary

Join our global team as a Mid-level Business Intelligence Engineer and perform data analysis, ELT/ETL design and support functions to deliver on strategic initiatives. The individual will develop, document, and test ELT/ETL solutions, recommend process improvements, and collaborate with Quality Assurance resources.

Requirements

• 5+ years experience in ELT/ETL design, development and populating data warehouses from heterogeneous OLTP or API sources
• Excellent English communication skills
• Mastery in Business Intelligence and Data warehousing concepts and methodologies
• Extensive experience in data analysis and root cause analysis and proven problem solving and analytical thinking capabilities
• Extensive expertise on Databases, data acquisition, ELT/ETL strategies and tools and technologies using Pentaho/Kettle Data Integration/ Ab Initio ETL tool
• Should have experience designing complex ELT/ETL’s extracting data from RDBMS, JSON, API and Flat file sources
• Strong SQL programming skills, relational database skills with expertise in cloud RDBMS systems like Snowflake, Oracle DB, MySql, Redshift, etc
• Should be able to analyze poorly performing queries ELT/ETL mappings and provide suggestions to tune them
• Understanding of software engineering principles and skills working on Unix/Linux/Windows Operating systems, Agile
• Exposure to Standard support ticket management tools like JIRA / Git

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

Benefits

Work from home opportunity