ICF
Data Engineer
ICF is a rapidly growing, entrepreneurial, multi-faceted consulting company, seeking a Data Engineer. This resource will help bring new data insights to a government agency committed to improving child welfare. The ICF team performs custom software development, analytics, and maintenance on a suite of web-based applications, and works closely with clients and other contractors to ensure the performance and reliability of public-facing, mission-critical applications. Based on your experiences and interests, we may ask you as a technology professional to support growth-related activities, including (but not limited to) RFI, RFP, prototypes, and oral presentations. Team members are also expected to uphold and maintain appropriate certifications necessary for their practice expertise. Job Location: This is a fully remote position; however, the role is tied to the Washington, DC Metro area due to team requirements. Occasional in-person meetings may be required. An in-person interview may be required and candidates must reside within 50 miles of the Washington, DC Metro Area to be considered. What you'll be doing: Help build, and optimize a AWS-based data lake to support AI/ML initiatives and advance analytics Design and implement scalable data ingestion pipelines for both batch and real-time data from diverse structured and unstructured sources Perform extensive data profiling, transformation and enrichment to prepare clean, ML ready datasets for data scientists and analysts. Develop custom reports and data visualizations to support analytics, decision-making across business and technical teams Collaborate with data scientists and business teams to deliver curated datasets and reporting needs for ML and analytics. Support project delivery on Data lake, 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) 6-8 years' experience in Data engineering with strong background in pipeline development and data integration. 3+ years of hands-on experience with AWS data services, including: Amazon Glue, Lambda, S3, StepFunctions and Athena; familiarity with Redshift and Lake Formation is a plus. 6+ years of experience in SQL and programming, preferably in Python. Experience with BI Tools like Tableau, PowerBI or Amazon QuickSight. Experience with cloud integration tools such as Talend, Informatica Excellent oral communications, thought leadership and formal presentation skills US Citizen or Permanent Lawful Resident (Green Card Holder). Must be able to obtain and maintain a Public Trust MUST RESIDE IN THE United States (U.S.) and the work MUST BE PERFORMED in the United States (U.S.), as this work is for a federal contract and laws do apply What we'd like you to have: Understand ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation Familiarity with modern data lake architecture and data governance best practices. Demonstrated experience showing strong critical thinking and problem solving skills paired with a desire to take initiative Experience working with big data processing frameworks such as Apache Spark, and streaming platforms like Kafka or AWS Kinesis. AWS certification (Data Analytics, Developer, or Solutions Architect) is a plus. Experience with event-driven architectures and real-time data pipelines. Experience with DevOps tools like Jenkins/Git to assist development process Experience working in agile development environments 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 based on full-time employment is $89,203.00 - $151,646.00 Nationwide Remote Office (US99)
ICF is a rapidly growing, entrepreneurial, multi-faceted consulting company, seeking a Data Engineer. This resource will help bring new data insights to a government agency committed to improving child welfare. The ICF team performs custom software development, analytics, and maintenance on a suite of web-based applications, and works closely with clients and other contractors to ensure the performance and reliability of public-facing, mission-critical applications. Based on your experiences and interests, we may ask you as a technology professional to support growth-related activities, including (but not limited to) RFI, RFP, prototypes, and oral presentations. Team members are also expected to uphold and maintain appropriate certifications necessary for their practice expertise. Job Location: This is a fully remote position; however, the role is tied to the Washington, DC Metro area due to team requirements. Occasional in-person meetings may be required. An in-person interview may be required and candidates must reside within 50 miles of the Washington, DC Metro Area to be considered. What you'll be doing: Help build, and optimize a AWS-based data lake to support AI/ML initiatives and advance analytics Design and implement scalable data ingestion pipelines for both batch and real-time data from diverse structured and unstructured sources Perform extensive data profiling, transformation and enrichment to prepare clean, ML ready datasets for data scientists and analysts. Develop custom reports and data visualizations to support analytics, decision-making across business and technical teams Collaborate with data scientists and business teams to deliver curated datasets and reporting needs for ML and analytics. Support project delivery on Data lake, 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) 6-8 years' experience in Data engineering with strong background in pipeline development and data integration. 3+ years of hands-on experience with AWS data services, including: Amazon Glue, Lambda, S3, StepFunctions and Athena; familiarity with Redshift and Lake Formation is a plus. 6+ years of experience in SQL and programming, preferably in Python. Experience with BI Tools like Tableau, PowerBI or Amazon QuickSight. Experience with cloud integration tools such as Talend, Informatica Excellent oral communications, thought leadership and formal presentation skills US Citizen or Permanent Lawful Resident (Green Card Holder). Must be able to obtain and maintain a Public Trust MUST RESIDE IN THE United States (U.S.) and the work MUST BE PERFORMED in the United States (U.S.), as this work is for a federal contract and laws do apply What we'd like you to have: Understand ETL concepts of data flow, data enrichment, data consolidation, change data capture and transformation Familiarity with modern data lake architecture and data governance best practices. Demonstrated experience showing strong critical thinking and problem solving skills paired with a desire to take initiative Experience working with big data processing frameworks such as Apache Spark, and streaming platforms like Kafka or AWS Kinesis. AWS certification (Data Analytics, Developer, or Solutions Architect) is a plus. Experience with event-driven architectures and real-time data pipelines. Experience with DevOps tools like Jenkins/Git to assist development process Experience working in agile development environments 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 based on full-time employment is $89,203.00 - $151,646.00 Nationwide Remote Office (US99)