ICF Consulting Group, Inc. ETL Specialist- Energy in Fairfax, Virginia


ETL Specialist

Fairfax, VA

Job Description:

Our team is growing and wehave animmediate need for an ETL Specialist who will develop and maintain automated ETL and ELT processing routines to facilitate the sharing of data to and from ICF, its clients and its subcontractors. There will also be the need to provide reports for internal and externalenergy sectorclients on this data. ETL processes will be developed in Microsoft SQL Server Integration Services (SSIS) 2016 and reports will be developed using MicrosoftSQL Server Reporting Services (SSRS) 2016. The individual will work within a dynamic and fast paced environment, and be able to apply critical thinking skills to implement these solutions.

You may be required to participate in periodic drug testing and background checks.

Key Responsibilities:

  • Develop SSIS projects to implement ETL including, transmission, encryption, and archiving of files received and generated

  • Design, develop, and maintain database tables, stored procedures, and supporting objects

  • Unit test to ensure the ETL code delivered is running and conforms to specifications and design guidelines

  • Document deployment procedures

  • Provide support to Business Analyst(s) in gathering and/or clarifying data and requirements from subject matter experts

  • Develop SQL queries and support ad hoc requests for data


BS/BA in a technical field: Computer Science, Engineering or IT related discipline

4 years experience developing database ETL environments with business intelligence applications

2 years experience with Microsoft SSIS version 2005 or later

2 years experience writing stored T-SQL, procedures, functions, and SQL queries

Additional Preferred Skills/Experience:

Experience loading and extracting XML and or JSON data to/from databases

Experience developing reports using Microsoft SQL Server Reporting Services (SSRS) 2008 or later

Experience developing in .NET

Experience with Tableau development and or server administration

Experience implementing data warehouses

Professional Skills:

Excellent listening, interpersonal, written, and oral communication skills

Highly self motivated and directed

Able to exercise independent judgment

Builds and maintains relationships with users to ensure adoption and buy-in of ETL solutions

Ability to effectively prioritize and execute tasks while under pressure

ICF offers an excellent benefits package, an award winning talent development program, and fosters a highly skilled, energized and empowered workforce.

ICF is an equal opportunity employer that values diversity at all levels. (EOE Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity)

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. ICFtogether for tomorrow.

About ICF

ICF (NASDAQ:ICFI) is a global consulting and technology services provider with more than 5,000 professionals focused on making big things possible for our clients. We are business analysts, policy specialists, technologists, researchers, digital strategists, social scientists and creatives. Since 1969, government and commercial clients have worked with ICF to overcome their toughest challenges on issues that matter profoundly to their success. Come engage with us at icf.com.

Location: Virginia-Fairfax

Requisition ID: 1700004201