Be on Alert – Fraudulent Employment Offers. Learn More

Chicago, Illinois, United States of America
JOB #R2201736

Data Engineer- Remote

Data Engineer

Preference for candidates in MST or CST

About ICF International

The ICF International (NASDAQ:ICFI) Commercial Energy Division partners with commercial energy clients to deliver professional services and technology solutions related to energy management and energy efficiency programs. The firm combines passion for its work with industry expertise and innovative analytics to produce compelling results throughout the entire program life cycle, from research and analysis through implementation and improvement. Since 1969, ICF has been serving government at all levels, major corporations, and multilateral institutions. More than 3,500 employees serve these clients worldwide. ICF's Web site is

Job Description:This is a cross functional position with significant responsibility and opportunity to shape the future direction of our team. The selected candidate will work to design, monitor and optimize SQL servers on daily basis. In addition to that, candidate will be required to focus on data development tasks like coding in T-SQL to collect, store, validate and process large datasets.

This position will be part of a small analytical team working on quantitative software products and services so experience working in a product development environment is desired. Successful candidates will be very analytical with a high attention to detail in a quantitative environment to ensure a stable, repeatable, and accurate production data stream. Successful candidates will also enjoy an independent work environment where they can take a high level of ownership of their accomplishments.

Key Responsibilities:

  • Develop reports as well as perform ad hoc data reporting as needed

  • Work with team leads to prioritize business and information needs.

  • Develop and execute T-SQL code to facilitate data movements and ETL processing with a focus on consistency, reliability, and accuracy.

  • Design and code workflows, create database releases, and optimize production data pipelines to ensure data accuracy Perform hands on data research to provide insights and uncover potential data issues

  • Map data feeds and combine them with third party content ensuring consistency

  • Develop and code operational processes to automatically report on data conditions and KPIs during processing

  • Be a part of fast-moving development teams using agile methodologies


  • 5+ years of professional database solution development with Microsoft SQL Server

  • Proven ability within the database performance and query optimization arena.

  • Strong Analytical and reasoning skills that result in clear, robust, and accurate solutions

  • Strong data debugging skills

  • Expertise in Data Analysis, Data Profiling, and SQL Tuning

  • Has deep understanding of data architecture & data modeling best practices, and guidelines for different data and analytic platforms including scrum and agile procedures.

  • Experience developing SQL scripts, data processing processes, and performance tuning quantitative queries

  • Superior organizational and end to end delivery skills in an Agile environment

  • Ability to manage multiple tasks and shifting priorities with proactive communication in mind

  • Ability to maintain strong working relationships with development and business teams based on a proactive communication style

Preferred Skills/Experience:

  • 5+ years of experience working within the full lifecycle SDLC as part of a software product and operations team environment

  • Experience with PowerShell scripting

  • Ability to work in a distributed team environment

  • Experience working on quantitative software products

  • An outstanding academic record with a focused on Energy, Science, Math, and Engineering or similar.

Professional Skills:

  • Excellent listening, interpersonal, written, oral, and phone communication skills

  • Highly self-motivated and self-directed to solve complex technical problems

  • Ability to exercise independent judgment

  • Builds and maintains relationships with stakeholders to ensure buy-in and adoption of technology solutions

  • Self-motivated to continuously improve technical and professional skills

  • Ability to effectively prioritize and execute tasks

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.

We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.

COVID-19 Policy: New or prospective U.S. employees must provide proof of complete vaccination on the date of their commencement of employment. If selected for employment, you will provide proof of your full vaccination status, defined as vaccinated two weeks after receiving the requisite number of doses of a COVID-19 vaccine approved or authorized for emergency use by the FDA.

Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination:  EEO is the law and  Pay Transparency Statement.

Illinois Remote Office (IL99)

Who is ICF?

A global consulting services company with approximately 8,000 people across 75+ countries, but we are not your typical consultants.

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.