Databricks Architect

Robotic Process Automation LLC; Princeton (NJ); On-site; USD 93,000 - 133,000; Full time

Job summary

Robotic Technologies Automation seeks a hands-on Lead Data and AI Architect to design and build governed, conversational self‑service data solutions on Databricks. You will lead architecture from source data through to business-ready answers, balancing centralized hub governance with unit-level data context.

You will guide a small engineering team, implement metric views, ABAC policies, and CI/CD for data assets, while aligning with business leaders on data definitions and delivery timelines.

Qualifications

• Minimum 10 years in data engineering and data architecture.
• Hands-on architect on delivery teams for 3+ years.
• Experience with Databricks and Unity Catalog in production.
• Experience building governed semantic or metrics layers.

Responsibilities

• Own end-to-end architecture for conversational self-service on Databricks.
• Define semantic and context layer including ontology and rules.
• Publish local definitions to hub with a common model.
• Build metric views and ABAC policies, and manage governance.

Skills

Databricks

SQL

Python

Git

Tools

Unity Catalog

Delta Lake

Databricks SQL

Lakehouse Federation

Delta Sharing

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: Databricks Architect

Location: Princeton, NJ

Duration: 12 Months + Extension

Bill Rate: $82/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

About the role:

We’re looking for a hands‑on Lead Data and AI Architect to design and build governed, conversational self‑service data solutions on Databricks. You’ll lead the architecture from source data through to the answers business users receive, combining a federated data platform, a governed semantic layer, and conversational AI. You’ll work with business and technology leaders to establish shared data definitions while allowing individual business units to retain control of their data and context. You’ll also guide a small engineering team and contribute directly to implementation.

What you’ll do:

• Own the end‑to‑end architecture for conversational self‑service on Databricks.
• Design a federated architecture with a central hub for shared definitions and business units or entities that retain their data and context.
• Define the semantic and context layer, including the ontology, common keys, metric views, business rules, entitlements, certification status, lineage, and knowledge sources.
• Design how local definitions and metric views are published to the hub, mapped to a common model, and reused without copying data.
• Establish governance for metric changes and certification, including ownership, versioning, impact analysis, approvals, and effective dates.
• Build Unity Catalog metric views, SQL functions for business rules, and attribute‑based access control (ABAC) policies using row filters and column masks.
• Configure Genie spaces, Genie Agents, and Genie One, including instructions, example SQL, trusted assets, and benchmark questions.
• Build Agent Bricks solutions that route questions to the appropriate agent.
• Use Lakehouse Federation, Delta Sharing, and clean rooms when data needs to remain in place.
• Manage metric views and agent configurations in Git, with CI/CD using Databricks Asset Bundles.
• Measure answer accuracy using MLflow tracing and evaluation.
• Explain architecture decisions to business and technology leaders, run workshops, and guide engineers through delivery.

What you’ll bring:

• 10–12 years of experience in data engineering and data architecture, including at least 3 years as a hands‑on architect on a delivery team.
• At least 3 years of production experience with Databricks, including Unity Catalog, Delta Lake, Databricks SQL, Lakehouse Federation, and Delta Sharing.
• Experience building a governed semantic or metrics layer—such as Databricks metric views or dbt metrics—used by multiple teams.
• Experience delivering a Genie, text‑to‑SQL, or LLM agent solution beyond a demo, including evaluation of answer accuracy.
• Strong SQL and Python skills, PySpark experience, and familiarity with Git and CI/CD for data assets.
• Experience with data modelling, conformed dimensions, common keys across sources, and reconciling metrics against a system of record.
• Experience with access control, lineage, data sharing, and versioning definitions across multiple teams or entities.
• Strong communication skills, with the ability to explain technical decisions clearly, lead workshops, and write effectively.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.