Senior Data Modeler

About MasterControl:

MasterControl Inc. is a leading provider of cloud-based quality and compliance software for life sciences and other regulated industries. Our mission is the same as that of our customers to bring life-changing products to more people sooner. The MasterControl Platform helps organizations digitize, automate and connect quality and compliance processes across the regulated product development life cycle. Over 1,000 companies worldwide rely on MasterControl solutions to achieve new levels of operational excellence across product development, clinical trials, regulatory affairs, quality management, supply chain, manufacturing and postmarket surveillance. For more information, visit www.mastercontrol.com.

Summary: 

As a Senior Data Modeler at MasterControl, you’ll be working on designing, implementing, and maintaining complex data models to support our organization's data  platform which powers all of our data first products. You will have impact to shape the entire data platform as part of the ADAPT AWS based platform and impact our analytics and applications data strategy. Our mission of making life changing products available to more people, sooner, requires innovative thinking, an ability to think at scale and delivery in a fast paced environment. Data is at the center of MasterControls mission and the ideal candidate will have a strong background in data modeling, database design, and data architecture, with experience working in both relational and NoSQL database environments.  

Key  Responsibilities: 

• Develop and maintain conceptual, logical, and physical data models to support various business requirements 
• Collaborate with the larger data engineering organization, platform, product owners, and stakeholder teams to gather and analyze system requirements to deliver scalable and efficient data designs 
• Implement best practices for data modeling, including normalization, denormalization, and indexing 
• Perform data profiling and analysis to identify data quality issues and recommend solutions 
• Optimize database performance through schema design and indexing strategies 
• Document data models, data dictionaries, and data lineage for both technical and non-technical audiences 
• Stay current with emerging technologies and best practices in data modeling, database design, and data management 

Qualifications and Skills: 

• Bachelor's or Master's degree in Computer Science or another equivalent discipline / experience  
• 6+ years of hands-on experience as a data modeler or database designer in a similar role dealing with complex enterprise scale schemas  
• Strong understanding of relational database concepts and SQL using Postgres or similar databases.  
• 3+ years Experience with data warehousing concepts and technologies building complex star schemas 
• Familiarity with Data Governance principles and best practices 
• Familiarity with data modeling standards such as UML, ERDs 
• Strong problem-solving and analytical skills
• Excellent communication and collaboration skills 

Nice to have: 

Exposure to no-SQL databases and vector databases and addressing non-relational schemas and API contracts 

The US base salary range for this full-time position is $150,000 - $190,000 + equity + benefits. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process.

MasterControl is an Equal Opportunity Employer. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact MCTalent@MasterControl.com or call (801) 942-4000 and ask to speak with a member of Human Resources.
Equal Opportunity Employer, including disability and protected veteran status.