[Hiring] Business Intelligence Data Analyst II @Advarra

Role Description

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 & Responsibilities

• Lead situations where new data modeling is required, make design decisions for data solutions to support the business.
• Follow the How We Work procedures developed by Product and Technology teams to support Business Intelligence needs.
• Drive collaboration with identification of required individuals necessary for identified resolutions.
• Work with teams across the enterprise to ensure appropriate requirements are captured and documented.
• Support the architect of solutions and optimize data structure to drive consistent data capture and support analytics needs.
• Understand all development in process, regardless of ownership, for appropriate tracking and project updates.
• Participate in release management and deployment, govern data pipelines, and work with stakeholders across teams for resolution.

Qualifications

• Bachelor’s Degree in Data Science, Information Science or related area of experience.
• 2+ years of experience with a focus on SQL coding, data pipeline monitoring, data modeling, and data validation.
• Excel – advanced.
• Snowflake – advanced.
• Databricks – advanced.
• SQL – advanced.
• DBT.
• Github.

Preferred Qualifications

• Python, JSON, HTML, and other coding experience.
• 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.

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.

Salary and Benefits

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.