ICF Consulting Group, Inc. Data Engineer in Jefferson City, Missouri
ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place.
ICF is hiring a Data Engineer in the Washington, DC area. This work will be performed REMOTE until offices re-open.
As a Data Engineer, you will perform end to end data analysis for a program in pandemic response for Federal healthcare. You will also organize, perform data visualization and generate reports.
What you’ll be doing:
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.
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
Develop 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
What you must have:
Bachelor’s degree (e.g., Computer Science, Engineering, or related discipline)
2-5 years’ experience developing database ETL environments with business intelligence applications such as Talend, Informatica, SAS
2-5 years’ experience in SQL and procedural programming
1-2 years of experience working with databases and BI tools such as Tableau, PowerBI
1+ years’ experience with services AWS Glue, Lambda, Microsoft Azure Data Factory, Google Cloud Data Flow
US Citizen or Permanent Lawful Resident (Green Card Holder) preferred. Employment must be compliant with eligibility for Public Trust Clearance due to Government Contract.
What we’d like you to know:
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
Proficient with data warehouse design and development and big data systems
Proficient with one or more programming languages such as Java or Python
Knowledge of Big Data integration tools such as Storm, and Spark, AWS Kinesis, Kafka a plus
Experience with DevOps tools like Jenkins/Git to assist development process
Experience with agile development process
Technologies you’ll use in this role:
SQL, BI, Talend, R, Python, SAS, Tableau, PowerBI, Postgres, SQL Server
Spark, AWS Glue, S3, AWS Kinesis, Kafka
AWS, Azure, Google Cloud Platform
Why you’ll love working here:
Comprehensive health benefits
Generous vacation and retirement plans
Employee support program
Participation in charity initiatives
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). For more information, please read our EEO & AA policy (https://www.icf.com/legal/equal-employment-opportunity) .
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 (https://www.eeoc.gov/sites/default/files/migrated_files/employers/poster_screen_reader_optimized.pdf) and Pay Transparency Statement (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_English_unformattedESQA508c.pdf) .
Virginia Remote Office (VA99)Need help? We're here:ICFCareerCenter@icf.com
ICF (NASDAQ:ICFI) is a global consulting services company with over 7,000 full and part-time employees, 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.