> Markdown version of [/jobs/ext/4548649-solutions-and-lakehouse-architect](https://www.wearedevelopers.com/jobs/ext/4548649-solutions-and-lakehouse-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Solutions and Lakehouse Architect - **Company:** Open Data Watch, Inc. - **Location:** Alexandria, VA, United States (Remote available) - **Experience:** Experienced - **Salary:** $120,000 - $140,000 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Artificial Intelligence, Amazon Web Services, Microsoft Azure, Data Architecture, Information Engineering, Data Governance, Data Vault Modeling, Data Warehousing, Desktop Publishing, Programming Tools, Dimensional Modeling, Python (Programming Language), Operational Databases, Microsoft PowerPoint, Power BI, SQL Databases, Google Cloud, Cloud Platform System, Data Classification, Azure Data Factory, Sql Optimization, Data Lakes, Pyspark, Data Management, Tools for Reporting, Databricks - **Published:** November 3, 2026 - **Apply:** https://www.careerbuilder.com/job-details/solutions-and-lakehouse-architect-alexandria-va--2abbcde1-9ef5-4398-b84b-f44c8086f5e8 ## About the Role Public Company Accounting Oversight Board (PCAOB), Artificial Intelligence (AI), Securities and Exchange Commission (SEC), Defense Contract Audit Agency (DCAA), Government, Problem Solving Skills, Customer Training, Leadership, FDA (Food and Drug Administration), Small Business, * 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 work, including Delta Lake and the medallion architecture * Data governance in Unity Catalog, including access control, lineage, and data classification * Data modeling for analytics, including dimensional modeling; Data Vault is a plus * Advanced SQL and working Python, including PySpark * Serving data to analysts and reporting tools, for example through Databricks SQL and Power BI * Writing the decision records, standards, and diagrams that engineers and reviewers follow * Delivery experience in a federal government environment, working to its security, access, and review processes * Proficiency in writing, PowerPoint, and Excel * United States citizenship; dual citizenship and green card holders are prohibited by the contract terms * The ability to satisfy the required suitability, security, and access requirements Preferred * 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 Amazon Web Services (AWS) or Google Cloud * 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 artificial intelligence (AI)-assisted developer tooling Who you are You think in systems and in the people who will use them. You can explain why a table belongs in one layer and not another, and you would rather settle a design question once in a written decision than reopen it in every review. You work within an established architecture and improve it from the inside. You experiment, fail, learn, and repeat quickly. You would rather own an outcome than be handed a task. ## Description A lakehouse keeps data in open, low-cost storage, as a data lake does, and adds the transactions, schemas, and governance of a data warehouse. Your first project will likely have you owning defined parts of the target lakehouse architecture on Azure Databricks and guiding their implementation within the program's established architecture. Depending on the assignment, you may: * Design components of the lakehouse on Azure Databricks, including the medallion layers that carry data from raw ingestion to curated, business-ready tables, and the Delta Lake storage beneath them. * Implement and extend the agency's Unity Catalog governance model, including catalogs, schemas, access controls, lineage, and the data classifications the agency's policies require. * Build the data models the business reads from, using dimensional models for reporting and Data Vault where history and auditability matter. * Connect the lakehouse to the sources it does not hold through Lakehouse Federation, and to the analysts who use it through Databricks Structured Query Language (SQL) and Power BI. * Document design decisions and reference patterns for the components you own, and review implementation against them. You deliver components the agency can explain, govern, and extend. You make the tradeoffs explicit, write them down, and leave the team patterns it can apply without you in the room., You will work alongside developers, engineers, data scientists, architects, and strategists, on work ranging from strategy to implementation. We support your development across assignments and clients through extensive onboarding, sponsored professional certifications such as the Data Management Capability Assessment Model (DCAM) and Amazon Web Services (AWS) technical certifications, and rotation across functions to expand your skills and perspective. The mission is real, the problems are hard, and you own what you ship.