Business Intelligence Data Analyst II

Advarra

. Support Advarra’s Reporting and Insights team .

Posted 10/13/2026full-timeRemote • United StatesJuniorMid-Level💰 $77,617 - $134,953 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in SQL coding, data modeling, and data pipeline management, with a strong focus on delivering data-driven insights and optimizing data structures. Demonstrates advanced skills in Excel, Snowflake, and Databricks, along with effective collaboration and communication abilities across cross-functional teams.

Highest-signal resume keywords

SQL CodingData Pipeline MonitoringData ModelingAdvanced ExcelSnowflake

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL CodingData ModelingData Pipeline MonitoringData ValidationDBTPythonJSONHTML

Soft Skills

Attention to DetailTime ManagementVerbal CommunicationAdaptabilityDecision Making

Tools & Technologies

SnowflakeDatabricksExcelDBT

Industry Keywords

Data ScienceBusiness IntelligenceData GovernanceRequirements GatheringSolution Architecture

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Support Advarra’s Reporting and Insights team
Work closely with Business Intelligence and Data Platforms teams to deliver reporting, dashboards, and data-driven insights
Create and maintain data models and pipelines
Conduct ad hoc analysis
Resolve business and technical issues
Lead situations requiring new data modeling and make design decisions for business data solutions
Follow Product and Technology teams’ How We Work procedures to support Business Intelligence needs
Drive collaboration by identifying individuals needed for resolutions
Work across the enterprise to capture and document requirements
Support solution architecture and optimize data structures for consistent data capture and analytics
Track development in process and provide project updates
Participate in release management and deployment
Govern data pipelines and work with stakeholders across teams to resolve issues

Requirements

What you’ll need

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
Advanced Excel
Advanced Snowflake
Advanced Databricks
Advanced SQL
DBT
Preferred: Python, JSON, HTML, and other coding experience
Preferred: Advanced presentation skills
Preferred: Advanced business analysis skills
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
Ability to sit or stand for extended periods at a stationary workstation
Ability to regularly carry, raise, and lower objects of up to 10 Lbs.
Ability to learn and comprehend basic instructions
Ability to focus and attend to tasks and responsibilities
Verbal communication skills, including listening and understanding, responding, and speaking

Benefits

Comp & perks

Variable bonus eligibility in addition to base salary
Health coverage
Paid holidays
Other benefits