Business Intelligence Data Analyst II

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 This position supports Advarra’s Analytics and Reporting team, working closely with both Business Intelligence and Data Engineering to deliver reporting, dashboards, and data-driven insights. The role involves creating and maintaining deliverables, conducting ad hoc analysis, and resolving business and technical issues. Success requires strong analytical skills, attention to detail, effective documentation, and the ability to manage multiple priorities while aligning with broader business objectives. Job Duties & Responsibilities Understand and optimize data structure to drive consistent data capture and reporting Lead situations where new data modeling is required to support the business Follow best practice as defined by Data Engineering to support Business Intelligence needs Drive collaboration with identification of required individuals necessary for identified resolutions Work with Business and Product Management team to ensure appropriate requirements are captured and documented Support the architect of solutions to support analytics needs Understanding of on all development in process, regardless of team ownership, for appropriate tracking and project updates Participate in release management and deployment, where necessary Monitor data feeds and engage with Data Engineering to resolve issues Location This role is open to candidates working remotely in the United States. Basic Qualifications Bachelor’s Degree in Data Science, Information Science or related area of experience 2-4 years of experience with a focus on SQL coding, system and data feed monitoring, and data validation Excel – advanced Snowflake – advanced Databricks – advanced SQL – advanced DBT Github Presentation skills – advanced Business analysis skills – advanced Demonstrated proficiency in making effective, well-reasoned decisions Demonstrated proficiency in end user requirements gathering Ability to work on cross-functional teams Excellent attention to detail and time management skills, proven ability to adapt and navigate change Ability to quickly learn new technologies and systems Preferred Qualifications Python, JSON, HTML, and other coding experience 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. The base salary range for this role is $77,000 to $134,000 USD . 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.