Senior Data Warehouse Architect

Please note: This role is contingent upon a contract award. While it is not an immediate opening we are actively conducting interviews and extending offers in anticipation of the award.

Our Digital Modernization and Experience (DMX) Group is growing and we are seeking a highly skilled Senior Data Warehouse Architect to lead the design modernization and optimization of mission-critical enterprise data platforms. This role supports a major cloud-native modernization initiative that integrates data lakehouse architectures and AI/ML readiness to strengthen regulatory insight enhance program effectiveness and improve public safety outcomes.

You will own the architecture strategy and execution for a hybrid environment combining data lakes warehouses and lakehouses ensuring data is modeled governed and optimized for advanced analytics BI and machine learning workloads. Working with engineers analysts and stakeholders you will translate complex business needs into scalable secure and future-proof data solutions.

Job Location: This position is fully remote within United States.

What youll be doing:

• Architect and implement enterprise-scale data lakehouse and warehouse solutions on platforms such as Azure Synapse Snowflake AWS Redshift or Databricks.

• Define data modeling governance and performance optimization standards for analytics and AI/ML use cases.

• Lead the design of ETL/ELT frameworks and streaming pipelines to handle structured semi-structured and unstructured data.

• Ensure feature store integration and ML-ready data provisioning for model training validation and deployment.

• Oversee data governance lineage and security controls aligned with compliance frameworks (e.g. FedRAMP NIST).

• Collaborate with BI teams data scientists and application developers to align architecture with reporting analytics and machine learning objectives.

• Provide technical leadership and mentorship to data engineers and ETL developers.

• Partner with project managers and leadership to create architecture roadmaps and support Agile delivery cycles.

What you must have:

• Bachelors degree in Computer Science Data Engineering Information Systems or related field (Masters preferred).

• 12 years of experience in enterprise data architecture data warehouse design and analytics platform implementation.

• 5 years of expertise in cloud data warehouse and lakehouse platforms (Azure Synapse Snowflake AWS Redshift Databricks Delta Lake Iceberg or Hudi).

• 3 years of experience building ML-ready data pipelines and integrating feature stores for model lifecycle management.

• 12 years of experience in advanced SQL and data modeling skills (star snowflake and data vault).

• 10 years of experience ETL/ELT design experience using Azure Data Factory AWS Glue Informatica Talend or equivalent.

• 5 years of experience in data governance security and compliance frameworks for cloud environments.

• 5 years of experience in architecting scalable secure and high-performance analytics platforms.

• U.S. Citizen or Permanent Resident (Green Card Holder) and eligible for Public Trust Clearance

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

Technologies youll use:

• Cloud & Lakehouse: Azure Synapse Databricks AWS Redshift Snowflake Delta Lake Apache Iceberg

• ETL/ELT: Azure Data Factory AWS Glue Informatica Talend

• Languages & Frameworks: SQL Python Spark

• Analytics & BI: Power BI Tableau Qlik

• DevOps/MLOps: Git Azure DevOps Jenkins Terraform feature store technologies

• Collaboration: Jira Confluence SharePoint Miro/Mural

What wed like you to have:

• Experience leading enterprise data modernization strategies from legacy warehouse to lakehouse environments.

• Familiarity with data mesh and decentralized data architecture principles.

• Track record of mentoring and upskilling teams in modern cloud data practices.

• Strategic vision for emerging data and AI trends and the ability to integrate them into long-term roadmaps.

• Proven success in stakeholder engagement and translating business strategy into data platform design.

Why youll love working here:

• Generous vacation and retirement plans

• Comprehensive health benefits

• Flexible work environment

• Ongoing training and development opportunities

• Inclusive and collaborative culture

• Meaningful work that impacts communities

Working at ICF

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: