Earth Is Our Runway
Shield AI Logo

Shield AI

Staff Analytics Engineer, Databricks (R5493)

Posted An Hour Ago
Be an Early Applicant
Remote
Hiring Remotely in USA
120K-180K Annually
Senior level
Remote
Hiring Remotely in USA
120K-180K Annually
Senior level
Own and design the Databricks Gold and enterprise semantic layer: implement governed facts, dimensions, KPIs, and semantic models. Translate business KPI definitions into auditable transformation logic, enforce governance promotion paths, review models for correctness, coach domain teams, and ensure traceability, documentation, and compliance-aware data exposures for BI and self-service analytics.
The summary above was generated by AI
Founded in 2015, Shield AI is a venture-backed defense-tech company with the mission of protecting service members and civilians with intelligent systems. Its products include Hivemind autonomy software and V-BAT and X-BAT aircraft. With offices and facilities across the U.S., Europe, the Middle East, and Asia-Pacific, Shield AI’s technology actively supports operations worldwide. For more information, visit www.shield.ai. Follow Shield AI on LinkedIn, X, Instagram, and YouTube. 

Job Description:

The Staff Analytics Engineer owns the Gold layer and enterprise semantic layer of the Databricks lakehouse, where clean and governed Silver-layer data becomes trusted, business-ready models, KPIs, and semantic assets. This role translates approved business definitions into auditable transformation logic and durable analytics models that can be used consistently across multiple domains.

This role is expected to go beyond technical model building. The Analytics Engineer must understand the business meaning of the data being modeled, the operational context behind key metrics, and the classification or usage constraints that affect how data can be exposed, joined, governed, and consumed in a regulated environment.

What you'll do:

  • Own Gold-layer design and delivery, including facts, dimensions, domain data marts, and governed KPI implementations on Databricks.
  • Build and maintain the enterprise semantic layer through curated views, governed semantic models, metric definitions, and reusable patterns for trusted business consumption.
  • Translate approved KPI and metric definitions into precise, testable, auditable transformation logic that matches agreed business meaning.
  • Define and enforce the promotion path from domain Gold to enterprise Gold, ensuring shared metrics are not published without required business and governance sign-off.
  • Partner directly with business stakeholders across domains to clarify KPI definitions, challenge ambiguity, and resolve competing definitions before implementation.
  • Enable domain teams by creating modeling standards, reusable design patterns, review processes, and coaching mechanisms rather than acting as the long-term owner of every downstream use case.
  • Review Gold-layer models created by other teams or partners for correctness, definition integrity, usability, and conformance to enterprise standards.
  • Optimize Gold-layer structures for BI and self-service analytics consumption while preserving traceability, governance, and metric consistency.
  • Ensure semantic models, tables, columns, ownership, and business definitions are documented and discoverable.
  • Apply awareness of data sensitivity, classification, and approved use when designing joins, dimensions, semantic views, and access patterns so the semantic layer reflects both business meaning and compliance requirements.

Required qualifications:

  • 8+ years of experience in analytics engineering, BI engineering, or data engineering with strong dimensional modeling expertise.
  • Hands-on Databricks experience, including Delta Lake and Spark SQL and/or PySpark, with strong familiarity with semantic-layer concepts.
  • Demonstrated experience translating ambiguous business KPI requests into precise and auditable transformation logic.
  • Strong SQL and data modeling fundamentals, including star schemas, fact and dimension design, and slowly changing dimensions.
  • Ability to work directly with business stakeholders and serve as a strong technical counterpart on metric definitions and model quality.
  • Demonstrated ability to understand the underlying business processes and data domains behind the metrics being modeled, not just implement requested transformations.
  • Ability to evaluate whether data can and should be exposed in a semantic layer based on sensitivity, ownership, classification, and policy constraints.
  • Experience with BI tools and an understanding of how semantic models support governed self-service analytics.
  • Track record of reviewing another team's models for correctness, quality, and alignment with shared definitions.

Preferred qualifications:

  • Experience with dbt or comparable transformation frameworks on Databricks.
  • Experience building or maintaining a KPI registry, metrics layer, semantic layer, or comparable governance artifact.
  • Experience in a multi-domain enterprise environment where metrics and definitions overlap across business areas.
  • Databricks certification or comparable evidence of advanced platform expertise.
  • Experience in defense, aerospace, financial services, healthcare, or another highly regulated environment.

#LI-KE1
#LD

Full-time regular employee offer package:
Pay within range listed + Bonus + Benefits + Equity
 
Temporary employee offer package:
Pay within range listed above + temporary benefits package (applicable after 60 days of employment)
 
Salary compensation is influenced by a wide array of factors including but not limited to skill set, level of experience, licenses and certifications, and specific work location. All offers are contingent on a cleared background and possible reference check. Military fellows and part-time employees are not eligible for benefits. Please speak to your talent acquisition representative for more information.
 
###
 
Shield AI is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity or Veteran status. If you have a disability or special need that requires accommodation, please let us know. 

Shield AI Waltham, Massachusetts, USA Office

500 Totten Pond Road, Waltham, MA, United States, 02451

Similar Jobs at Shield AI

An Hour Ago
Remote
USA
140K-210K Annually
Senior level
140K-210K Annually
Senior level
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Build and operate an enterprise Databricks lakehouse: design and maintain Bronze and Silver ingestion/transformation pipelines (batch/stream/CDC), implement Unity Catalog and secure platform constructs, create CI/CD for data assets, enforce data classification and quality, and collaborate with domain teams to enable governed data for analytics.
Top Skills: CdcCi/CdDatabricksDatabricks JobsDatabricks WorkflowsDelta LakePysparkSparkSpark SqlSQLStreamingUnity CatalogVersion Control
Yesterday
In-Office or Remote
270K-400K Annually
Senior level
270K-400K Annually
Senior level
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Drive Intel/Space Force revenue by owning the full sales cycle for Shield AI autonomy software and unmanned systems. Build and maintain a qualified pipeline, shape customer requirements, coordinate internal teams, advance opportunities through contract award, and meet quota while fostering relationships with Intel program offices and operational stakeholders.
Top Skills: Autonomy SoftwareHivemindUnmanned SystemsV-BatX-Bat
3 Days Ago
In-Office or Remote
United States
88K-132K Annually
Junior
88K-132K Annually
Junior
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Design and develop primary and secondary structural components for a next-generation UAV. Perform CAD modeling, hand calculations, limited FEA, generate drawings and documentation, support validation and testing, collaborate with cross-functional teams, and iterate hardware through manufacturing and flight tests.
Top Skills: AbaqusAnsysCatiaDfmaFeaGd&TNastranNxSolidworks

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account