Senior Engineer, Business Intelligence & Analytics
Apply NowCompany: Lyell Immunopharma
Location: South San Francisco, CA 94080
Description:
Using living cells to treat - and sometimes even cure - cancer is one of the most dramatic advances in modern medicine. Patients with hematologic malignancies have been successfully treated with cell therapies. However, these profound results have not yet been achieved in patients with solid tumors, representing approximately 90% of all cancers. At Lyell, our goal is to change that. We are a clinical-stage T-cell reprogramming company advancing a diverse pipeline of cell therapies for solid tumors based on our innovative technologies. We were founded by cell therapy pioneers whose decades of research elevated the broader understanding of T-cell biology and its interaction with cancer. In our quest to defeat solid tumors, we have built a fully integrated company capable of discovering new technologies, translating science into therapies, manufacturing cell therapy products, and clinically evaluating them in patients. Our culture is based on Science, Respect, Collaboration, and Courage and reflects who we are, the environment we create, and our mission's urgency.
POSITION SUMMARY:
The individual in this role is responsible for designing, developing, and maintaining interactive dashboards and reports using Tableau and other analytics tools. This role involves working closely with business stakeholders to identify opportunities, gather requirements, analyze data, and deliver actionable insights to support strategic and operational decision-making.
KEY ROLE AND RESPONSIBILITIES:
PREFERRED EXPERIENCE:
Lyell offers its employees a range of compensation and benefits. To assist you with your decision to apply for this role, the following decision to apply for this role, the following information and links to our site highlight our
competitive market position and support to our employees and their dependents.
The salary range for this position is $165,000 and $185,000, annually, with the opportunity to earn an annual bonus. The salary range is an estimate, and the actual salary may vary based on Lyell's compensation practices and an applicant's qualifications and experience. Employees are also eligible to participate in Lyell's Equity Incentive Plan.
Our Employee Benefits program is extensive and includes subsidized medical, dental and vision plans from your first day of employment, FSA, Company provided Life and AD&D Insurance as well as STD and LTD Insurance, ESPP, a 401(k) Plan with Company match, mass transit commuter benefits, cell phone reimbursement and a range of supplemental benefits that you may choose to elect. Our paid time-off benefits currently include 18 days' vacation, 9 day's sick leave, 8 observed holidays as well as a floating holiday. We also have a summer and a winter office shutdown. More information on our extensive benefits offering can be found here.
At Lyell, we believe that highest performing teams include people from a wide variety of backgrounds and experiences who respectfully challenge each other. We are committed to building an open, diverse and inclusive culture for all employees. Lyell is proud to be an equal opportunity employer and does not discriminate on the basis of race, color, citizenship status, national origin, ancestry, sex, sexual orientation, age, religion, creed, physical or mental disability, medical condition, marital status, veteran status or any other characteristics protected under applicable federal, state and local laws.
The Company complies with all laws respecting equal employment opportunity and does not discriminate against applicants with regard to any protected characteristic as defined by federal, state, and local law. This position requires you to work onsite at the Company's facilities and the Company requires that all employees working in its facilities be fully vaccinated (except as required by applicable law). Therefore, this position requires you to be fully vaccinated from COVID-19, subject to reasonable accommodations for medical or religious reasons, and/or as otherwise required by applicable law. The Company considers you fully vaccinated once 14 days have passed since you received either the second dose in a two-dose COVID-19 vaccine series or a single-dose COVID-19 vaccine. The vaccine must have been FDA approved, have emergency use authorization from the FDA, or, for persons fully vaccinated outside of the U.S., be listed for emergency use by the World Health Organization."
We've learned from experience that some of the best people don't always match our requirements perfectly - if you're interested and think you could fit, please don't hesitate to apply.
POSITION SUMMARY:
The individual in this role is responsible for designing, developing, and maintaining interactive dashboards and reports using Tableau and other analytics tools. This role involves working closely with business stakeholders to identify opportunities, gather requirements, analyze data, and deliver actionable insights to support strategic and operational decision-making.
KEY ROLE AND RESPONSIBILITIES:
- Design, develop, and implement end-to-end BI solutions, ensuring they meet business requirements and performance standards
- Design, develop, and maintain interactive dashboards, reports, and visualizations using Tableau and other reporting tools
- Collaborate with various business stakeholders to gather and document requirements for reporting and analytics solutions supporting clinical, manufacturing, supply chain and process development business processes
- Collaborate with data engineers to integrate data from multiple sources, ensuring data accuracy, consistency, and reliability
- Translate business requirements into technical specifications and develop solutions that meet or exceed these requirements
- Optimize and enhance existing Tableau dashboards and reports for performance and usability
- Develop and maintain documentation for dashboards, reports, and data sources.
- Provide training and support to end-users, ensuring they can effectively use BI tools and solutions to make data-driven decisions
- Perform data analysis and validation to ensure the accuracy and integrity of the data.
- Stay up to date with the latest trends and best practices in data visualization and analytics
- Work with the data engineering team to ensure proper data integration and availability for reporting purposes
- Assist in the evaluation and implementation of new tools and technologies to enhance reporting capabilities
- Bachelor's degree in computer science, Information Technology, Business Analytics or a related field with a minimum of 10 years' experience
- Tableau certification.
- Other relevant certifications (e.g., Microsoft Certified: Data Analyst Associate)
PREFERRED EXPERIENCE:
- A minimum of 3 years' experience in reporting and analytics, with strong focus on Tableau
- Experience in a scientific (biotech) organization implementing and managing reporting and analytics solutions involving clinical, supply chain and manufacturing data
- Demonstrated experience in end-to-end management of data and analytics solutions ingesting data from enterprise systems such as ERP, MES, LIMS, QMS etc.
- Experience with business intelligence (BI) tools, such as Tableau, for dashboards and reporting
- Proven experience in designing and developing complex dashboards and reports
- Experience working with UX designers (ability to create UX designs and wireframes)
- Experience reading and understanding data models
- Experience with clinical trial data
- Experience with HIPAA and 21 CFR part 11 compliance
- Strong proficiency in SQL and database management including data extraction, transformation and loading (ETL) processes
- Working with engineering teams developing applications on the cloud, particularly AWS
- Knowledge of programming languages such as Python or R is a plus.
- Demonstrated leadership skills, including presentations of product vision to executives to get buy-in
- Excellent oral and written communication skills
- Ability to work independently and collaboratively among cross-functional teams
- Ability to work efficiently, prioritize workflow, meet deadlines and balance competing priorities
- Excellent analytical skills and scientific/technical expertise
Lyell offers its employees a range of compensation and benefits. To assist you with your decision to apply for this role, the following decision to apply for this role, the following information and links to our site highlight our
competitive market position and support to our employees and their dependents.
The salary range for this position is $165,000 and $185,000, annually, with the opportunity to earn an annual bonus. The salary range is an estimate, and the actual salary may vary based on Lyell's compensation practices and an applicant's qualifications and experience. Employees are also eligible to participate in Lyell's Equity Incentive Plan.
Our Employee Benefits program is extensive and includes subsidized medical, dental and vision plans from your first day of employment, FSA, Company provided Life and AD&D Insurance as well as STD and LTD Insurance, ESPP, a 401(k) Plan with Company match, mass transit commuter benefits, cell phone reimbursement and a range of supplemental benefits that you may choose to elect. Our paid time-off benefits currently include 18 days' vacation, 9 day's sick leave, 8 observed holidays as well as a floating holiday. We also have a summer and a winter office shutdown. More information on our extensive benefits offering can be found here.
At Lyell, we believe that highest performing teams include people from a wide variety of backgrounds and experiences who respectfully challenge each other. We are committed to building an open, diverse and inclusive culture for all employees. Lyell is proud to be an equal opportunity employer and does not discriminate on the basis of race, color, citizenship status, national origin, ancestry, sex, sexual orientation, age, religion, creed, physical or mental disability, medical condition, marital status, veteran status or any other characteristics protected under applicable federal, state and local laws.
The Company complies with all laws respecting equal employment opportunity and does not discriminate against applicants with regard to any protected characteristic as defined by federal, state, and local law. This position requires you to work onsite at the Company's facilities and the Company requires that all employees working in its facilities be fully vaccinated (except as required by applicable law). Therefore, this position requires you to be fully vaccinated from COVID-19, subject to reasonable accommodations for medical or religious reasons, and/or as otherwise required by applicable law. The Company considers you fully vaccinated once 14 days have passed since you received either the second dose in a two-dose COVID-19 vaccine series or a single-dose COVID-19 vaccine. The vaccine must have been FDA approved, have emergency use authorization from the FDA, or, for persons fully vaccinated outside of the U.S., be listed for emergency use by the World Health Organization."
We've learned from experience that some of the best people don't always match our requirements perfectly - if you're interested and think you could fit, please don't hesitate to apply.