Data Warehouse Architect – AI & Data Modernization
About The Position
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.
Requirements
- 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.
Nice To Haves
- 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.
Responsibilities
- 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.
- Foster a culture of innovation, collaboration, and continuous learning.
Benefits
- 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 & Community Outreach
- Emergency Back-Up Childcare Program
- Mobility Stipend
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
