Senior Data Modeler – (OLTP & SQL Server)
Core
Designing scalable, maintainable OLTP database models for enterprise applications in the life sciences industry.
Role type
Senior Data Modeler (OLTP & SQL Server)
Builds
Production database schemas and data models for commercialization services.
Domain
Life Sciences / Healthcare / Enterprise Data Engineering
Deliverable
production ML models | product features
Required skills
OLTP database design, Microsoft SQL Server, T-SQL, ER Modeling, Normalization (3NF), Primary & Foreign Keys, Cardinality, Referential Integrity, Constraints, Indexes, Business Requirements Translation
Preferred skills
Azure SQL, AWS RDS, Database performance tuning, Audit/history data design, Application development/API integration
Technologies
Microsoft SQL Server, T-SQL, Azure SQL, AWS RDS, AI-assisted tools (ChatGPT, Claude, GitHub Copilot)
Responsibilities
Design conceptual, logical, and physical data models for OLTP applications; Translate business requirements into entities, relationships, attributes, and business rules; Design ER models, tables, primary keys, foreign keys, constraints, and indexes; Review and improve existing database structures for data integrity, scalability, maintainability, and performance; Document database designs, assumptions, dependencies, and business rules.
Seniority
Senior, hands-on IC