Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and optimise data platforms using SQL and Snowflake.
- Company: LGC is a global leader in life sciences, driving innovation for a safer world.
- Benefits: Enjoy hybrid working, a dynamic team environment, and opportunities for personal growth.
- Why this job: Join a passionate team making a real impact in analytics and science.
- Qualifications: Experience in SQL, data modelling, and familiarity with BI tools preferred.
- Other info: Be part of a collaborative analytics team influencing LGC's data strategies.
The predicted salary is between 30000 - 42000 £ per year.
LGC is a global life science tools company with a broad portfolio. We work closely with our diverse customers to drive science forward and find solutions that diagnose, heal, and help feed our growing population. Our 180 years of scientific heritage, combined with a track record of innovation and value-enhancing acquisitions, has enabled us to build our product portfolio and expertise, and develop deep relationships with customers, industry partners and the global scientific community.
Together we solve complex challenges such as managing global pandemics, pioneering precision medicine, improving agriculture outputs, and ensuring the safety of food and medicines. LGC recognises the importance of a work-life balance and will always endeavour to facilitate hybrid working arrangements to support each employee in balancing their working life with personal interests, life-long learning, charity work, leisure activities and other interests.
We are actively looking for individuals that are passionate about making a difference, and have an opportunity for a BI Developer to join our team.
Join Our Group Analytics CoE Team at LGC! Are you ready to take your data analytics career to the next level? At LGC, we’re on the lookout for passionate and skilled individuals to help drive our data platform transformation with innovative projects, like demonstrating cloud-based Snowflake. This is your chance to work with ground breaking tools such as dbt, Snowflake, and Tableau, while being part of a collaborative team dedicated to enhancing our analytics solutions across the business.
What We Offer:
- An exceptional opportunity to contribute to impactful projects within a dynamic team environment.
- A focus on teamwork, inclusion, and rapid growth in analytics capability.
- The chance to shape and elevate our data landscape in a forward-thinking organization.
Your Responsibilities Will Include:
- Developing, maintaining, and supporting the transition of our data platform from SQL Server to Snowflake.
- Building and optimizing data products using Data Vault and core ODS data platforms.
- Constructing and preserving seamless reporting models using SQL.
- Collaborating with fellow analytics experts to implement and enhance analytics solutions.
- Ensuring data is used effectively to solve complex business challenges.
- Presenting and sharing insightful analysis findings with your colleagues.
- Staying abreast of the latest trends in BI tools and data warehousing practices.
- Implementing data models and analytics solutions that meet our evolving business needs.
Qualifications:
- Demonstrable experience in data modeling using SQL.
- Skills in developing reporting models using SQL.
- A solid understanding of relational databases and data warehousing principles.
- Familiarity with Git version control to enhance collaboration.
- Good communication skills for effective collaboration and analysis presentation.
- Experience with Snowflake and/or dbt is advantageous but not essential.
- Familiarity with BI tools such as Tableau and/or SAP Business Objects is a plus.
- A logical and analytical approach to solving business problems.
If you’re eager to make a significant impact in the analytics space and work with a team that values innovation and collaboration, we want to hear from you! Apply now to be part of our exciting journey at LGC.
LGC Group Analytics CoE is a centrally placed team, responsible for providing each business unit within the organisation with analytics support, driving analytics best practices and engagement with our analytics tools (Tableau and SAP Business Objects). As part of the Group Analytics team, this role has the exciting opportunity to learn and develop alongside other analytics colleagues, and help influence how LGC performs analytics.
BI Developer employer: LGC
Contact Detail:
LGC Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Developer
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Snowflake, dbt, and Tableau. Even if you don't have extensive experience with them, showing that you've taken the initiative to learn about these technologies can set you apart from other candidates.
✨Tip Number 2
Network with current or former employees of LGC on platforms like LinkedIn. Engaging in conversations about their experiences can provide valuable insights into the company culture and expectations, which you can leverage during interviews.
✨Tip Number 3
Stay updated on the latest trends in BI tools and data warehousing practices. Being able to discuss recent developments or innovations in the field during your interview will demonstrate your passion and commitment to continuous learning.
✨Tip Number 4
Prepare to showcase your problem-solving skills by thinking of examples where you've successfully used data to address business challenges. This will help you illustrate your analytical abilities and how they align with LGC's mission to solve complex problems.
We think you need these skills to ace BI Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data modelling, SQL, and any familiarity with BI tools like Tableau or Snowflake. Use keywords from the job description to align your skills with what LGC is looking for.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data analytics and your understanding of LGC's mission. Mention specific projects or experiences that demonstrate your ability to contribute to their data platform transformation.
Showcase Your Skills: In your application, provide examples of how you've used SQL and data warehousing principles in past roles. If you have experience with Git or collaborative projects, be sure to include that as well.
Highlight Your Soft Skills: LGC values good communication and teamwork. In your application, mention instances where you've successfully collaborated with others or presented analytical findings, showcasing your ability to work effectively in a team environment.
How to prepare for a job interview at LGC
✨Showcase Your SQL Skills
Since the role requires demonstrable experience in data modelling using SQL, be prepared to discuss your past projects. Highlight specific examples where you've successfully built reporting models or optimised data products.
✨Familiarise Yourself with Snowflake and dbt
Even if you don't have extensive experience with Snowflake or dbt, showing that you've done your homework can impress interviewers. Mention any relevant resources you've explored or projects you've worked on that relate to these tools.
✨Emphasise Team Collaboration
LGC values teamwork and collaboration, so be ready to share experiences where you've worked effectively within a team. Discuss how you contributed to group projects and how you communicated your findings to colleagues.
✨Stay Updated on BI Trends
Demonstrating your knowledge of the latest trends in BI tools and data warehousing practices can set you apart. Prepare to discuss recent developments in the field and how they could apply to LGC's analytics solutions.
