Position Summary: The Business Intelligence Analyst will own the development and delivery of reporting and analytics that drive operational performance and strategic decision-making. This role partners closely with cross-functional teams to turn data into clear, actionable insights while ensuring accuracy, scalability, and efficiency across reporting. Key Responsibilities: - Design and maintain Power BI or Tableau dashboards used by site and executive leadership. - Translate business needs into clear, structured reporting and analytics solutions. - Support CRM build, optimization, and reporting integration. - Prepare board-level reporting materials and presentation slides, translating data into clear, executive-ready insights. - Automate recurring reports and improve efficiency of reporting processes where possible. - Ensure data accuracy, consistency, and integrity across all reports and dashboards. - Support ad hoc analysis and reporting requests from leadership. - Partner cross-functionally with operations, finance, and HR to support data needs. - Document data sources, reporting logic, and processes. - May perform other job-related duties as requested or required. Skills/Abilities: - Strong Excel proficiency, including data manipulation, formulas, and pivot tables. - Experience building dashboards in Power BI or Tableau. - Familiarity with SQL or working with structured data sources. - Exceptional attention to detail and commitment to data accuracy. - Strong analytical and problem-solving skills. - Strong organizational skills with ability to manage multiple priorities. Education and Experience: - Bachelor’s degree in Business Analytics, Data Analytics, Management Information Systems, Economics, Mathematics, Finance, or a related quantitative field. - 1–2 years of experience in data analytics, business intelligence, or a related role. - Experience in analytics or reporting roles within consulting, advisory, or fast-paced business environments. - Demonstrated experience translating data into actionable insights in a professional setting.

• Drive the roadmap for Business Intelligence, data governance, and systems integration • Ensure our technology platforms support scalable processes, actionable dashboards, and strategic insights while maintaining security, compliance, and reliability • Invest in integrated systems, business process mapping, and data visibility to unlock better insights and decision making across every function of the company

Company Information At Advarra, we are passionate about making a difference in the world of clinical research and advancing human health. With a rich history rooted in ethical review services combined with innovative technology solutions and deep industry expertise, we are at the forefront of industry change. A market leader and pioneer, Advarra breaks the silos that impede clinical research, aligning patients, sites, sponsors, and CROs in a connected ecosystem to accelerate trials. Company Culture Our employees are the heart of Advarra. They are the key to our success and the driving force behind our mission and vision. Our values (Patient-Centric, Ethical, Quality Focused, Collaborative) guide our actions and decisions. Knowing the impact of our work on trial participants and patients, we act with urgency and purpose to advance clinical research so that people can live happier, healthier lives. At Advarra, we seek to foster an inclusive and collaborative environment where everyone is treated with respect and diverse perspectives are embraced. Treating one another, our clients, and clinical trial participants with empathy and care are key tenets of our culture at Advarra; we are committed to creating a workplace where each employee is not only valued but empowered to thrive and make a meaningful impact. Job Overview Summary Our Summer Intern Program is aimed at providing an enriching and mutually beneficial experience that empowers young talent with the skills, knowledge, and values needed to excel in their chosen fields and prepare them for the next step in their careers. In addition to their working teams, the cohort will have regular opportunities to engage with each other and senior leaders from across Advarra to expand their networks and exposure to the business. The Business Intelligence team has a multitude of on-going projects to support a variety of areas of the business to try to enable the ability to automate reporting capabilities in a broad and consistent fashion. Our goal is to provide insights, transparency, and education to ensure we are a data driven organization with strong data stewardship. The goal of any of our projects is to be able to curate something that provides value to the business unit we are supporting as well as other members of leadership at various levels. We hope to be able to engage our summer intern in a variety of the projects and activities listed below. Job Duties & Responsibilities - Develop and understand data structure to drive consistent data capture and reporting - Learn where new data modeling is required to support the business - Follow best practice as defined by Data Engineering to support Business Analytics needs - Collaborate with stakeholders across the company to gather requirements for reporting - Support the architect of a solution to support analytics needs - Begin to understand all development in process, even if being owned by data engineering, for appropriate tracking and project updates - Participate in release management and deployment, where necessary - Learn to monitor data feeds and engage with data engineering to resolve issues Location This role is open to candidates working in one of the following locations: Columbia, MD or surrounding area candidates working remotely in the United States.  Basic Qualifications - High school diploma required - Graduate or undergraduate student pursuing a degree in analytics, programming, or relevant area - Ability to participate in the cohort beginning Monday, June 1, 2026 and running through Friday, August 7, 2026 and work 40 hours per week between the hours of 9:00am and 5:00pm EST - Must be currently authorized to work in the United States Preferred Qualifications - Must possess personal integrity and effective problem-solving skills   - Excellent communication and organizational skills   - Attention to detail and goal oriented  - Ability to prioritize and manage multiple responsibilities  - Ideally have experience with SQL, Tableau, or other coding languages Physical and Mental Requirements - Sit or stand for extended periods of time at stationary workstation - Regularly carry, raise, and lower objects of up to 10 Lbs. - Learn and comprehend basic instructions - Focus and attention to tasks and responsibilities - Verbal communication; listening and understanding, responding, and speaking Advarra is an equal opportunity employer that is committed to diversity, equity and inclusion and providing a workplace that is free from discrimination and harassment of any kind based on race, color, religion, creed, sex (including pregnancy, childbirth, and related medical conditions, sexual orientation, and gender identity), national origin, age, disability or genetic information or any other status or characteristic protected by federal, state, or local law. Advarra provides equal employment opportunity to all individuals regardless of these protected characteristics. Further, Advarra takes affirmative action to ensure that applicants and employees are treated without regard to any of these protected characteristics in all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation, benefits, and separation from employment.

• Monitor data quality by validating accuracy, consistency, and completeness of data across reports and dashboards • Perform routine checks to ensure timely updates and reliability of reporting data • Collaborate with analysts and stakeholders to clarify data requirements and ensure correct interpretation of metrics • Create and maintain automated reports and dashboards for tracking key product metrics • Identify, investigate, and help resolve discrepancies in data collection, transformation, and processing • Optimizing Tableau dashboard performance and streamlining workflows to drive operational efficiency and enhance user experience.