Senior Data Discovery and Enrichment Expert II

Senior Data Discovery and Enrichment Expert II Data Modeller Love working with data? Ready to create the data models that convert complex sources into scalable, trusted datasets that drive business decisions? Would you like to be part of a team that delivers high-quality software to our customers? Are you a highly visible champion with a ‘can do’ attitude and enthusiasm that inspires others? About Our Team Our global team supports products in electronic health records that introduce students to digital charting and prepare them to document care in today’s modern clinical environment. We have a very stable product that we strive to maintain. Our team values trust, respect, collaboration, agility, and quality. About the Role We are looking for an experienced Data Modeller to join our Data Engineering team. You will design, document and maintain logical and physical data models for analytical and operational systems, working closely with the data architect, system owners, engineers, and business stakeholders. Your work will ensure robust, well-governed data structures that support system integrations, analytics and reporting. Responsibilities Translate business requirements and source-system structures into clear data models and source-to-target mappings Design and maintain logical and physical data models for our data platform. Design may require dimensional models, normalized schemas and/or Data Vault models as appropriate for the use case Collaborate with the Data Architect to align models with enterprise data strategy, standards and architecture patterns Work with system owners and engineers to profile source data, identify data quality issues and propose design changes or remediation Produce and maintain model documentation, entity relationship diagrams (ERDs), data dictionaries, and data lineage Support change management: assess impacts of schema changes, coordinate migrations and versioning with engineering and release teams Contribute to data governance: participate in metadata management, stewardship, and model review boards Support data engineers in implementing models (DDL, transformations, dbt models, etc.) and in performance tuning and testing Assist in data quality rules definition and implement validation frameworks and tests Provide guidance to business stakeholders and junior team members on model interpretation and best practices Requirements Previous experience in data modelling or data architecture roles Strong SQL skills; experience writing complex queries and working with large datasets. Proven experience creating logical and physical data models and ER diagrams. Familiarity with dimensional modelling (Kimball), Data Vault, and normalized modelling approaches. Hands-on experience with a modern cloud data platform such as Snowflake and databases (PostgreSQL or equivalent). Experience with transformation tooling (dbt or equivalent) and CI/CD practices for data pipelines. Familiarity with modelling tools (e.g. SqlDBM, Erwin) Experience in using git Scripting skills using python Comfortable profiling data, identifying quality issues and specifying remediation. Strong collaboration and stakeholder management skills; able to translate business needs into technical designs Good documentation skills and attention to detail Preferred / nice-to-have Knowledge of metadata management and data lineage tools (e.g. Collibra) is desirable. Experience working in an Agile delivery environment Work in a Way that Works for You We promote a healthy work-life balance across our organization. We offer various well-being initiatives, shared parental leave, study assistance, and sabbaticals to help you meet both your immediate responsibilities and long-term goals. Working for You We understand that your well-being and happiness are essential to a successful career. Here are some benefits we offer: Comprehensive Health Insurance covers you and your immediate family. Enhanced Health Insurance Options with competitive rates. Group Life Insurance ensuring financial security for your loved ones. Group Accident Insurance offering extra protection. Flexible Working Arrangements to achieve a balanced work-life schedule. Employee Assistance Program providing support for personal and work-related challenges. Medical Screening prioritizing your well-being. Modern Family Benefits including parental and adoption support. Long-Service Awards recognizing dedication and commitment. Celebratory New Baby Gift. Subsidized Meals (location-specific). Various Paid Time Off options including Casual Leave, Sick Leave, Privilege Leave, Compassionate Leave, Special Sick Leave, and Gazetted Public Holidays. Free Transport for home-office-home commutes (location-specific). About the Business A global leader in information and analytics, we assist researchers and healthcare professionals in advancing science and improving health outcomes for society's benefit. Leveraging our publishing heritage, we combine quality information and extensive data sets with analytics to support visionary science and research, health education, and interactive learning. At Elsevier, your work contributes to addressing the world's grand challenges and fostering a sustainable future. We utilize innovative technologies to support science and healthcare, partnering for a better world. We know your well-being and happiness are key to a long and successful career. We are delighted to offer country specific benefits. Click here to access benefits specific to your location. We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120. Criminals may pose as recruiters asking for money or personal information. We never request money or banking details from job applicants. Learn more about spotting and avoiding scams here. Please read our Candidate Privacy Policy. We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law. USA Job Seekers: EEO Know Your Rights. Elsevier is a global leader in advanced information and decision support for science and healthcare. We believe that by working together with the communities we serve, we can shape human progress to go further, happen faster, and benefit all. We support continuous discovery and uphold the highest standards of content integrity, reliability, and reproducibility so the communities we serve can advance their field of science, healthcare or innovation with confidence. By combining high-quality content with powerful analytics, we transform complexity into clarity and deliver mission-critical insights that help professionals make better decisions when it matters most. We deliver insights that help research institutions, governments, and funders achieve their goals. We help researchers discover and share knowledge, collaborate, and accelerate innovation. We help librarians provide verified, quality information to universities. We help innovators turn knowledge into new products. We help health professionals improve patient care and educators train the next generation of doctors and nurses. Connecting quality content and innovative technologies, we make progress go further and happen faster. And by championing inclusion and sustainability, we ensure progress benefits all. With 9,500 employees, over 2,300 technologists in 5 major tech hubs, and more than 60 locations across the globe, we are committed to supporting the scientific and healthcare communities around the world. We offer a diverse range of opportunities across technology, commercial, business, and early career jobs. If you are looking for a career that inspires progress in science, innovation and health, and allows you to grow every day, find your team at Elsevier. Elsevier is part of RELX Group. Let’s shape progress together. Join us. elsevier.com/about/careers