Senior Backend Engineer (Data Systems)Dormont Manufacturing Company • Boston, Massachusetts, United States
This job offer is no longer available
Senior Backend Engineer (Data Systems)
Dormont Manufacturing Company
- Boston, Massachusetts, United States
- Boston, Massachusetts, United States
About
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
Strong SQL skills, including:
Complex joins
Aggregation
CTEs
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:
SQLAlchemy
Alembic
Or comparable tools
Strong communication skills and comfort collaborating with engineers, product stakeholders, and domain experts
(Desirable) Experience designing rule-driven systems, policy engines, feasibility checks, or configuration-driven business logic
(Desirable) Experience deciding when logic belongs in:
(Desirable) Application code
(Desirable) SQL/database structures
(Desirable) Rules tables
(Desirable) Services or domain layers
(Desirable) Experience modeling complex operational domains such as:
Simulations
(Desirable) Logistics
(Desirable) Planning systems
(Desirable) Geospatial systems
(Desirable) Defense, aerospace, or other highly structured data environments
(Desirable) Experience with:
(Desirable) PostGIS or geospatial data
(Desirable) Event-driven systems
(Desirable) Versioned datasets or snapshots
(Desirable) Data lineage / provenance
(Desirable) Imported external datasets with inconsistent or incomplete source quality
(Desirable) Familiarity with API schema design and typed contracts, such as:
(Desirable) Pydantic
(Desirable) JSON Schema
(Desirable) Protobuf or similar tools
(Desirable) OpenAPI
What the job involves
We are looking for a Senior Backend Engineer, Data Systems to help design and build the core data foundations of our platform
This role is for an engineer who is deeply comfortable translating complex real-world concepts into clean relational data models, durable SQL schemas, clear data contracts, and maintainable backend services
You will work at the intersection of backend engineering, data architecture, and domain modeling
A major focus of this position will be building systems where business rules and operational logic can be expressed through data structures and database-backed rules, rather than being hardcoded exclusively in application logic
You will help shape how we represent entities, relationships, constraints, validation rules, ingested data, and derived logic across the product
This is not a traditional analytics or BI data engineering role
It is 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
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
Audit-ability
Backward-compatible contracts
Participate in architecture discussions and code reviews, especially where data modeling decisions have long-term consequences
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.