Solutions and Lakehouse Architect

OpenDataJobs • Alexandria, VA

3d • $120,000 - $140,000 • Remote

About The Position

Peregrine Advisors is hiring a full-time, remote Solutions and Lakehouse Architect to help design and build the lakehouse supporting a federal agency’s data products, reporting, and machine learning. The initial work involves owning defined components of the target architecture on Azure Databricks and guiding implementation within the program’s established architecture. The role may evolve across systems, tools, responsibilities, and firm capabilities as client needs change.

The architect may design lakehouse components, including medallion layers and Delta Lake storage; extend the agency’s Unity Catalog governance model; develop dimensional and Data Vault data models; connect external sources through Lakehouse Federation; and serve analysts through Databricks SQL and Power BI. The role also documents design decisions and reference patterns and reviews implementations against them. The position requires federal delivery experience and the ability to satisfy applicable suitability, security, and access requirements. Initial engagement terms require U.S. citizenship and prohibit dual citizens and green card holders.

The role calls for hands-on Azure Databricks design, data governance and modeling judgment, advanced SQL, working Python and PySpark skills, and the ability to write architecture standards and decisions that teams can follow. The architect is expected to take ownership of outcomes, work within and improve an established architecture, and use AI-assisted development tools responsibly by reviewing and testing their output.

The position is a W-2 role with an annual salary of $120,000 to $140,000. Peregrine offers medical, dental, and vision coverage, insurance, a 401(k) match, unlimited paid time off, and sponsored professional certifications and continuing education. Employees work with developers, engineers, data scientists, architects, and strategists across strategy and implementation, with onboarding and opportunities for development across assignments and clients.

Requirements

• At least 4 years of data architecture, data engineering, or analytics engineering experience, including design work on a production data platform.
• Bachelor’s degree.
• Hands-on Azure Databricks experience, including Delta Lake and medallion architecture.
• Data governance experience in Unity Catalog, including access control, lineage, and data classification.
• Data modeling experience for analytics, including dimensional modeling.
• Advanced SQL and working knowledge of Python, including PySpark.
• Experience serving data to analysts and reporting tools, such as through Databricks SQL and Power BI.
• Ability to write decision records, standards, and diagrams for engineers and reviewers.
• Delivery experience in a federal government environment, including its security, access, and review processes.
• Proficiency in writing, PowerPoint, and Excel.
• U.S. citizenship; dual citizenship and green card holders are prohibited by the contract terms.
• Ability to satisfy required suitability, security, and access requirements.

Nice To Haves

• Data Vault experience.
• Experience on a federal system accredited at Impact Level 5 (IL-5) or higher.
• Data architecture work in Microsoft Azure and at least one additional cloud platform, such as AWS or Google Cloud.
• Experience with Lakehouse Federation, Databricks SQL warehouses, or Azure Data Factory.
• Databricks certification or a Microsoft Azure architecture or data certification.
• Federal data governance experience, including records, privacy, and security controls.
• Familiarity with AI-assisted developer tooling.

Responsibilities

• Design components of the agency’s Azure Databricks lakehouse, including medallion layers and Delta Lake storage.
• Implement and extend the Unity Catalog governance model, including catalogs, schemas, access controls, lineage, and required data classifications.
• Build analytical data models, using dimensional modeling for reporting and Data Vault where history and auditability matter.
• Connect external data sources through Lakehouse Federation and provide access for analysts through Databricks SQL and Power BI.
• Document design decisions and reference patterns for owned components.
• Review implementations against documented design decisions and reference patterns.
• Make architecture tradeoffs explicit and leave reusable patterns for the team.
• Use AI-assisted developer tools to help implement, test, and improve owned components, while reviewing and testing their output and remaining accountable for delivered code.
• Work within and improve the program’s established architecture and adapt to evolving assignments and client needs.

Benefits

• Medical, dental, and vision coverage with the employee premium fully paid and half of dependent premiums covered.
• 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 development across assignments and clients.
• Opportunities to rotate across functions to expand skills and perspective.

What This Job Offers

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