Full-Time ETL Data Expert

• Prepare Data templates based on Source to Target Mapping (STM) document
• Add/remove columns in Kettle scripts using STM/Data Templates
• Run Lookups query and update lookups
• Run Data Quality scripts, format and validate Data Quality report
• Run scripts on loaded staging data and update data load checklist
• Execute internal smoke testing of loaded data in TANGO application
• Assist to create training materials and help documentation
• Perform data transformations, including merging, ordering, aggregation
• Clean and transform data into a form useful for subsequent analysis.
• Integrate information from multiple data sources, solving common transformation problems, and resolve data cleansing and quality issues
• Effectively communicate with managers and project teams regarding data sets and reporting needs

• SQL basics
• Understanding of waterfall methodology
• Willing to learn new technologies
• Proficient in Microsoft Office
• Strong attention to detail
• Strong prioritization skills
• Strong written and verbal communication skills

• Hands-on experience in ETL/Reporting tool
• Excellent analytical and problem-solving skills.
• Manual data analysis using Excel

• Bachelor’s degree in Data Science, Computer Science, Mathematics, statistics or similar quantitative field plus at least 3 years of relevant experience working with data.
• Demonstrated experience in Data Wrangling
• Minimum 3 years of data scripting experience in SQL, Python, R
• Experience with data formatting and storage

• Data-orientated personality.
• Analytical, planning, problem solving, and decision-making skills
• Good scripting practices
• Experience with SQL.
• Ability to learn and implement new techniques and skills
• Excellent written and oral communication skills
• Ability to work effectively in a multi-disciplinary setting.
• Ability to effectively manage multiple concurrent tasks
• Experience with data wrangling and harmonization
• Experience with database design

What is the last date for applying to the job?

Which countries are accepted for this remote job?