Be on Alert – Fraudulent Employment Offers. Learn More
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
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
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)