Randstad is seeking a Sr. Data Modeler - Integration & Events to serve as a key technical authority across our client's Transportation Operations portfolio. In this role, you will define and govern conceptual, logical, and physical data models, shared semantic standards, and event/API contracts to bridge legacy systems (including mainframe) with modern distributed architectures. By standardizing canonical models, managing schema lifecycles, and establishing formal data contracts in Kafka/Confluent environments, you will ensure reliable, interoperable, and scalable data exchange across mission-critical rail and transit operational platforms.
Design, implement, and maintain conceptual, logical, and physical data models for operational data at rest and data in motion across relational, NoSQL, and event-driven systems.
Lead the definition, evolution, and governance of standardized event contracts and API schemas using Kafka Schema Registry, enforcing compatibility modes, schema references, and consumer-impact standards.
Establish and govern canonical information models, shared operational entities, authoritative definitions, relationships, and naming conventions aligned with enterprise standards (such as ISO/IEC 11179-5).
Reverse-engineer and analyze legacy operational systems-including mainframe environments-to support target-state modernization and seamless data integration.
Partner with solution architects, application engineers, business SMEs, and data integration teams to maintain end-to-end traceability between business concepts, logical models, physical schemas, and event streams.
Review database and schema designs to verify data integrity, normalization tradeoffs, history/effective dating structures, and compliance with enterprise security and governance policies.
Facilitate modeling working sessions to translate complex transportation business rules into reusable, consistent technical definitions across systems.
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline.
8+ years of hands-on data modeling experience designing enterprise conceptual, logical, and physical schemas for mission-critical, highly integrated transactional or operational systems.
Proven mastery of data modeling fundamentals, including grain definition, key strategies, normalization/denormalization trade-offs, constraints, temporal/effective dating, and state management across both Relational and NoSQL platforms.
Hands-on experience with Kafka and Confluent Schema Registry, with practical knowledge of subjects, schema evolution rules, compatibility modes, and reusable event contracts.
Demonstrated track record establishing governed semantic naming standards, metadata dictionaries, and enterprise data models (exposure to ISO/IEC 11179-5 principles preferred).
Strong understanding of distributed architectures, middleware, API integration, and hybrid legacy-to-cloud migration patterns (mainframe exposure is a plus).
Domain experience in transportation, railroad, logistics, transit, aviation, or utilities is strongly preferred.
Excellent communication, documentation, and stakeholder facilitation skills.
Kafka,API,Confluent,data integration,data integrity,database,distributed architectures,event-driven systems,Information Systems,Computer Science,middleware,NoSQL,operational data,operational systems,physical data models,Reverse-engineer,communication,aviation,business concepts,business needs,business rules,enterprise security,data modeling,API integration,facilitation skills,governance,ISO/IEC,logistics,normalization,state management,semantic
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.
