Data Analytics & Reporting Intern

For the past 20 years, ProPharma has improved the health and wellness of patients by providing advice and expertise that empowers biotech, med device, and pharmaceutical organizations of all sizes to confidently advance scientific breakthroughs and introduce new therapies. ProPharma partners with its clients through an advise-build-operate model across the complete product lifecycle. With deep domain expertise in regulatory sciences, clinical research solutions, quality & compliance, pharmacovigilance, medical information, and R&D technology, ProPharma offers an end-to-end suite of fully customizable consulting solutions that de-risk and accelerate our partners’ most high-profile drug and device programs.

The Data Analytics & Reporting Intern supports the collection, analysis, and reporting of business data to help drive informed decision-making. This role provides hands-on experience working with databases, writing SQL queries, and developing reports and dashboards using modern analytics tools. The intern will collaborate with team members to transform raw data into meaningful insights while gaining practical experience in data management, visualization, and business reporting within a professional IT environment.

Essential Functions:

• Assist in writing SQL queries to extract, validate, and analyze data from relational databases

• Support the development and maintenance of reports and dashboards using approved reporting tools

• Help clean, organize, and prepare data for analysis and visualization

• Perform basic data validation and quality checks to ensure accuracy and consistency

• Collaborate with team members to understand reporting requirements and business needs

• Document data sources, report logic, and query processes

• Participate in testing and troubleshooting of reports and analytics solutions

• Present findings and summaries to team members in a clear and structured manner

• Support ad hoc data requests and special analytics projects as assigned

Necessary Skills and Abilities:

• Basic understanding of relational databases and data structures

• Foundational knowledge of SQL for querying and manipulating data

• Familiarity with data analytics concepts and basic statistical methods

• Experience with reporting or data visualization tools (e.g., Power BI, Tableau, Excel)

• Ability to interpret data and translate findings into clear, meaningful reports

• Strong analytical thinking and problem-solving skills

• Effective written and verbal communication skills

Educational Requirements:

• Must be enrolled in at least junior or senior year of undergraduate studies. Open to graduate students as well.

We celebrate our differences and strive to create a workplace where each person can be their authentic self. We are committed to diversity, equity, and inclusion. Employees are encouraged to unleash their innovative, collaborative, and entrepreneurial spirits. With a holistic approach as an Equal Opportunity Employer, we provide a safe space where all employees feel empowered to succeed.

All applications to roles at ProPharma are personally reviewed by a member of our recruitment team. We do not rely on AI screening tools to support our hiring process. You will always receive an outcome to your application so that you have an answer from us - whether you're successful or not.

Whilst ProPharma supports remote working, we also recognise the value that comes from in person collaboration. As such, we encourage any new hires that are based within a reasonably short commute of one of our offices to work on a hybrid basis and spend some time working from that office location, as agreed with your manager. All applications will be treated on their own merit and candidates will not be at any advantage or disadvantage based on their proximity to an office.

***ProPharma Group does not accept unsolicited resumes from recruiters/third parties. Please, no phone calls or emails to anyone regarding this posting.***