Data Analyst, Operations
STEMCELL Technologies Inc. is a privately-owned biotechnology company based in Vancouver that helps power leading-edge life science research around the world. Scientists performing stem cell, immunology, cancer, regenerative medicine and cellular therapy research are among those who rely on our cell culture media, cell separation products, instruments, ancillary reagents and contract assay services. We create novel, useful, standardized products of unfailing quality and deliver them to more than 70 countries via our many regional offices plus distribution centres in Vancouver, Seattle, Grenoble and Singapore. Driven by our love of science and our passion for quality, we see ourselves simply as “Scientists Helping Scientists” – standing by our customers to provide outstanding products, technical support and training. We have over 1000 science-oriented employees globally, including 250 PhDs/MScs, with most others holding a BSc or engineering degree. STEMCELL is proud to be the largest Biotechnology employer in Canada.
Job Description Summary
The Data Analyst is responsible for data analysis, reporting and warehousing, in addition to being engaged in all aspects of the different business areas within STEMCELL. You will also be responsible for providing actionable data to operating departments and will be an integral part of helping establish and grow a new business intelligence platform.
Duties and Responsibilities
Works with internal business areas to define business data modes and reporting requirements.
Perform complex data analysis that requires critical thinking and report development activities, such as the creation of SQL queries in order to extract data for reports.
Contributes to the development of the IT strategy via critical assessment of emerging data management technologies and gaining a deep understanding of STEMCELL’s business processes and tools.
Design and implement report templates using MS Excel and/or Google Sheets, including the ability to develop scripts for those tools.
Assist in the training, support, maintenance, and ongoing administration of reporting applications.
Contribute to the continuous improvement of delivery and operations within reporting and data warehousing.
Collaborate with cross-functional team members on features, design and implementation.
Bachelor's Degree in Computer Science or related discipline.
Experience with business intelligence reporting tools -- SAP Business Warehouse (BW) or BusinessObjects (BOBJ) preferred.
Experience with data visualization and reporting software. Familiarity with Microsoft Access a plus.
Experience writing SQL statements for Oracle and MS-SQL.
Familiarity with the R scripting language.
Familiar with ERP and manufacturing systems -- SAP preferred.
Familiar with issue tracking systems - JIRA preferred.
Excellent communication skills (verbal, written) both in one-on-one and in a group setting including presentation skills in front of development and business areas.
Excellent problem-solving with a keen attention to detail.
This is an opportunity to work with highly motivated colleagues in a science-oriented, creative and dynamic environment. We offer a competitive salary, excellent benefits and significant career development opportunities.
To apply please select the apply button. You will then be directed to a login screen asking you to set up an account. You must set up an account in order to apply.Create an account by selecting the create account button. You will then be asked for your email and to create a password. Your Password must be eight characters long, contain at least one special character, one capital letter, and a number.Once you have created your password you will be asked to upload your resume. Uploading your resume will provide the ability to auto-populate your application with information from your resume. If you prefer to manually complete all of the fields in the application you can do this by clicking next. You can upload your cover letter as an attachment in the attachments screen. Thank you for your interest in STEMCELL!