Be on Alert – Fraudulent Employment Offers. Learn More

Fairfax, Virginia, United States of America
JOB #R1903301

Data Engineer

ICF’s  Analytics and Emerging Technology team is comprised of experienced professionals with the skills required to unlock the power of governed data discovery.  Our staff provides deep technical and business support for data acquisition, data analysis/data science, and interactive data visualizations.  With those skills, our team enables our clients to extract greater value from raw datasets that are varied in their composition, are growing at ever increasing rates, and can no longer be properly supported through legacy business intelligence and data visualization platforms.  At its core, the Analytics and Emerging Technology team helps our clients visualize their data in new and more informative ways than ever before by leveraging the latest in open source and commercial off the shelf technology stacks.

Job Description:

To support our growth, we’re seeking a Data Engineer who will extract, transform, and load (ETL) processing routines and data feeds to transmit data to and from clients and subcontractors; create necessary data structures or data models to support data at all stages; and design and implement custom data analytic and BI/reporting products.  The individual will work within a dynamic and fast-paced environment to implement these solutions.

Key Responsibilities:

  • Perform extensive data profiling and analysis based on the client’s data
  • Work with UI teams and/or client to define BI and reporting requirements
  • Developer custom reports and data visualization products
  • Support project delivery on  Data Warehouse/BI projects for external and internal clients, including partnering with ICF subject matter experts on project execution

Basic Qualifications:

  • Must be a US Citizen
  • Bachelor’s degree (e.g., Computer Science, Engineering or related discipline)
  • 4+ years’ experience developing database ETL environments with business intelligence applications such as Talend, Microsoft SQL Server Integration Services (SSIS), Informatica
  • 4+ 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
  • 1+ years of experience working with databases and BI tools such as Microsoft SQL Server Reporting Services (including its ad hoc reporting tool), OBIEE, Tableau, PowerBI 
  • Demonstrated experience showing strong critical thinking and problem solving skills paired with a desire to take initiative

Preferred Skills/Experience:

  • Ability to obtain a Public Trust Clearance
  • 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)
  • 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
  • Familiarity with products/services from cloud computing service providers like Amazon Web Services, Microsoft Azure Cloud, or Google Cloud Platform.

Professional Skills:

  • Excellent listening, written, and oral communication skills
  • Highly self-motivated and directed
  • Ability to exercise independent judgment while effectively prioritizing and executing tasks while under pressure
  • Builds and maintains 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
  • Superior interpersonal skills including courtesy, professionalism, and a cooperative attitude

ICF (NASDAQ:ICFI) is a global consulting services company with over 5,000 specialized experts, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.

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

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 icfcareercenter@icf.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.

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.

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

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 icfcareercenter@icf.comand 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)

Who is ICF?

A consulting services company of over 5,000 experts across 67 countries, but not your typical consultants
LEARN MORE ABOUT ICF

More jobs you might like

Sep 13, 2019
Aberdeen, Maryland, United States of America
Sep 9, 2019
Austin, Texas, United States of America
Sep 5, 2019
Sacramento, California, United States of America
Sep 5, 2019
Multiple locations
Sep 4, 2019
Minneapolis, Minnesota, United States of America
See All Jobs