Data Engineer (REMOTE)

Company: ICF
Location: Montgomery
Posted on: January 24, 2023

Job Description:

ICF is hiring for two new Data Engineer professionals in the Washington DC Metro Area! While we are under restrictions due to the pandemic, this role will be remote. While we hope to offer long term remote options to successful candidates for this role, there will be a need for onsite client meetings and onsite presence in the DC Metro area after restrictions are lifted.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 executionWhat you must have:+ Bachelor's degree (e.g., Computer Science, Engineering, or related discipline)+ 2+ years' experience developing database ETL environments with business intelligence applications such as Talend, Informatica, SAS+ 2+ years' experience in SQL and procedural programming+ 1+ 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+ Employment must be compliant with eligibility for Public Trust Clearance due to Government Contract.+ Candidate must reside in the US, be authorized to work in the US, and work must be performed in the USWhat 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 processTechnologies you'll use in this role:+ SQL, BI, Talend, Python, SAS, Tableau, PowerBI, Postgres, SQL Server+ Spark, AWS Glue, S3, AWS Kinesis, Kafka+ Jenkins/Git, Cloudformation+ Agile Scrum/Kanban+ AWS, Azure, Google Cloud PlatformWhy you'll love working here:+ Comprehensive health benefits+ Generous vacation and retirement plans+ Employee support program+ Participation in charity initiatives#EET#DMDDEWorking at ICFWorking 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.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 (https://www.icf.com/legal/equal-employment-opportunity) . 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 (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) . Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position is $74,500.00 - $126,650.00DC Remote Office (DC99)Need help? We're here:ICFCareerCenter@icf.comAbout ICFICF (NASDAQ:ICFI) is a global consulting and technology services company with approximately 8,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.

Keywords: ICF, Montgomery , Data Engineer (REMOTE), Other , Montgomery, Alabama