Senior Data Analyst

Rockstar

Mid-level Data Analyst joining a top-tier insurance provider's team. Responsible for transforming data into trusted models and dashboards to inform business decisions.

Posted 5/18/2026full-timeRemote • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

BigQuerySQL

About the role

Key responsibilities & impact

Own cross-functional analytics projects. Partner with Operations, Sales, Finance, Product, Member Experience, leadership, and other teams to understand business problems, define requirements, analyze data, and deliver durable solutions.
Build trusted data models. Design, build, test, document, and maintain dbt models that transform raw source data into reliable, reusable, analytics-ready datasets.
Work deeply in BigQuery. Use advanced SQL in BigQuery to investigate complex questions, optimize queries, validate data, create reusable logic, and support production-grade reporting.
Support and improve the BI layer. Build and maintain dashboards, reports, semantic definitions, and self-service analytics experiences in Omni and/or Power BI.
Improve metric consistency. Help define business metrics, reconcile conflicting numbers, document assumptions, and ensure stakeholders understand what data means and how to use it.
Monitor and troubleshoot data quality. Work with Fivetran-fed data and downstream dbt/BI assets to identify pipeline issues, data freshness problems, schema changes, schema changes, source system inconsistencies, and reporting defects.
Translate business ambiguity into data solutions. Lead stakeholder discovery, ask sharp questions, clarify tradeoffs, and convert business needs into practical data requirements and deliverables.
Enable better decision-making. Deliver insights and reporting that help teams improve operational performance, sales effectiveness, member experience, financial visibility, and leadership decision-making.
Use AI tools thoughtfully and safely. Use Claude and other AI tools to accelerate analysis, SQL iteration, documentation, test generation, workflow automation, and stakeholder support while validating outputs and protecting data quality.
Raise the bar for the Data team. Contribute to naming conventions, documentation standards, QA practices, metric governance, dbt structure, BI usability, and overall trust in the data ecosystem.
Other duties as assigned.

Requirements

What you’ll need

Approximately 3–5 years of experience in analytics, business intelligence, data analysis, data engineering-adjacent work, operations analytics, or a related field; equivalent demonstrated capability will also be considered.
Strong SQL skills, including complex joins, CTEs, window functions, subqueries, performance-aware query design, and validation logic.
Experience building dashboards, reports, or self-service analytics assets for business users.
Experience translating business questions into analytical requirements and technical deliverables.
Strong understanding of data modeling concepts, including facts, dimensions, grain, metric definitions, and reusable transformation logic.
Ability to own projects independently while keeping stakeholders aligned.
Strong communication skills with both technical and non-technical audiences.
Excellent problem-solving skills and a proactive, solution-driven mindset.
Ability to thrive in a fast-paced, high-growth environment with multiple priorities.

Benefits

Comp & perks

Company-paid health, dental, life, and disability insurance
401(k) with employer match
Opportunity for professional development
Work from home allowance and support
Positive work environment
Remote, hybrid, or office-based flexibility where applicable

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

SQLdbtBigQuerydata modelingdashboard buildingreport generationdata analysisdata engineeringperformance-aware query designdata quality monitoring

Soft Skills

communication skillsproblem-solving skillsproject ownershipstakeholder alignmentsolution-driven mindsetadaptabilitycollaborationcritical thinkinganalytical thinkingproactive approach