Data Warehouse Architect – AI & Data Modernization

Job Family:

Data Science Consulting

Travel Required:

Up to 25%

Clearance Required:

Ability to Obtain Public Trust

What You Will Do:

We are seeking an experienced Data Warehouse Architect to join our growing AI and Data practice, with a dedicated focus on the Federal Civilian Agencies (FCA) market within the Communities, Energy & Infrastructure (CEI) segment. This individual will be a hands-on technical leader, responsible for designing and delivering modern data warehouse solutions that enable federal clients to achieve mission outcomes, operational efficiency, and digital transformation.

This is a strategic delivery role for someone who thrives at the intersection of data architecture, cloud platforms, and public sector modernization.

The Data Warehouse Architect will collaborate with cross-functional teams and client stakeholders to modernize legacy environments, implement scalable data pipelines, and support advanced analytics initiatives.

Client Leadership & Delivery

• Serve as a trusted technical advisor to FCA clients on data architecture and modernization strategy.

• Lead engagements from assessment through implementation, ensuring delivery excellence and measurable outcomes.

• Translate complex business and technical requirements into actionable data warehouse solutions using platforms such as Databricks, Tableau, and Azure/AWS/GCP.

Solution Development & Innovation

• Architect and implement scalable data pipelines and models using Databricks and other modern platforms.

• Rationalize legacy BI environments and design future-state architectures aligned with client goals.

• Ensure compliance with federal data governance, security, and performance standards.

Practice & Team Leadership

• Mentor and guide multidisciplinary teams including data engineers, analysts, and consultants.

• Support recruiting, onboarding, and talent development within the AI & Data practice.

• Foster a culture of innovation, collaboration, and continuous learning.

What You Will Need:

• US Citizenship is required

• Bachelor’s degree is required.

• Minimum SEVEN (7) years of experience in data architecture, data engineering, and analytics.

• Minimum FIVE (5) years of experience delivering data-driven transformation programs.

• Strong understanding of data platforms including Databricks, Tableau, and cloud environments (Azure, AWS, GCP).

• Demonstrated experience supporting the business development lifecycle, including capture and proposal activities.

• Proven track record of leading large-scale data modernization efforts from concept to execution.

• Ability to collaborate across technical and business audiences, from C-suite to engineering teams.

• Excellent communication, facilitation, and relationship-building skills.

What Would Be Nice To Have:

• Master’s Degree.

• Certifications in AI/LLM or cloud data platforms.

• Experience working with FCA clients such as DOT, GSA, USDA, or similar.

• Familiarity with federal contracting and procurement processes.

The annual salary range for this position is $149,000.00-$248,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

What We Offer:

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical, Rx, Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Position may be eligible for a discretionary variable incentive bonus

• Parental Leave and Adoption Assistance

• 401(k) Retirement Plan

• Basic Life & Supplemental Life

• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts

• Short-Term & Long-Term Disability

• Student Loan PayDown

• Tuition Reimbursement, Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Communi