Data Modeler (39898)

Join the team as a Data Modeler to design and develop data models supporting key business processes and analytics. You'll work with diverse data sources, collaborate with stakeholders, and ensure high data quality. Ideal candidates have expertise in AWS, Databricks, and strong knowledge of development sciences. Grow your career and drive innovation in data architecture.

🚀 Project
- designing and developing conceptual, logical, and physical data models to support business processes and analytics
- conducting thorough data analysis from systems such as LIMS, lab instruments, Signals, and plate reader data
- applying domain knowledge of DSCS to support workflows like In-silico and processes including drug substance prediction, product stability, and assay monitoring
- understanding pilot plant processes and data from systems like PI, Delta-V, SIPAT, MES
- collaborating with stakeholders to gather requirements and translate them into data models meeting business needs
- creating and maintaining documentation such as data dictionaries, entity-relationship diagrams, and data flow diagrams
- ensuring data integrity and quality by implementing validation rules and data governance practices
- analyzing and optimizing data models for performance, scalability, and maintainability
- working with database administrators to implement data models in relational and non-relational databases
- supporting data integration efforts by designing models facilitating ETL processes
- staying updated on emerging data modeling tools and technologies and recommending process improvements

🎯 Skills
- background in development sciences and Digital Supplies research area
- expertise in developing pipelines and data architecture on AWS, Databricks, Redshift, and related technologies
- trained in drafting and delivering data model best practices in design
- experience managing and composing research datasets at a basic entity level
- ability to interpret technical and functional business and IT requirements

💡 Nice to have
- experience with process data models, analytical models, and stability models
- experience reviewing source system schemas and performing conceptual model design based on core schema and business requirements
- skills in creating System of Records lists and mitigation documents
- ability to draft entity-relationship designs and apply physical naming conventions
- experience building physical models using tools such as SD