Data Warehouse Architect - AI & Data Modernization Job at Guidehouse in Washingt

Data Science Consulting Travel Required : 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. 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. 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. Mentor and guide multidisciplinary teams including data engineers, analysts, and consultants. • Support recruiting, onboarding, and talent development within the AI & Data practice. • 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). • Proven track record of leading large-scale data modernization efforts from concept to execution. • Excellent communication, facilitation, and relationship-building skills. Certifications in AI/LLM or cloud data platforms. • 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. 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. Medical, Rx, Dental & Vision Insurance • Personal and Family Sick Time & Company Paid Holidays • Position may be eligible for a discretionary variable incentive bonus • 401(k) Retirement Plan • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts • Short-Term & Long-Term Disability • Tuition Reimbursement, Personal Development & Learning Opportunities • Corporate Sponsored Events & Community Outreach • Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting ator via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.