Business Analyst Sql R Python Jobs in Lancaster, PA

Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment safer, healthier and more sustainable. From the food you eat, to the water you drink, to the medicines you rely on, Eurofins works with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic and labelling is accurate.

Eurofins is the global leader in food, environment, pharmaceutical and cosmetic product testing and in agroscience Contract Research Organisation services. Eurofins is one of the market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, advanced material sciences and in the support of clinical studies, as well as having an emerging global presence in Contract Development and Manufacturing Organisations. The Group also has a rapidly developing presence in highly specialised and molecular clinical diagnostic testing and in-vitro diagnostic products.

In over just 30 years, Eurofins has grown from one laboratory in Nantes, France to 55,000 staff across a decentralised and entrepreneurial network of 900 laboratories in over 50 countries. Eurofins offers a portfolio of over 200,000 analytical methods to evaluate the safety, identity, composition, authenticity, origin, traceability and purity of biological substances and products.

The Business Intelligence & Insights Intern will support the Business Intelligence and Insights team in developing data and analytics solutions that help the organization turn information into actionable insight. This role is designed for a student with sophomore standing or higher pursuing a degree in Computer Science, Electrical Engineering, Computer Engineering, Data Science, Information Systems, or a closely related technical field.

The intern will work with the BII team to support the development of assigned business intelligence artifacts, including Power BI reports and dashboards, semantic models, data models, database-driven analysis, and related documentation. The role will provide practical exposure to modern BI and data platform practices, including Microsoft Power BI, Microsoft Fabric, structured datasets, and potentially real-time analytics depending on team priorities.

This internship is intended to provide hands-on learning while contributing meaningful support to the team. Success will be measured by the intern’s ability to collaborate effectively, learn the team’s tools and processes, communicate progress clearly, and deliver assigned BI artifacts with quality and professionalism.

POSITION & OBJECTIVES:              

• Support the Business Intelligence and Insights team in the development of assigned BI and analytics artifacts.
• Assist with the creation, enhancement, testing, and documentation of Power BI reports and dashboards.
• Support the development and refinement of semantic models and data models used for reporting and analysis.
• Work with structured data sources and databases to help prepare, validate, and analyze data.
• Assist with analytical analysis to identify trends, answer business questions, and support data-driven decision-making.
• Gain practical experience with Microsoft Power BI, Microsoft Fabric, databases, and modern BI/data platform practices.
• Support data quality review activities, including checking report outputs, validating data logic, and identifying inconsistencies.
• Help document report requirements, model assumptions, data sources, calculations, and business logic.
• Collaborate with team members to understand assigned work, ask appropriate questions, and communicate progress or blockers.
• Contribute to real-time or near-real-time analytics activities when needed by the team.
• Learn how BI artifacts are planned, developed, reviewed, and delivered in a professional team environment.
• Deliver assigned BI artifacts with quality, professionalism, and attention to detail.

QUALIFICATIONS AND EXPERIENCE REQUIRED:

Location

• Candidate must be able to come in at least 1 day every other week on-site at Lancaster, PA

Educational Background

• Currently pursuing a degree with sophomore standing or higher in Computer Science, Electrical Engineering, Computer Engineering, Data Science, Information Systems, Mathematics, Statistics, or a closely related technical field.
• Strong academic interest in data, analytics, databases, reporting, business intelligence, or related technical areas.

Type and Duration of Previous Experience

• No prior professional experience is required.
• Prior academic, internship, project, or personal experience working with data, databases, dashboards, reporting tools, programming, or analytics is preferred.
• Experience completing coursework or projects involving structured data, data analysis, SQL, Power BI, Python, Excel, or similar tools is preferred.

Required Skills

• Ability to work full-time during the summer, with potential part-time availability during the school year.
• Strong analytical and problem-solving skills.
• Ability to learn new technical tools, data concepts, and team processes.
• Ability to work collaboratively with team members and complete assigned work.
• Clear written and verbal communication skills.
• Attention to detail when working with data, reports, documentation, and analysis.
• Willingness to ask questions, receive feedback, and improve work products.

Desired Skills

• Exposure to Power BI, dashboards, reporting, or data visualization.
• Exposure to SQL, relational databases, or structured data analysis.
• Familiarity with data modeling or semantic modeling concepts.
• Exposure to Microsoft Fabric, Azure data services, or other cloud-based data platforms.
• Familiarity with Excel, Power Query, DAX, Python, R, or similar analytical tools.
• Interest in business intelligence, analytics, real-time analytics, or AI-enabled analytics.
• Experience documenting technical work, report logic, data sources, or project assumptions.

Personal Qualities

• Curious and eager to learn.
• Collaborative and professional in a team environment.
• Detail-oriented and careful when working with data.
• Reliable in completing assigned work.
• Comfortable asking questions when requirements or expectations are unclear.
• Open to feedback and willing to improve.
• Interested in using data and analytics to solve practical business problems.

PERFORMANCE APPRAISAL CRITERIA:

Eurofins has a strong focus on performance management. For this internship, performance will be evaluated based on the intern’s ability to learn, contribute, collaborate, and deliver assigned Business Intelligence artifacts with appropriate quality and professionalism.

Performance criteria may include:

• Ability to work effectively with the Business Intelligence and Insights team.
• Successful completion of assigned BI artifacts, such as reports, dashboards, data models, semantic model updates, analysis tasks, or documentation.
• Demonstrated learning and practical application of relevant tools and concepts, including Power BI, data modeling, databases, Microsoft Fabric, and analytical analysis.
• Quality and accuracy of assigned work, including attention to data validation, report logic, documentation, and review feedback.
• Ability to communicate progress, questions, risks, and blockers clearly and professionally.
• Responsiveness to coaching, review comments, and team guidance.
• Reliability in meeting agreed timelines and following team processes.
• Professionalism, curiosity, collaboration, and willingness to learn in a team environment.

Compensation:

• $14.00 per hour

Schedule:

• Monday-Friday 8:00am-5:00pm

What we offer:

• Excellent full time benefits including comprehensive medical coverage, dental, and vision options
• Life and disability insurance
• 401(k) with company match
• Paid vacation and holidays

Eurofins USA BioPharma Services is a Disabled and Veteran Equal Employment Opportunity employer.