• Develop and maintain integration solutions using MuleSoft and Salesforce-native tools (e.g., Salesforce Flow, Data Loader). • Collaborate with stakeholders, Business Analysts, and development teams to define data models, integration flows, and technical specifications. • Design and implement scalable, secure data architectures aligned with DHS and federal compliance standards (e.g., NIST, FISMA). • Lead data migration efforts from legacy systems to Salesforce, ensuring data integrity, accuracy, and completeness. • Perform data mapping, cleansing, transformation, and validation to support migration and integration workflows. • Write and optimize ETL scripts (e.g., SQL, Apex, Python) for data extraction, transformation, and loading. • Support the Authorization to Operate (ATO) process by contributing to cybersecurity documentation and ensuring compliance with DoD and federal security standards. • Provide technical guidance on data governance, data quality, and integration best practices. • Create and maintain technical documentation, including migration plans, integration specifications, and gate review deliverables. • Participate in Agile ceremonies (e.g., sprint planning, daily stand-ups) to align with team goals and timelines. • Troubleshoot and resolve data or integration issues post-deployment to support ongoing system maintenance.

• Design, build, and maintain scalable and reliable batch and real-time ETL/ELT data pipelines using cloud services such as GCP Dataflow, Cloud Functions, Pub/Sub, and Cloud Composer. • Architect and implement robust data infrastructure capable of handling high-volume data ingestion and processing. • Develop and manage our central data warehouse in Google BigQuery. • Design and implement data models, schemas, and table structures optimized for performance, scalability, and long-term maintainability. • Write clean, efficient, and maintainable SQL and Python code to transform raw data into curated, analysis-ready datasets. • Build reliable transformation workflows that support analytics, reporting, and data science initiatives. • Monitor, troubleshoot, and optimize data infrastructure to ensure high performance, reliability, and cost efficiency. • Implement BigQuery best practices, including partitioning, clustering, query optimization, and materialized views. • Build and maintain curated data models that serve as the “source of truth” for business intelligence and reporting. • Ensure data is optimized and readily accessible for BI tools such as Looker and other analytics platforms. • Implement automated data quality checks, validation rules, and monitoring frameworks to ensure the integrity and reliability of data pipelines and warehouse systems. • Establish processes for data governance, observability, and lineage tracking. • Work closely with software engineers, data analysts, and data scientists to understand their data requirements and provide the necessary infrastructure and data products. • Lead and support client and stakeholder communication, working with enterprise clients to translate business needs into scalable data solutions. • Partner with product teams and leadership to ensure that technical data solutions align with business strategy and client expectations. • Take ownership of data platforms and architecture decisions, helping shape the future direction of our analytics and data infrastructure. • Identify opportunities to improve data reliability, automate workflows, and generate new insights through data. • Contribute to a collaborative, high-performing engineering culture with strong communication and teamwork.

• Responsible for developing, expanding, and optimizing our data and data pipeline architecture • Support software developers, database architects, data analysts, and data scientists on data initiatives and ensure optimal data delivery architecture is consistent throughout ongoing projects • Creates new pipeline and maintains existing pipeline, updates Extract, Transform, Load (ETL) process • Implements large dataset engineering: data augmentation, data quality analysis, data analytics, data profiling, and develop data strategy recommendations • Operate large-scale data processing pipelines and resolve business and technical issues pertaining to processing and data quality • Assemble large, complex sets of data that meet non-functional and functional business requirements • Identify, design, and implement internal process improvements including re-designing data infrastructure for greater scalability, optimizing data delivery, and automating manual processes • Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics • Work with stakeholders including data, design, product, and government stakeholders and assist them with data-related technical issues • Write unit and integration tests for all data processing code • Work with DevOps engineers on CI, CD, and IaC • Read specs and translate them into code and design documents • Perform code reviews and develop processes for improving code quality.

Description Please note: This role is contingent upon contract award. While it is not an immediate opening, we are actively conducting interviews and extending offers in anticipation of the award. Title: Data Architect / MuleSoft Integration & Migration Specialist The Work: ICF is seeking a seasoned Data Architect with expertise in MuleSoft integration and data migration to lead the design and implementation of scalable data solutions for a Salesforce Government Cloud Platform deployment. This role will ensure seamless integration with external systems, secure and compliant data migration from legacy platforms, and long-term sustainability of the data architecture. Job Location: Remote work is authorized. Must support US Eastern time zone working hours. What You Will Do - Develop and maintain integration solutions using MuleSoft and Salesforce-native tools (e.g., Salesforce Flow, Data Loader). - Collaborate with stakeholders, Business Analysts, and development teams to define data models, integration flows, and technical specifications. - Design and implement scalable, secure data architectures aligned with DHS and federal compliance standards (e.g., NIST, FISMA). - Lead data migration efforts from legacy systems to Salesforce, ensuring data integrity, accuracy, and completeness. - Perform data mapping, cleansing, transformation, and validation to support migration and integration workflows. - Write and optimize ETL scripts (e.g., SQL, Apex, Python) for data extraction, transformation, and loading. - Support the Authorization to Operate (ATO) process by contributing to cybersecurity documentation and ensuring compliance with DoD and federal security standards. - Provide technical guidance on data governance, data quality, and integration best practices. - Create and maintain technical documentation, including migration plans, integration specifications, and gate review deliverables. - Participate in Agile ceremonies (e.g., sprint planning, daily stand-ups) to align with team goals and timelines. - Troubleshoot and resolve data or integration issues post-deployment to support ongoing system maintenance. What You Will Bring With You - 6+ years of experience in data architecture, migration, and integration development. - 3+ years of experience specifically with Salesforce integration and data migration projects. - Active MuleSoft technical certification (e.g., MuleSoft Certified Developer or Integration Architect) - Candidate must have a Public Trust or an Active Secret clearance. - U.S. Citizenship is required due to federal contract requirements. - Candidate must reside in the U.S., be authorized to work in the U.S., and all work must be performed in the U.S. - Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years. What We Would Like You To Bring With You: - Salesforce Certified Platform Integration Architect or Salesforce Administrator certification. - Experience working with federal government clients, particularly DHS or DoD. - Familiarity with Salesforce, including its general functionality and the use cases it supports. - Proficiency with Salesforce development and data management tools (e.g., VS Code, Salesforce CLI, Workbench, Data Loader). - Strong scripting skills in SQL, Apex, or Python for ETL processes. - Deep understanding of federal security and compliance frameworks (e.g., NIST, FISMA). - Excellent communication and documentation skills, with the ability to collaborate across technical and non-technical teams. - Background in data migration projects. Professional Skills: - Highly effective analytical and problem-solving capabilities. - Demonstrated critical thinking, attention to detail, and the ability to produce polished and well-organized written deliverables. - Excellent communication and interpersonal skills to interface effectively with team members and federal clients. - Organized, detailed oriented and able to prioritize and multi-task. Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. 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 policy. We will consider for employment qualified applicants with arrest and conviction records. 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 Candidateaccommodation@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 workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.  However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.   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: $98,614.00 - $167,644.00 Nationwide Remote Office (US99)