Sr. Data Engineer – Ontology & Semantic Modeling

We’re building a modern data + AI platform where ontologies and semantic models create a consistent understanding of entities, relationships, and meaning across systems. We are seeking a Sr. Data Engineer (Ontology & Semantic Modeling) to design scalable data pipelines, contribute to an ontology-driven semantic layer, and help improve database schema and performance across our platform. This is a hands-on senior engineering role with meaningful architectural influence.

Essential Responsibilities/Duties

Ontology & Semantic Layer

Design, evolve, and maintain ontologies, taxonomies, and semantic models
Define entities and relationships; create mappings from source systems into semantic structures
Establish practical governance practices (versioning, documentation, naming standards)
Ensure semantic consistency across pipelines, APIs, and downstream applications

Data Engineering (Databricks)

Build and operate scalable pipelines using Databricks
Design reliable, well-structured datasets and transformation frameworks
Improve data quality through validation, deduplication, and monitoring
Optimize Spark and SQL workloads for performance and cost efficiency

Database Architecture & Performance (Postgres)

Analyze existing Postgres schemas and query patterns to identify performance bottlenecks
Improve table structures, indexing strategies, and data access patterns
Review query execution plans and optimize joins and filtering logic
Evaluate trade-offs between normalized, dimensional, and denormalized models
Partner with engineering teams to resolve latency and scaling challenges

AI & Agent Enablement

Structure datasets and metadata to support LLM and agentic AI workflows
Support retrieval use cases (RAG / hybrid search) by preparing clean, linked, high-signal data
Collaborate with AI teams to validate semantic consistency and correctness

Cloud & Collaboration

Work within AWS environments (S3, IAM, compute, managed databases)
Collaborate across data engineering, AI, product, and platform teams
Document architecture decisions, ontology standards, and best practices

Minimum Qualifications

5+ years in Data Engineering or Data Architecture
Strong experience with Databricks + Spark in production environments
Advanced SQL and strong data modeling skills (conceptual/logical/physical)
Strong experience with Postgres, including schema design and performance tuning
Experience building reliable ETL/ELT pipelines
Proficiency in Python (or Scala) for data engineering workflows
Experience working in AWS environments
Experience implementing data quality practices (validation, deduplication, monitoring)

Nice to Have

Comfortable working with ontology / semantic modeling concepts
Knowledge graph concepts; exposure to RDF/OWL/SPARQL
Graph databases (Neo4j, etc.)
Experience supporting AI/ML or LLM-based systems (RAG/hybrid retrieval)
Experience with orchestration tools (Airflow, Dagster, dbt)
Experience with governance/lineage tooling (e.g., Unity Catalog)

Travel: 15%

Location: Fremont, CA, Office

Hybrid Workplace

SoundThinking follows a hybrid schedule for employees who live equal to or less than 50 miles from one of our office locations, which include Fremont, CA, Tucson, AZ, Washington, D.C., Orlando, Florida, or Iselin, NJ. Employees are expected to work onsite for a minimum of 3 days per week, unless the advertised role has a specific on-site requirement. The specific days for in-office are dependent on the office location.

Note: The Company reserves exclusive right in its sole discretion to modify, adjust, delete, add or otherwise change the above at any time.

SoundThinking provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, SoundThinking complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

SoundThinking expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of SoundThinking’s employees to perform their job duties may result in discipline up to and including discharge. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact SoundThinking at careers@soundthinking.com for assistance.

The above salary is based on a good faith estimate made at the time of publication and may be modified in the future. The pay offered to a candidate may vary within this range depending on factors such as education, experience, and geographic location.

#LI-SSD

Apply for this job

First name

Last name

Email address

Location

Phone number

Resume

Attach resume

Attach another file

Attach file

How did you learn about this job?

Referred by?

Are you legally authorized to work in the United States? Please answer yes or no.

Will you now or in the future require sponsorship for employment visa status? (H-1B. F-1B, CPT, OPT, etc.). Please answer yes or no

Ability to work onsite at SoundThinking's Fremont, CA office location on Tuesdays, Wednesdays, and Thursdays?

Have you worked with semantic models, ontologies, or knowledge graphs?

Which of the following have you used RDF / OWL, Knowledge graphs (Neo4j, etc.), Data modeling for semantic layers?

Which data quality techniques have you personally implemented? (Select all that apply)

Have you built and supported Databricks + Spark pipelines in a production environment?

Have you designed data models across conceptual, logical, and physical layers?

We invite you to complete the optional self-identification questions below used for compliance with government regulations and record-keeping guidelines. Any self-identification information provided will not be considered in the selection process.

GENDER

VETERAN STATUS Learn more about veteran statuses

If you believe you belong to any of the categories of protected veterans listed below, please indicate by selecting the appropriate category(ies). The hiring employer is subject to the Vietnam Era Veterans' Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA) and requests this information in order to measure the effectiveness of the outreach and positive recruitment efforts it undertakes pursuant to VEVRAA.

DISABILITY STATUS Learn more about disability statuses

We are required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.