Senior Database Developer
About The Position
Peregrine Advisors is a firm founded on a simple conviction: the best solutions come from the people closest to the problem, given real ownership and the tools to deliver. We are a data and technology innovation hub and a Benefit Corporation working at the center of the federal government's mission to deliver for client stakeholders and the US public, looking for highly motivated contributors who thrive when trusted to own a hard problem and equipped to deliver the solution. Your first assignment is to own the data layer of a federal agency's enterprise data warehouse: the physical design, the models, and the performance that let analysts and systems trust it at scale. You will shape how a large, high-volume platform is structured and tuned on Amazon Redshift and its relational neighbors. The work is real, hard, and it matters. It is also where you start, not the shape of your career here: we hire people, not seats, and we move our best to where the hardest problems are.
Requirements
- Deep, hands-on ownership of a data warehouse on Amazon Redshift (and relational databases like PostgreSQL and SQL Server): physical design, tuning, and modeling.
- Proficiency in stored procedures, schema migration, S3-to-Redshift loads, and governed access.
- Judgment to build in a regulated environment where accuracy and auditability are not optional.
- U.S. citizenship.
- Ability to obtain a Public Trust determination.
Nice To Haves
- Experience designing and tuning large warehouses.
- Experience with experimentation, failure, learning, and repeating quickly.
- Desire to own an outcome rather than be handed a task.
Responsibilities
- Own the data layer of a federal agency's enterprise data warehouse, including physical design, models, and performance.
- Shape how a large, high-volume platform is structured and tuned on Amazon Redshift and its relational neighbors.
- Build a warehouse data layer that performs: physical design (distribution and sort keys, workload management), query and plan tuning on large datasets, and data models that hold up.
- Develop the pipes and guardrails around it: schema migrations, S3-to-Redshift load patterns, stored procedures, and Apache Ranger access controls.
- In time, contribute to the firm itself by building new capabilities, tools, and lines of business.
Benefits
- Fully paid medical, dental, and vision.
- Matched 401(k) with immediate vesting.
- Unlimited paid time off.
- Sponsored certifications.
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
Senior
Education Level
No Education Listed
