Main Functions
The Database Architect will join Lallemand's global cross-functional Data Science team in Corporate R&D, where they will work in interdisciplinary collaborations to support Lallemand’s diverse product portfolio of yeast, fungi, and bacteria. Specifically, the Database Architect will serve as the technical owner and designer of a Benchling software product that serves as the central database for our strain culture collection and R&D results generated within the Corporate entity.
You will be responsible for the active maintenance, improvement, and expansion of the Benchling platform at Lallemand through several activities:

• Ongoing review and improvement of the existing Corporate R&D data model;
• Consultation with groups across Lallemand about their database and data analytics needs;
• Monthly coordination of the Benchling leads from different R&D sites to prioritize and execute data management and database administrative tasks;
• Prompt responsiveness to internal help requests and platform troubleshooting, including redirecting users to the Benchling help desk or internal SMEs as needed, and faithful documentation of issue resolution;
• Custom configuration of Benchling to capture more categories of data (in-house implementation), including expansion of the platform to use cases outside of Corporate R&D;
• Needs-based mapping of potential data systems integrations with other company data sources;
• Training and onboarding of new hires to Benchling, including ongoing development of training resources (documentation, workshops, video tutorials);
• Management of the Benchling account relationship and keeping Lallemand users up to date about upgrades and new feature releases.

Technical skills
Required

• Demonstrated experience with data modeling and database administration
• Fluent in SQL, including building complex queries with embedded logic, and the ability to teach introductory SQL workshops to users without prior coding knowledge
• Sufficient familiarity with wet lab experiments, microbiology, and UX design principles, to act as an efficient and successful translator of scientists' data into a relational database format
• Knowledge of, and adherence to, data quality, governance, and security best practices
• Bachelor's degree or higher in Computer Science, Statistics, Bioinformatics, or related fields

An asset

• 2 years' experience working with database software in an industry setting
• Experience configuring and utilizing the Benchling platform (Notebook, Registry, Inventory, Insights, Workflows)
• Formal education and/or research experience in molecular biology and strain engineering

Personal abilities
Required

• Excellent communicator in English, both in person and online
• Excellent interpersonal skills, familiarity with change management, and a service-oriented mindset

An asset

• Bilingual (English/French)

General criteria
Required

• Willingness to travel to sites in the US, Canada, and Europe for 4-5 days at a time, 2-3 times per quarter

Organization
Lallemand is a privately held Canadian company founded in the late 19th century, which develops, produces, and markets microorganisms for various markets. The administrative offices of the parent company are in Montreal, Canada. Today, Lallemand employs more than 5,000 people working in more than 45 countries on 5 continents.
Lallemand's corporate division encompasses all of the support services offered to our branches. Its goal is to optimize internal processes, ensure that your operation is running smoothly, and that your strategy is well thought-out.
Our corporate branch's head office is located in Montreal, Canada, and relies on a team that specializes in: Management; Finance and accounting; Engineering; Research and Development (R&D); Human Resources (HR); and Information Technology (IT). If you want to help bring enthusiasm, collaboration and innovation to our workplace, we'd love to get to know you!
Please take note that accommodations will be provided in all parts of the hiring process. Applicants need to make their needs known in advance.