ICF Consulting Group, Inc. ETL Specialist- Energy in Fairfax, Virginia
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.
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
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.
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.
Requisition ID: 1700004201