Senior Data Warehouse Architect

Description

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 you'll 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:

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field (Master's 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 you'll 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 we'd 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 you'll 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
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 workplacediscriminationrigh t s 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 :
$210,337.00 - $357,572.00

Nationwide Remote Office (US99)