Business Intelligence Analyst

Summary

Advarra Reporting And Insights Team SupportAt 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. 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.This position supports Advarra's Reporting and Insights team, working closely with both Business Intelligence and Data Platforms to deliver reporting, dashboards, and data-driven insights. The role involves creating and maintaining deliverables such as data models and pipelines, conducting ad hoc analysis, and resolving business and technical issues. Success requires strong analytical skills, experience with SQL query development and optimization, effective documentation, and the ability to manage multiple priorities while aligning with broader business objectives.Job Duties & ResponsibilitiesLead situations where new data modeling is required, make design decisions for data solutions to support the businessFollow the How We Work procedures developed by Product and Technology teams to support Business Intelligence needsDrive collaboration with identification of required individuals necessary for identified resolutionsWork with teams across the enterprise to ensure appropriate requirements are captured and documentedSupport the architect of solutions and optimize data structure to drive consistent data capture and support analytics needsUnderstand all development in process, regardless of ownership, for appropriate tracking and project updatesParticipate in release management and deployment, govern data pipelines, and work with stakeholders across teams for resolutionLocationThis role is open to candidates working remotely in the United States.Basic QualificationsBachelor's Degree in Data Science, Information Science or related area of experience2+ years of experience with a focus on SQL coding, data pipeline monitoring, data modeling, and data validationExcel – advancedSnowflake – advancedDatabricks – advancedSQL – advancedPreferred QualificationsPython, JSON, HTML, and other coding experiencePresentation skills – advancedBusiness analysis skills – advancedDemonstrated proficiency in making effective, well-reasoned decisionsDemonstrated proficiency in end user requirements gatheringAbility to work on cross-functional teamsExcellent attention to detail and time management skills, proven ability to adapt and navigate changeAbility to quickly learn new technologies and systemsPhysical and Mental RequirementsSit or stand for extended periods of time at stationary workstationRegularly carry, raise, and lower objects of up to 10 Lbs.Learn and comprehend basic instructionsFocus and attention to tasks and responsibilitiesVerbal communication; listening and understanding, responding, and speakingAdvarra is an equal opportunity employer that is committed to 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. The base salary range for this role is $77,617 - $134,953. Note that salary may vary based on location, skills, and experience and may vary from the amounts listed above. This position may also be eligible for a variable bonus in addition to base salary as well as health coverage, paid holidays, and other benefits.

Job Description

Advarra Reporting And Insights Team SupportAt 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. 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.This position supports Advarra's Reporting and Insights team, working closely with both Business Intelligence and Data Platforms to deliver reporting, dashboards, and data-driven insights. The role involves creating and maintaining deliverables such as data models and pipelines, conducting ad hoc analysis, and resolving business and technical issues. Success requires strong analytical skills, experience with SQL query development and optimization, effective documentation, and the ability to manage multiple priorities while aligning with broader business objectives.Job Duties & ResponsibilitiesLead situations where new data modeling is required, make design decisions for data solutions to support the businessFollow the How We Work procedures developed by Product and Technology teams to support Business Intelligence needsDrive collaboration with identification of required individuals necessary for identified resolutionsWork with teams across the enterprise to ensure appropriate requirements are captured and documentedSupport the architect of solutions and optimize data structure to drive consistent data capture and support analytics needsUnderstand all development in process, regardless of ownership, for appropriate tracking and project updatesParticipate in release management and deployment, govern data pipelines, and work with stakeholders across teams for resolutionLocationThis role is open to candidates working remotely in the United States.Basic QualificationsBachelor's Degree in Data Science, Information Science or related area of experience2+ years of experience with a focus on SQL coding, data pipeline monitoring, data modeling, and data validationExcel – advancedSnowflake – advancedDatabricks – advancedSQL – advancedPreferred QualificationsPython, JSON, HTML, and other coding experiencePresentation skills – advancedBusiness analysis skills – advancedDemonstrated proficiency in making effective, well-reasoned decisionsDemonstrated proficiency in end user requirements gatheringAbility to work on cross-functional teamsExcellent attention to detail and time management skills, proven ability to adapt and navigate changeAbility to quickly learn new technologies and systemsPhysical and Mental RequirementsSit or stand for extended periods of time at stationary workstationRegularly carry, raise, and lower objects of up to 10 Lbs.Learn and comprehend basic instructionsFocus and attention to tasks and responsibilitiesVerbal communication; listening and understanding, responding, and speakingAdvarra is an equal opportunity employer that is committed to 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. The base salary range for this role is $77,617 - $134,953. Note that salary may vary based on location, skills, and experience and may vary from the amounts listed above. This position may also be eligible for a variable bonus in addition to base salary as well as health coverage, paid holidays, and other benefits.