Senior Data Engineer (Remote)

**This role can be remote, sitting anywhere within the US. Candidates will work standard Eastern Time business hours. We prefer candidates be in the Metro DMV area due to quarterly meetings.** 

Our Public Sector Group (PSG) is growing, and we are looking for a talented, highly motivated Senior Data Engineer to join ICF’s Digital Modernization Division. ICF is seeking a highly motivated Senior Data Engineer to support digital solutions for various 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. 

You are a team player and can embrace ambiguity to translate client requirements using an agile delivery framework to deliver technical solutions that achieve mission value and measurable outcomes. You are a strategic problem-solver that has a willingness to learn and grow with our team and be part of our client’s digital transformation journey. 

At ICF, we implement smart solutions to drive digital transformation at scale and speed, we are relentlessly making sure it pays off for our clients, and we are committed to helping them achieve mission outcomes. Join our community of mission-driven project managers, data experts, strategists, and technologists to build agile solutions that meet our clients changing needs. 

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 models to support data at all stages, and design and implement custom data analytics and BI/reporting products. 

• Establish data governance models and contribute to strategies for enterprise data management 

• Lead discussions with the clients to understand their requirements and challenges and work with team members to design sustainable solutions 

• Perform extensive data profiling and analysis based on the client’s data 

• Work with software development teams and clients to define 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) 

• 8 or more years of experience developing database ETL environments with business intelligence applications such as Talend and Informatica 

• 8 or more years of consulting experience advising client leadership on enterprise data management strategy and associated best practices 

• 8 or more years of experience in SQL and procedural programming 

• 5 or more years of experience with Data Governance 

• 5 or more years of experience with Azure Cloud Engineering services 

• Employment must be compliant with eligibility for Public Trust Clearance due to Government Contract 

• Candidate must reside in the US and be a US Citizen or Green Card holder 

What we’d like you to have: 

• Experience architecting, designing, and implementing data solutions using Azure and Databricks 

• Ability to optimize data processing workflows, improve query performance, and troubleshoot performance bottlenecks 

• 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 

• Advanced programming skills in languages such as Python, or Java for developing custom data processing pipelines and implementing complex data transformations 

• Proficiency in big data technologies such as Apache Spark, Hadoop, and related frameworks for large-scale data processing and analytics 

• Knowledge of Big Data integration tools such as Storm, and Spark, AWS Kinesis, Kafka is a plus 

• Experience with DevOps tools like Jenkins/Git to assist the development process 

• Experience with the agile development process 

Technologies you’ll use in this role: 

• SQL, BI, Talend, Python, SAS, Postgres, SQL Server 

• Spark, AWS S3