Senior Backend Engineer — Data Modeling & SQL

Code Metal, Inc.; Boston, Northern (MA, KY); Hybrid; USD 130,000 - 190,000; Full time

Benefits offered by this job

Health care plan

401k matching

Paid Time Off

Flexible hybrid or remote work

Relocation assistance

Job summary

Code Metal, Inc. is seeking a backend-focused engineer to design core data foundations for a mission-critical platform.

You will translate complex concepts into clean relational data models, durable SQL schemas, and data contracts, building scalable backend services at the intersection of data architecture and domain modeling. Responsibilities include moving business logic into data-driven structures, ingesting and normalizing diverse data, and collaborating with product and domain experts to

Qualifications

• Strong professional experience as a backend software engineer working on production systems.
• Deep experience with relational databases, especially PostgreSQL or similar systems.
• Strong SQL skills including joins, aggregation, CTEs, and 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 and domain logic in data models.
• Strong programming ability in Python.
• Experience with ORMs and migrations such as SQLAlchemy or Alembic.
• Strong communication skills and teamwork with product stakeholders.

Responsibilities

• Design and evolve relational data models representing complex domain concepts, entities, relationships, and workflows.
• Build and maintain SQL schemas, constraints, indexes, migrations, and query patterns for scalable backends.
• Define and enforce data contracts between services, ingestion pipelines, and downstream consumers.
• Develop ingestion and normalization workflows for structured, semi-structured, and external data.
• Move business logic into well-modeled data structures and data-driven rules.
• Collaborate with product and domain experts to convert evolving requirements into data abstractions.
• Build APIs and backend services that expose and operate on data models.
• Improve data consistency, traceability, and maintainability across the system.
• Participate in architecture discussions and code reviews for data modeling decisions.

Skills

Backend engineering

Relational databases

PostgreSQL

SQL proficiency

Data contracts

Data ingestion

Python

ORMs & migrations

Communication

Tools

PostGIS

Job description

Code Metal, Inc. is seeking a backend-focused engineer to design core data foundations for a mission-critical platform.

You will translate complex concepts into clean relational data models, durable SQL schemas, and data contracts, building scalable backend services at the intersection of data architecture and domain modeling. Responsibilities include moving business logic into data-driven structures, ingesting and normalizing diverse data, and collaborating with product and domain experts to