O

OpenData

Delivers standardized open data for research

Solutions and Lakehouse Architect

Data Management +1Confirmed live in the last 24 hours
Full-timeRemote in USA$120k - $140k /yr

About the Job

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 the medallion architecture.
  • Data governance experience in Unity Catalog, including access control, lineage, and data classification.
  • Data modeling experience for analytics, including dimensional modeling; Data Vault is a plus.
  • Advanced SQL skills and working knowledge of Python, including PySpark.
  • Experience serving data to analysts and reporting tools, such as Databricks SQL and Power BI.
  • Ability to write decision records, standards, and diagrams for engineers and reviewers.
  • Delivery experience in a federal government environment, working within 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.
  • Ability to satisfy the required suitability, security, and access requirements.

Responsibilities

  • Design components of the lakehouse on Azure Databricks, including 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 required data classifications.
  • Build business-facing data models, using dimensional models for reporting and Data Vault where history and auditability matter.
  • Connect the lakehouse to external sources through Lakehouse Federation and to analysts through Databricks SQL and Power BI.
  • Document design decisions and reference patterns for owned components, and review implementations against them.
  • Deliver lakehouse components that the agency can explain, govern, and extend; make tradeoffs explicit, document them, and leave reusable team patterns.
  • Use AI tools to help implement, test, and improve owned components; provide clear context, review and test their output, and remain accountable for delivered code.

Desired Qualifications

  • Experience on a federal system accredited at Impact Level 5 (IL-5) or higher.
  • Data architecture experience in Microsoft Azure and at least one additional cloud platform, such as Amazon Web Services 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 artificial intelligence-assisted developer tooling.
  • Data Vault experience.

About the Company

OpenData

Delivers standardized open data for research

OpenData is a collaborative effort that makes public data easier to access and use. It collects public datasets, standardizes them, and centralizes them so researchers, analysts, and governments can find reliable data in one place. The service works by providing access to standardized datasets—through partnerships, subscriptions, or data services—so users can download, analyze, and apply the data to research and policy work. Unlike more traditional data providers, OpenData emphasizes open access and collaboration, focusing on broad accessibility and the usefulness of data for innovation rather than selling bespoke data products. The goal is to empower researchers and organizations to gain insights, drive innovation, and enable positive social impact through open, high-quality public data.

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Mexico
Founded
2024

Recently Posted Jobs

Explore more opportunities at OpenData

See more jobs