Data Architect (AWS, Data Lake)

OpenDataJobs • Washington, DC

7d • Hybrid

About The Position

Peregrine Advisors is seeking a Data Architect with expertise in AWS and Data Lake technologies to join their team. This role involves shaping the data architecture and data models for a large federal data-lake platform on Amazon Web Services (AWS), utilizing S3, Apache Iceberg, Amazon Aurora PostgreSQL, and DynamoDB. The position offers the opportunity to build clean data models and schemas, design the architecture for data integration, and contribute to the firm's growth by spinning up new capabilities. The company emphasizes trust, ownership, and solving hard problems that matter.

Requirements

• Sole United States citizenship and the ability to obtain a Public Trust determination.
• Hybrid role based in the Washington, DC metropolitan area, requiring regular commuting into DC.
• Deep data modeling and schema design across a data lake and relational stores on AWS.
• Expertise in the architect's toolkit: cloud data services, governed access, modeling tools, and the judgment to restructure a live ecosystem without breaking it.
• Communication skills to carry a design past technical and non-technical stakeholders in a regulated environment where accuracy and auditability are not optional.
• 5+ years of data architecture and data modeling experience.
• Bachelor's degree.
• Schema design across a data lake and relational stores: S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and DynamoDB.
• AWS cloud data architecture (Glue, EMR, Lambda).
• Data governance and security (Apache Ranger or comparable access controls).
• Data modeling tools (for example ER/Studio or IBM InfoSphere).
• Stakeholder communication with technical and non-technical audiences.
• Basic proficiency in writing, PowerPoint, and Excel.

Nice To Haves

• Master's degree in a relevant field.
• Hadoop or Spark experience.
• Data-lifecycle breadth: data engineering, data product, data science, or data management.
• Federal information technology experience.
• Familiarity with AI-assisted developer tooling.

Responsibilities

• Shape the data architecture and data models for a large federal data-lake platform on Amazon Web Services (AWS).
• Build clean data models and schemas across the data lake and relational stores (S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and DynamoDB).
• Design the architecture that brings data together, including models and schemas for new and migrated sources.
• Restructure the existing ecosystem to cut redundancy and protect integrity and accessibility under governed access.
• Contribute to the firm's growth by spinning up new capabilities, tools, and lines of business.

Benefits

• Medical, dental, and vision with the employee premium fully paid and half of dependent premiums.
• Employer-paid life, accidental death, and short-term and long-term disability insurance.
• A 401(k) matched 100% up to 4% of salary, vesting immediately.
• Unlimited paid time off.
• Sponsored professional certifications and continuing education.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior