Senior Backend Engineer (Data Systems, Modeling & Simulation)

Join our team as a Senior Backend Engineer, focusing on data systems, modeling, and simulation. In this role, you will design and build the core data foundations of our platform, translating complex real-world concepts into clean relational data models and maintainable backend services. You will work at the intersection of backend engineering, data architecture, and domain modeling, with a major focus on building systems where business rules and operational logic can be expressed through data structures. This is not a traditional analytics or BI data engineering role, but rather a product/backend engineering role with a strong data systems focus.

• 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.
• Ability to reason carefully about business rules, edge cases, and how domain logic should be represented in software
• Strong professional experience as a backend software engineer working on production systems
• SQLAlchemy
• Strong communication skills and comfort collaborating with engineers, product stakeholders, and domain experts
• CTEs
• Associative/relationship tables
• Experience building or maintaining data ingestion, transformation, or normalization workflows
• Query performance awareness
• Enum / lookup models
• Alembic
• Views or materialized views where appropriate
• Strong ability to design:
• Experience defining or working with data contracts between services, APIs, and persistence layers
• Strong SQL skills, including:
• Or comparable tools
• Complex joins
• Strong programming ability in Python
• Deep experience with relational databases, especially PostgreSQL or similar systems
• Lifecycle-aware data structures
• Normalized schemas
• Constraints and validation logic
• Aggregation
• Experience working with ORMs and migration frameworks such as:
• 7+ years of experience designing rule-driven systems, policy engines, feasibility checks, or configuration-driven business logic
• Experience deciding when logic belongs in:
• Application code
• SQL/database structures
• Rules tables
• Services or domain layers
• Experience modeling complex operational domains such as:
• Simulations
• Logistics
• Planning systems
• Geospatial systems
• Experience with:
• Defense, aerospace, or other highly structured data environments
• PostGIS or geospatial data
• Event-driven systems
• Versioned datasets or snapshots
• Data lineage / provenance
• Imported external datasets with inconsistent or incomplete source quality
• Familiarity with API schema design and typed contracts, such as:
• Pydantic
• JSON Schema
• OpenAPI
• Protobuf or similar tools