Be on Alert – Fraudulent Employment Offers. Learn More

New Delhi, Delhi, India
JOB #R2104869

ETL Developer

We’re looking for a motivated ETL Developer that loves wrangling data.  You’ll be independently designing, implementing and maintaining custom databases and analytic and reporting solutions from start to finish.  And you’ll have oodles of data to access.  In fact, you’ll be an integral part of the team helping to ensure data integrity is always maintained and resolving discrepancies as they arise.  As a demonstrated self-starter, you’ll own business processes end-to-end and will lead the identification and implementation of best practices.  

What You’ll Be Doing Initially:

  • Cleaning and updating existing databases, with a particular focus on dealing with outliers

  • Extracting, importing and exporting data into/from/with multiple formats including Excel

  • Verifying data quality, developing and running programs to check for errors and generating error reports.

  • Establishing routines and procedures for ensuring databases are regularly updated and maintained

  • Maintaining data integrity across a wide variety of databases and platforms

What You’ll be Doing In a Year’s Time:

  • Gathering and or clarifying data and reporting requirements from business owners

  • Leading or otherwise assisting the larger team’s efforts to define and implement data best practices that improve processes and outputs

  • Designing and implementing centralized databases capturing data from multiple sources and formats

  • Identifying opportunities to streamline and improve our data collection and reporting processes

  • Working with our data scientists and analysts to develop custom reports and data visualization products to capture information from the databases

Basic Qualifications: 

  • Bachelor's degree or equivalent experience in a technical field (e.g., Computer Science, Engineering or related discipline)

  • 2+ years of experience working with databases and BI tools such as Microsoft SQL Server Reporting Services (including its ad hoc reporting tool) 

  • Understand ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation

  • Ability to exercise independent judgment while effectively prioritizing and executing tasks while under pressure 

  • Experience handling large messy datasets

Preferred Skills/Experience:

  • Experience with data linking / advanced data management, combining data from different sources

  • Experience in data organisation, cleaning, treating, etc., a knowledge of version control and reproducibility.

  • 2+ years of experience with one or more statistical software and database management software packages (e.g. STATA, R, Python and Microsoft Access, VBA)

  • Ability to define, document, and lead implementation of business processes and software requirements for technology initiatives 

  • Understand database concepts of referential integrity, indexes and keys and table metadata

  • Experience with data visualization technologies, particularly PowerBI and Alteryx, a plus

  • Experience with C# and ASP.NET a plus

  • Team player with the ability to work in a fast-paced environment

  • Willing to learn from others and develop new skills

Working at ICF

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth.

New Delhi, India (II77)

FILE UNDER
Web Development

Who is ICF?

A global consulting services company with +7,000 people across +70 countries, but we are not your typical consultants.
LEARN MORE ABOUT ICF

More jobs you might like

Jan 5, 2022
Multiple locations
Jan 3, 2022
Multiple locations
Dec 1, 2021
Fairfax, Virginia, United States of America
Nov 9, 2021
Multiple locations
Oct 27, 2021
Baltimore, Maryland, United States of America
See All Jobs

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.