Be on Alert – Fraudulent Employment Offers. Learn More

Fairfax, Virginia, United States of America
JOB #R2104529

Senior Data Engineer

ICF is seeking a highly motivated Senior Data Engineer to support digital solutions for a variety of Federal clients, including the Department of Labor.  The Senior Data Engineer will support our projects by collaborating and working with a cross-functional team to deliver quality, innovative, and highly scalable applications to end clients.   The ideal candidate will have prior experience working with cross-disciplinary teams.

What you’ll be doing:

  • Lead and develop data engineering design and build efforts for our client initiative, working as part of an extended system development team on project execution

  • Develop extract, transform, and load (ETL) processing routines and data engineering pipelines, creating necessary data structures and data models to support data at all stages

  • Perform extensive data profiling and analysis based on client data

  • Work with UI, UX and business analysis team members and the client to define data and reporting requirements

  • Design and implement custom data analytic and BI/reporting products, custom reports, and data visualization products

What you must have:

  • Bachelor’s degree (e.g., Computer Science, Engineering or related discipline)

  • 8+ years of experience in SQL

  • 8+ year of experience with procedural, functional, and object-oriented programming

  • 4+ years of experience developing ETL and data engineering pipelines

  • 4+ years of experience with database, analytics, and compute services such as AWS Glue, Redshift/Postgres/Snowflake, Lambda, etc

  • 4+ years of experience with data lake, data warehouse/datamart design and development

  • 3+ years of experience working with BI tools such as Tableau, PowerBI or AWS Quicksight

  • 3+ years of development experience in a DevSecOps environment, with programming languages such as Java or Python

What we’d like you to have:

  • 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

  • Knowledge of Big Data integration tools such as Spark, AWS Kinesis, and Kafka

  • Experience building CI/CD pipelines with tools such as Jenkins and CodeBuild

  • Experience with containerization platforms including Docker

  • Experience with Agile development process

  • Experience migrating and implementing cloud data warehouses – Snowflake, Redshift

Technologies you’ll use:

SQL, AWS Glue, Redshift/Postgres, Lambda, Tableau/ PowerBI, R/Python, Agile, CI/CD

Why you’ll love working here:

  • Generous vacation and retirement plans

  • Flexible work location

  • Diverse workforce that values equality and inclusion

  • Ongoing training and development opportunities

  • Participation in charity initiatives

  • Employee support program

  • Comprehensive health benefits

#EET

#INDEED

#LI-CC1

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.

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 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.

Virginia Remote Office (VA99)

FILE UNDER
Data Analytics

Who is ICF?

A global consulting services company with +7,000 people across +70 countries, but we are not your typical consultants.
LEARN MORE ABOUT ICF

More jobs you might like

Nov 12, 2021
Jefferson City, Missouri, United States of America
Nov 3, 2021
Fairfax, Virginia, United States of America
Nov 3, 2021
Fairfax, Virginia, United States of America
Nov 1, 2021
Fairfax, Virginia, United States of America
Oct 21, 2021
Multiple locations
See All Jobs

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.