Code Metal - Senior Backend Engineer, Data Systems (Modeling & Simulation)

Boston, Massachusetts, United States - Hybrid1w ago

In Office Senior NA Oil & Gas Aerospace Backend Engineer Software Engineer Python PostgreSQL SQL Move Governance

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 • lifecycle-aware data structures • views or materialized views where appropriate • 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. • Experience working with ORMs and migration frameworks such as: • or comparable tools • Strong communication skills and comfort collaborating with engineers, product stakeholders, and domain experts. • 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 • services or domain layers • Experience modeling complex operational domains such as: • planning systems • geospatial systems • defense, aerospace, or other highly structured data environments • 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: • protobuf or similar tools

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. • Move business logic from ad hoc application code into well-modeled, extensible data structures, including: • configurable rules • eligibility or feasibility checks • mappings and lookup tables • domain-specific constraints • decision logic represented in data • Partner with product, domain experts, and engineers to convert ambiguous or evolving requirements into clear data abstractions. • Build backend services and APIs that expose, validate, and operate on these data models. • Improve the consistency, traceability, and maintainability of data across the system. • Help establish patterns for: • versioned data models • schema governance • data validation • backward-compatible contracts • Participate in architecture discussions and code reviews, especially where data modeling decisions have long-term consequences.

Benefits

• Pay depends on experience, but we strive to be at the upper end of the salary range • 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 • Wage Transparency - The salary range for this role is not a guarantee of compensation or salary, as the final offer amount may vary based on factors including, but not limited to, individual proficiency, skills, experience, and location.