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 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 deve