Data Architect (Data Modeling, AWS)
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 focuses on bringing data sources together in a governed, accurate, and auditable architecture within a regulated environment. The position 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 initial project involves shaping how a federal data lake and its data stores fit together. The architect may design models and schemas across Amazon S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and Amazon DynamoDB; establish how new and migrated sources land in the architecture; restructure the existing data ecosystem to reduce redundancy and protect data integrity and accessibility; and maintain governed access. Assignments may evolve, and employees may move to other challenging problems as the work changes. This is a full-time W-2 position with a salary of $112,000 to $170,000 per year. Peregrine offers collaboration with developers, engineers, data scientists, architects, and strategists, along with onboarding, sponsored professional certifications and continuing education, and opportunities to rotate across functions and clients.
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.
- Schema design across a data lake and relational stores, including S3 with Apache Iceberg tables, Amazon Aurora PostgreSQL, and Amazon DynamoDB.
- Data governance and security experience, 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.
- Hadoop or Spark experience.
- 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 data stores, including Amazon 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.
- Maintain governed access to data.
- Communicate architecture and design decisions to technical and non-technical stakeholders.
- Take ownership of delivery outcomes and adapt to evolving assignments.
Benefits
- Medical, dental, and vision insurance with the employee premium fully paid and half of dependent premiums paid.
- Employer-paid life insurance, accidental death insurance, and short-term 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 opportunities to rotate across functions and assignments to expand skills and perspective.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
