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
Develop state estimation and navigation algorithms for autonomous systems operating in GPS-denied environments. Build production-grade C++ software for embedded Linux robotic platforms, create modeling and simulation tools, and implement comprehensive testing and validation. Collaborate on roadmap planning and agile execution while improving benchmarking and performance-analysis pipelines. The role requires professional C++ expertise, state estimation algorithm experience, sensor-fusion familiarity, and the ability to deploy reliable autonomy software.
Top Skills:
Automated TestingBarometersC++CamerasCeresCi PipelinesEkfEmbedded LinuxGpsGraph-Based OptimizationGtsamImuLaser AltimetersMagnetometersMatlabOpenvinsParticle FiltersPythonSlamUkfVio
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Develop deep learning and 3D computer vision models for state estimation, visual navigation, localization, depth, correspondence, and pose estimation. Own data preparation, training, evaluation, benchmarking, and reproducible workflows. Integrate learned measurements into VIO and terrain-relative navigation systems, optimize models for onboard compute, and collaborate with deployment, software, systems, and flight-test teams to deliver production-ready Hivemind SDK components.
Top Skills:
3D Computer VisionDeep LearningDiffusion ModelsEmbedded Compute PlatformsFlow MatchingGpu ComputingModel QuantizationMulti-View GeometryOnnxPythonPyTorchSensor Data PipelinesSlamStructure From Motion (Sfm)TensorrtVisual-Inertial Odometry (Vio)
Aerospace • Artificial Intelligence • Machine Learning • Robotics • Software
Leads Shield AI’s Enterprise Data delivery organization, managing data engineering, analytics engineering, domain enablement, and governance teams. Translates enterprise data strategy into sequenced roadmaps, manages priorities, capacity, dependencies, risks, and stakeholder expectations, and ensures production-ready, governed data products. Partners with architecture, platform engineering, security, and business leaders on technical tradeoffs, data quality, lineage, reliability, and investment priorities. Also owns hiring, coaching, performance development, delivery metrics, and continuous improvement of the data operating model.
Top Skills:
DatabricksDatabricks SqlDatabricks WorkflowsDelta LakeLakehouse ArchitectureUnity Catalog
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
