Data Architect (Data Modeling, AWS)

OpenDataJobs • Washington, DC

6d • Hybrid

About The Position

Peregrine Advisors is hiring a Data Architect to design data models and architecture for a large federal data-lake platform on Amazon Web Services (AWS). The role initially focuses on shaping how a federal data lake and its data stores fit together, including S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and Amazon DynamoDB. The architect will establish models and schemas for new and migrated data sources, restructure the existing data ecosystem to reduce redundancy and protect data integrity and accessibility, and ensure access remains governed. The work supports a regulated environment where accuracy and auditability are essential. The role is hybrid in the Washington, DC metropolitan area, with commuting cadence varying by assignment. The initial engagement requires U.S. citizenship and the ability to obtain a Public Trust determination. The position is full-time W-2, with a salary of $112,000 to $170,000 per year. Peregrine describes a collaborative culture centered on ownership, learning, and solving problems through people, process, and technology. Employees work alongside developers, engineers, data scientists, architects, and strategists and may contribute across assignments and clients, from strategy through implementation.

Requirements

• At least 4 years of data architecture and data modeling experience.
• At least 4 years of cloud data architecture experience on AWS, including AWS Glue, Amazon EMR, and AWS Lambda.
• Bachelor's degree.
• Experience with schema design across a data lake and relational stores, including S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and Amazon DynamoDB.
• Experience with data governance and security, using Apache Ranger or comparable access controls.
• Experience with data modeling tools such as ER/Studio or IBM InfoSphere.
• Ability to communicate with technical and non-technical stakeholders.
• Proficiency in writing, PowerPoint, and Excel.
• U.S. citizenship and ability to obtain a Public Trust determination for the initial engagement.

Nice To Haves

• Master's degree in a relevant field.
• Experience with Hadoop or Spark.
• Breadth across the data lifecycle, such as data engineering, data product, data science, or data management.
• Federal information technology experience.
• Familiarity with AI-assisted developer tools.

Responsibilities

• Design data models and schemas across the data lake and its stores, including S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and Amazon DynamoDB.
• Define models and schemas for new and migrated data sources so they fit into a unified architecture.
• Restructure the existing data ecosystem to remove redundancy and protect data integrity and accessibility.
• Ensure data is managed under governed access.
• Communicate architecture and design decisions to technical and non-technical stakeholders.
• Take ownership of outcomes and contribute across evolving assignments and client needs.

Benefits

• Medical, dental, and vision insurance with the employee premium fully paid and half of dependent premiums paid.
• Employer-paid life, accidental death, short-term disability, and long-term disability insurance.
• 401(k) with an employer match of up to 4% of salary.
• Unlimited paid time off.
• Sponsored professional certifications and continuing education.
• Extensive onboarding and support for development across assignments and clients.

What This Job Offers

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