Senior Data Modeler – (OLTP & SQL Server)
Core
Designing robust relational data foundations for enterprise applications and complex business environments by translating requirements into scalable data models.
Role type
Senior IC data modeler (OLTP & SQL Server)
Builds
Scalable conceptual, logical, and physical data models for transactional systems
Domain
Enterprise software / Relational database design
Deliverable
production ML models | product features
Required skills
SQL Server, T-SQL, OLTP architecture, ER modeling, normalization (3NF), data integrity, indexing strategies, business requirements translation
Preferred skills
Azure SQL, AWS RDS, database performance tuning, audit/history data design, API integration, healthcare/pharma domain knowledge, AI-assisted development tools
Technologies
Microsoft SQL Server, T-SQL, Azure SQL, AWS RDS, ChatGPT, Claude, GitHub Copilot
Responsibilities
Design conceptual, logical, and physical data models for enterprise OLTP applications; Translate business requirements into entities, attributes, relationships, and business rules; Develop ER models and detailed database designs covering tables, keys, constraints, and indexes; Apply normalization principles to create efficient relational structures; Review and optimize existing database structures for performance and scalability; Document database architectures, design decisions, and business rules
Seniority
Senior, hands-on IC