Job Family:Database Administration
Travel Required:Up to 10%
Clearance Required:Ability to Obtain Public Trust
What You Will Do:Guidehouse is seeking an experienced Data Architect to join our Technology / AI and Data practice. This individual will have a strong data architecture background and be a hands-on technical leader, responsible for architecting and delivering modern solutions on cloud-native data platforms. This is an exciting opportunity for someone who thrives at the intersection of data architecture, cloud platforms, and public sector modernization. As a member of our Agile team, the Data Architect will collaborate with cross-functional teams and client stakeholders to modernize legacy environments, implement scalable data pipelines, and support advanced analytics initiatives for our federal client.
Solution Development & Innovation
- Architect and implement scalable data pipelines and models using AWS data services.
- Ensure compliance with federal data governance, security, and performance standards.
- Design and document enterprise data models, metadata strategies, and data lineage frameworks.
- Lead the development of data architecture diagrams, including ERDs, and ensure proper data governance is in-place.
- Optimize data architectures for performance with large data sets for both analytics and transactional load use cases (e.g., OLAP, OLTP). Enable downstream BI via clean data.
- Ensuring architectural support for performance-sensitive canned and ad-hoc queries.
- Work with both relational and noSQL (unstructured, semi-structured) data sets, and the cloud services for managing them (AWS RDS, MongoDB, etc.).
- Design and incorporate a solution for document storage and management, accessible to the application.
- Work with application Software Architect and Engineers to ensure alignment of Object Models with Data Models via Object Relational Mapping (ORM).
- Design data architecture to enable Role Based Access Controls (RBAC) in the app.
- Design for security and ensuring proper handling of PII and sensitive data, as well as other non-functional requirements including Data Loss Prevention, data integrity, auditability, RPO, etc.
- Align data from multiple discrete data sets into a cohesive, interoperable architecture, identifying opportunities for linkages between datasets, normalization, field standardization, etc.
- Assist with cleanup of existing data and models, including use of ETL.
Client Leadership & Delivery
- Serve as a trusted technical advisor 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 and relational database solutions using the AWS platform, working with data SMEs.
- Ensure solutions support auditability, internal controls, and statutory compliance requirements. This includes strict financial data controls.
- Lead technical risk assessments and mitigation planning for data-related initiatives.
Practice & Team Leadership
- Lead and support multidisciplinary teams including data engineers, analysts, and consultants.
- Work closely with Application Architects to ensure aligned system architecture.
- Foster a culture of innovation, collaboration, and continuous learning.
- Mentor junior engineers and architects and contribute to architecture review boards and governance forums.
- Contribute to thought leadership and best practice development across the data architecture community.
What You Will Need:- Must be able to OBTAIN and MAINTAIN a Federal "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with ACTIVE PUBLIC TRUST or SUITABILITY are preferred.
- Bachelor's degree is required
- Minimum SEVEN (7) years of experience in cloud platforms, data architecture, and/or data engineering, including significant experience with large data sets.
- Strong understanding of data platforms including AWS.
- Experience designing and integrating cloud-native data solutions using AWS, including Amazon S3 for data storage, Amazon RDS for relational database management, and Amazon Elastic Kubernetes Service (EKS) for container orchestration.
- Experience in data modeling, requirements traceability, and technical documentation (e.g., Jira, Confluence).
- Experience working with development teams using an Agile delivery cadence, CI/CD pipelines, and DevSecOps in cloud-native environments.
- Demonstrated ability to incorporate stakeholder feedback into iterative development.
- Ability to collaborate across technical and business audiences, from executive to engineering teams.
- Excellent communication, facilitation, and relationship-building skills.
- Experience working with application developers using ORM to align microservice object models with relational models .
- Experience with Domain Driven Design (DDD), working closely with Analysts and domain SMEs to align data with the domain.
- Experience with ETL and data structures designed for use with BI / Analytics workloads.
- Experience working with Data Warehouses / Lakes and a governance-driven enterprise data environment.
What Would Be Nice To Have:- Master's Degree
- AWS certifications in relevant areas such as Solutions Architect or Data Engineer
- Experience leading federal modernization initiatives involving financial reporting or revenue systems, including in FISMA Moderate or High environments.
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 & Community Outreach
- Emergency Back-Up Childcare Program
- Mobility Stipend
About GuidehouseGuidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.
Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.
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 at 1- or 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.
All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.
If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse's Ethics Hotline. If you want to check the validity of correspondence you have received, please contact Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant's dealings with unauthorized third parties.
Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.
Never miss an opportunity! Create an alert based on the job you applied for.
