Database architect Jobs in USA

We are building a team for one of the U.S. Federal Government's largest technology modernization programs, underpinning the U.S. capital markets. Built on AWS and leveraging an AI-powered software engineering platform, this program offers a unique opportunity to gain hands-on experience with next-generation AI, Agentic AI, cloud technologies, and AI-driven engineering. If you are looking for technically challenging work, exceptional learning, and a résumé-defining opportunity with national impact, I would love to connect. Job Title: Database Architect Position Type: Full-Time Location: Hybrid (2 days onsite) Days Remote: 3 days remote Position Summary: The Database Architect is responsible for defining and governing the enterprise data architecture for a large-scale federal platform hosted on AWS. This role designs the platform's data models, storage architecture, and data flow strategies to support high-volume filing, dissemination, analytics, and AI-enabled capabilities. Working closely with product, cloud, and engineering teams, the Database Architect ensures the platform delivers high performance, data integrity, security, scalability, and regulatory auditability while establishing enterprise standards for data governance and quality. Key Responsibilities: Define and maintain the target-state enterprise data architecture and logical and physical data models for the platform. Design storage, partitioning, indexing, and data access strategies using AWS data services, including Amazon Aurora, DynamoDB, Amazon S3, and Amazon Redshift. Establish enterprise standards for data governance, data lineage, data quality, and data lifecycle management. Architect scalable data pipelines, system integrations, and data dissemination patterns supporting platform operations. Ensure data security, encryption, privacy, integrity, and regulatory auditability across the platform. Partner with Product Architects, AWS Architects, and engineering teams to address cross-functional data architecture requirements. Enable analytics, reporting, and AI/ML initiatives through well-designed enterprise data architecture. Review database designs, mentor database developers, and promote data architecture best practices across the program. Minimum Experience: 10+ years of data engineering and database architecture experience. Extensive experience designing enterprise data models for large-scale systems. Experience implementing AWS data services in high-volume production environments. Strong understanding of enterprise data governance, security, and regulatory compliance. Mandatory Skills: Enterprise data architecture. Data modeling. Relational database design. NoSQL database architecture. AWS data services. Amazon Aurora. Amazon DynamoDB. Amazon S3. Amazon Redshift. Data storage architecture. Data partitioning strategies. Data access and integration architecture. Data pipelines. Data governance. Data lineage. Data quality management. Data security and encryption. Regulatory auditability. AI/ML data enablement. Cross-functional architecture collaboration. Non-technical Requirements: U.S. work authorization. Ability to obtain a public trust clearance. Nice-to-Have Skills: AWS Data Analytics or related AWS certification. Financial regulatory or high-volume transaction processing systems experience. Experience supporting AI/ML data platforms and analytics initiatives. Degrees and Certifications Required Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related technical discipline (or equivalent professional experience). Preferred AWS Data Analytics or related AWS certification.