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. If you’re seeking to make a difference in the world, visit www.icf.com/careers to find your next career. ICF—together for tomorrow.
To support our growth, we’re seeking an ETL/Database Developer who will extract, transform, and load (ETL) processing routines and data feeds to transmit data to and from clients and subcontractors; and create necessary data structures or data models to support data at all stages. The individual will work within a dynamic and fast paced environment to implement these solutions. This position is located at ICF's metro-accessible Fairfax headquarters.
Design and develop ETL code as per requirements specifications and best practice guidelines
Unit testing ETL code to ensure it can be delivered and run in a system testing environment
Participation and contribution in quality assurance reviews of ETL components
Maintain accurate records related to data lineage
Perform tasks related to performance tuning of ETL jobs
Create data structures or data models that support data across all stages of the extract, transform and load (ETL) process
Bachelor's degree in a technical field (e.g., Computer Science, Engineering or related discipline) with 3+ years of experience OR Master's degree in a technical field (e.g., Computer Science, Engineering or related discipline) with 1+ years of experience
2+ years’ experience developing database ETL environments with business intelligence applications such as Talend, Microsoft SQL Server Integration Services (SSIS), Informatica
2+ years’ experience in SQL and procedural programming
Understand ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation
Understand database concepts of referential integrity, indexes and keys and table metadata
Demonstrated experience showing strong critical thinking and problem solving skills paired with a desire to take initiative
Experience with SAS or equivalent tools like R, SPSS
Proficient with data warehouse design and development and big data systems
Proficient with one or more programming languages such as Java or Python
Relevant MS or certification in relational database management system (RDMS)
Experience in reporting and data visualization technologies such as PowerBI, Tableau etc
Knowledge of Big Data integration tools such as Sqoop, Storm, and NIFI, Kafka a plus
Knowledge of DevOps tools like Jenkins/Git to assist development process
Familiarity with agile development process
Excellent listening, written, and oral communication skills
Highly self-motivated and directed with the ability to exercise independent judgment, prioritize and execute tasks
Build and maintain relationships with users to ensure buy-in and adoption of processes and solutions
Team player with the ability to work in a fast-paced environment.
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)
For a listing of other career opportunities at ICF, please visit our Career Center at www.icf.com/careers/
Pay Transparency Statement: For more information, please click here: https://www.dol.gov/ofccp/pdf/pay-transp_formattedESQA508c.pdf
Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email email@example.com 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
Fairfax, VA (VA01)