Database Architect

AmeriSOURCE Consulting, Inc.; Washington (District of Columbia); Hybrid; USD 140,000 - 180,000; Full time

Job summary

AmeriSOURCE Consulting, Inc. is seeking a seasoned Database Architect to define and govern the enterprise data architecture for a large-scale federal platform hosted on AWS.

You will design data models, storage architectures, and data flow strategies to support high-volume filing, analytics, and AI-enabled capabilities, ensuring security, scalability, and regulatory auditability. Collaborate with Product, AWS architects, and engineering teams to address cross-functional data requirements and

Qualifications

• Bachelor's degree or equivalent professional experience in a technical discipline.
• 10+ years of data engineering and database architecture experience.
• Experience designing enterprise data models for large-scale systems.
• Experience implementing AWS data services in high-volume production environments.

Responsibilities

• Define and maintain the target-state enterprise data architecture and models.
• Design storage, partitioning, indexing, and data access strategies using AWS data services.
• Establish enterprise standards for data governance, lineage, quality, and lifecycle management.
• Architect scalable data pipelines and integrations for platform operations.
• Ensure data security, encryption, privacy, and regulatory auditability across the platform.
• Collaborate with Product, AWS, and engineering teams on data architecture needs.
• Enable analytics and AI/ML initiatives through solid data architecture.
• Review designs and mentor developers on data architecture practices.

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

Data pipelines

Data governance

Data lineage

Data quality management

Data security and encryption

Regulatory auditability

AI/ML data enablement

Cross-functional architecture

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related field

Tools

Amazon Aurora

Amazon DynamoDB

Amazon S3

Amazon Redshift

AWS data services

Job description

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 Architect, AWS Architect, 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.