This is a full-time work from home opportunity for a star BI data engineer from India.
IDT (www.idt.net) is a US communications and financial services company founded in 1990 and headquartered in New Jersey, US. Today it is an industry leader in prepaid communication and payment services and one of the world’s largest international voice carriers. We are listed on the NYSE, employ over 1500 people across 20+ countries, and have revenues in excess of $1.5 billion.
We are looking for a Mid-level Business Intelligence Engineer to join our global team. If you are highly intelligent, motivated, ambitious, ready to learn and make a direct impact, this is your opportunity! The individual in this role will perform data analysis, ELT/ETL design and support functions to deliver on strategic initiatives to meet organizational goals across many lines of business.
* The interview process will be conducted in English.
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.
- 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.
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.
- Interest in business and the understanding of how strong BI systems drive corporate profitability.
Pluses
- Experience with cloud data warehousing (Snowflake)
- Experience with the Ab Initio ETL tool is desirable.
- Experience with AWS cloud is also a plus.
- Experience with reporting/visualization tools a plus (e.g., Looker) and job scheduler software
- Experience in Telecom, eCommerce, International Mobile Top-up
- Experience with scripting languages like Python, Shell, JavaScript.
- Education: BS/MS in computer science, Information Systems or a related technical field or equivalent industry expertise.
Please attach CV in English.
The interview process will be conducted in English.
Only accepting applicants from INDIA
