Build and maintain governed Silver/Gold data models and semantic assets on Databricks. Translate stakeholder KPIs into testable, reusable transformations, apply enterprise modeling standards, enable domain self-service, ensure data sensitivity and governance, and review domain-contributed models for production readiness.
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, V-BAT and X-BAT aircraft, and Aechelon simulation and synthetic reality technologies. 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.
The Senior Data & Analytics Engineer is a hybrid builder role focused on enabling business domains onto the Databricks platform by developing governed Silver and Gold assets, reusable semantic patterns, and domain-ready analytical models. This role sits between pure data engineering and pure analytics engineering: it requires enough technical depth to work comfortably with transformations and lakehouse patterns, and enough business fluency to build trustworthy models that business stakeholders can use and extend.
Initial focus for this role is expected to be G&A and GTM-oriented domains such as Accounting, Program Finance, RevOps, Marketing, HR, and adjacent business functions, while remaining flexible enough to support more complex future domains such as Product or Engineering as the team matures. This role is not a dashboard factory; it is responsible for durable, governed datasets and semantic assets that accelerate domain self-service while maintaining enterprise consistency.
What you'll do:
- Build and maintain Silver and Gold data models, domain marts, curated datasets, and semantic assets for priority domains onboarding to Databricks.
- Partner directly with business stakeholders to translate domain requirements and KPI definitions into governed, testable, and reusable transformation logic.
- Apply enterprise modeling standards, naming conventions, semantic definitions, and promotion rules, contributing practical improvements back into those standards.
- Create reusable domain patterns and analytical building blocks that allow teams such as FP&A, RevOps, and Marketing to operate more self-service over time.
- Support the design of semantic views and curated layers that can be consumed by BI tools, Databricks SQL, and Genie or related AI/BI experiences.
- Work across domain boundaries when metrics overlap or interact, especially where G&A, GTM, workforce, and product-adjacent concepts intersect.
- Ensure data sensitivity, classification, and approved use are reflected in modeling choices, joins, and semantic exposure, particularly for regulated or restricted datasets.
- Review and refine partner-delivered or domain-contributed data models to ensure they are production-worthy, understandable, and aligned with enterprise definitions.
- Help domain teams grow into more self-service analytics by providing patterns, documentation, examples, and technical guidance rather than permanently centralizing every request.
Required qualifications:
- 5+ years of experience in analytics engineering, BI engineering, data engineering, or a hybrid role spanning modeling and transformation work.
- Strong dimensional modeling and semantic design skills, including facts, dimensions, grain, conformed dimensions, and business-friendly analytical structures.
- Strong SQL skills and comfort working with modern cloud data platforms such as Databricks.
- Ability to translate ambiguous business requirements into precise, auditable, and reusable data models.
- Enough data engineering fluency to work comfortably in Silver-to-Gold transformations, testing, performance tuning, and production deployment contexts.
- Ability to understand the business meaning and usage constraints of the data being modeled, not just the technical transformations involved.
- Strong communication skills and comfort working directly with business stakeholders in domains with evolving definitions and priorities.
Preferred qualifications:
- Experience in finance, program finance, RevOps, marketing analytics, HR analytics, product analytics, or another cross-functional business domain.
- Experience building modular, tested transformation pipelines on Databricks (SQL/pyspark, Delta Live Tables, or equivalent).
- Experience with semantic layer tooling, governed metrics, or AI/BI consumption layers.
- Experience in regulated or security-sensitive industries.
- Ability and interest to expand from initial G&A/GTM domain focus into more technical domains such as Product or Engineering over time.
#LI-KE1
#LC
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.
Similar Jobs at Shield AI
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Lead enterprise strategy and operations: develop multi-year strategic plans, build financial models for capital allocation, translate priorities into cross-functional execution with KPIs, and track performance to sustain execution velocity.
Top Skills:
AechelonAutonomyHivemindV-BatX-Bat
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Lead multi-year strategic planning and annual operating cycles, evaluate portfolio tradeoffs, build financial models for capital allocation, and translate strategy into cross-functional execution plans with KPIs. Conduct market sizing, competitive analysis, scenario modeling, and track performance through operating cadences to identify bottlenecks and recommend solutions.
Top Skills:
AechelonHivemindV-BatX-Bat
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Lead enterprise systems and data architecture across business domains, define target-state architectures and integration patterns, rationalize shadow IT, guide sensitive-data placement in regulated multi-environment contexts, support major strategic programs, establish architecture governance and review practices, and coach engineering teams to raise architectural maturity.
Top Skills:
APIsBatch Data MovementDatabricksEvent-Driven ArchitectureOracle ErpSAPSnowflake
What you need to know about the Belfast Tech Scene
If asked to name the birthplace of the RMS Titanic, you might not say Belfast. Similarly, if asked to name Europe's leading destination for foreign direct investment in new software development, Belfast might not come to mind. Yet, both are true. The city has emerged as a tech powerhouse, recently ranked among the best in the U.K. for tech careers — especially for software developers. It also leads the U.K. with the highest percentage of software development jobs advertised.
