[Remote] Senior Backend Engineer, Data Systems

Note: The job is a remote job and is open to candidates in USA. Code Metal is redefining code translation for mission-critical industries, helping defense partners move more quickly and reliably from algorithm to silicon. They are seeking a Senior Backend Engineer, Data Systems to design and build the core data foundations of their platform, focusing on relational data models and backend services.ResponsibilitiesDesign and evolve relational data models that represent complex domain concepts, entities, relationships, and workflowsBuild and maintain SQL schemas, constraints, indexes, migrations, and query patterns that support scalable backend systemsDefine and enforce data contracts between services, APIs, ingestion pipelines, and downstream consumersDevelop ingestion and normalization workflows for structured, semi-structured, and external source dataMove business logic from ad hoc application code into well-modeled, extensible data structures, including:Configurable rulesEligibility or feasibility checksMappings and lookup tablesDomain-specific constraintsDecision logic represented in dataPartner with product, domain experts, and engineers to convert ambiguous or evolving requirements into clear data abstractionsBuild backend services and APIs that expose, validate, and operate on these data modelsImprove the consistency, traceability, and maintainability of data across the systemHelp establish patterns for:Versioned data modelsSchema governanceData validationAudit-abilityBackward-compatible contractsParticipate in architecture discussions and code reviews, especially where data modeling decisions have long-term consequencesSkillsStrong professional experience as a backend software engineer working on production systemsDeep experience with relational databases, especially PostgreSQL or similar systemsStrong ability to design: normalized schemas, associative/relationship tables, constraints and validation logic, enum / lookup models, lifecycle-aware data structuresStrong SQL skills, including: complex joins, aggregation, CTEs, views or materialized views where appropriate, query performance awarenessExperience defining or working with data contracts between services, APIs, and persistence layersExperience building or maintaining data ingestion, transformation, or normalization workflowsAbility to reason carefully about business rules, edge cases, and how domain logic should be represented in softwareStrong programming ability in PythonExperience working with ORMs and migration frameworks such as: SQLAlchemy, Alembic, or comparable toolsStrong communication skills and comfort collaborating with engineers, product stakeholders, and domain expertsExperience designing rule-driven systems, policy engines, feasibility checks, or configuration-driven business logicExperience deciding when logic belongs in: application code, SQL/database structures, rules tables, services or domain layersExperience modeling complex operational domains such as: simulations, logistics, planning systems, geospatial systems, defense, aerospace, or other highly structured data environmentsExperience with: PostGIS or geospatial data, event-driven systems, versioned datasets or snapshots, data lineage / provenance, imported external datasets with inconsistent or incomplete source qualityFamiliarity with API schema design and typed contracts, such as: Pydantic, JSON Schema, protobuf or similar tools, OpenAPIBenefitsPay depends on experience, but we strive to be at the upper end of the salary rangeHealth care plan with 100% premium coverage, including medical, dental, and vision401k with 5% matchingPaid Time Off (uncapped vacation, plus sick and public holidays)Flexible hybrid or remote work arrangementRelocation assistance for qualifying employeesCompany OverviewCode Metal is an AI-enabled platform providing verifiable code translation and optimization for edge development and code modernization. It was founded in 2023, and is headquartered in Boston, Massachusetts, USA, with a workforce of 51-200 employees. Its website is https://www.codemetal.ai.