Senior Backend Engineer, Data Systems (Modeling & Simulation)
Code MetalAI-powered Code company
Boston, United StatesSenior
Salesforce Ventures
Accel
B Capital
Smith Point Capital
J2 Ventures
Shield Capital
Software Engineering
About the role
TL;DR
Design and build core data foundations for the platform.
- •We are looking for a Senior Backend Engineer, Data Systems to help design and build the core data foundations of our platform.
- •Key Responsibilities Design and evolve relational data models that represent complex domain concepts, entities, relationships, and workflows.
- •Build and maintain SQL schemas, constraints, indexes, migrations, and query patterns that support scalable backend systems.
- •Define and enforce data contracts between services, APIs, ingestion pipelines, and downstream consumers.
- •Develop ingestion and normalization workflows for structured, semi-structured, and external source data.
- •Partner with product, domain experts, and engineers to convert ambiguous or evolving requirements into clear data abstractions.
- •Requirements Strong professional experience as a backend software engineer working on production systems.
- •Deep experience with relational databases, especially PostgreSQL or similar systems.
- •Strong ability to design normalized schemas, associative/relationship tables, constraints and validation logic, enum / lookup models, and lifecycle-aware data structures.
- •Strong SQL skills, including complex joins, aggregation, CTEs, views or materialized views where appropriate, and query performance awareness.
- •Experience defining or working with data contracts between services, APIs, and persistence layers.
- •Experience building or maintaining data ingestion, transformation, or normalization workflows.
- •Ability to reason carefully about business rules, edge cases, and how domain logic should be represented in software.
- •Strong programming ability in Python.
- •Strong communication skills and comfort collaborating with engineers, product stakeholders, and domain experts.
Required skills
PostgreSQLSQLPython
Nice-to-have skills
OpenAPI
Domain expertise
defenseaerospaceautomotive
Benefits & perks
Health care plan with 100% premium coverage, including medical, dental, and vision, 401k with 5% matching, Paid Time Off (uncapped vacation, plus sick and public holidays), Flexible hybrid or remote work arrangement, Relocation assistance for qualifying employees
Tech stack
PostgreSQLSQLPython