Senior Data Analyst - Looker, SQL, BigQuery

quote.com • United State
Remote
Apply
AI Summary

We're seeking a Senior Data Analyst to build and maintain Looker dashboards, write SQL, and deliver reporting that drives revenue optimization, partner performance, and strategic decision-making. The ideal candidate has strong SQL skills, experience with Looker, and a passion for data-driven insights. You'll work with marketing, operations, and engineering teams to surface opportunities and ensure data-driven decisions.

Key Highlights
Build and maintain Looker dashboards and explores
Write complex SQL queries in BigQuery
Analyze campaign performance, conversion funnels, and revenue trends
Key Responsibilities
Build and maintain Looker dashboards and explores
Write complex SQL queries in BigQuery
Analyze campaign performance, conversion funnels, and revenue trends
Partner with marketing and operations teams to define KPIs, set targets, and build measurement frameworks
Perform ad hoc analysis to support strategic initiatives, pricing decisions, and partner negotiations
Technical Skills Required
Looker LookML SQL BigQuery Data Visualization Data Analysis
Benefits & Perks
Salary + Annual Performance-based Bonus
401(k) with competitive company match
Health insurance, including HSA option
Dental and vision coverage
Life and AD&D insurance
Fully remote company with flexible schedules
Growth Opportunities
Nice to Have
DBT
Google Sheets or Excel
Python/R
Performance Marketing
StratoBaseDB
ETL/Data Pipelines
Version Control (Git and GitHub)
Statistical Analysis

Job Description


Job Title: Data Analyst (Looker, SQL, BigQuery)

Location: Remote (US Only)

Department: Data Analytics

Reports To: Director of Data Operations (Matt Sandy)

Job Summary:

At Quote.com, we're a tech-enabled omnichannel performance marketing organization that delivers high-quality, mission-critical demand at scale to industry-leading partners. We serve customers across multiple market verticals including Auto, Health, Home, and Life Insurance, providing significant value to consumers through an independent, third-party comparison-shopping experience.

We're seeking a Data Analyst to turn SQL into dashboards for actionable insights that drive revenue optimization, partner performance, and strategic decision-making across the organization. You'll build Looker dashboards, write SQL, and deliver the reporting that marketing across the organization rely on daily.

This is a hands-on role for someone who is strong in SQL and Looker and eager to grow their skills while delivering analytics that matter. You'll work directly with marketing, operations, and engineering teams to surface opportunities, monitor KPIs, and ensure data-driven decisions at every level.

Key Responsibilities:
  • Build and maintain Looker dashboards and explores that provide real-time visibility into lead generation, monetization, and partner performance metrics.
  • Write complex SQL queries in BigQuery to analyze large datasets spanning insurance leads, call routing, partner revenue, and marketing attribution.
  • Develop and maintain LookML models that accurately represent business logic and enable self-service analytics across teams.
  • Analyze campaign performance, conversion funnels, and revenue trends to identify optimization opportunities.
  • Create automated reporting workflows that replace manual processes and ensure stakeholders have timely, accurate data.
  • Partner with marketing and operations teams to define KPIs, set targets, and build the measurement frameworks to track them.
  • Perform ad hoc analysis to support strategic initiatives, pricing decisions, and partner negotiations with data-backed recommendations.
  • Monitor data quality within analytics outputs, flagging discrepancies and working with data engineering to resolve upstream issues.
  • Document data definitions, metric calculations, and dashboard logic to ensure consistency and institutional knowledge.
Must-Have Technical Skills:

Hands-on expertise with:

  • Looker & LookML: Building dashboards and explores; experience working with and contributing to LookML models
  • SQL: Strong SQL proficiency, comfortable with window functions, CTEs, complex joins, and subqueries in BigQuery
  • BigQuery: Experience querying and analyzing large-scale datasets in Google BigQuery
  • Data Visualization: Ability to design clear dashboards that communicate insights to technical and non-technical audiences
  • Data Analysis: Can take a business question and turn it into a structured analysis

You should have experience delivering analytics in a Data Analyst, Business Analyst, or BI Analyst capacity.

Nice-to-Have Skills:

Experience or familiarity with any of the following:

  • Transformation Tools: DBT for managing SQL-based transformation layers
  • Spreadsheets: Advanced Google Sheets or Excel for modeling and ad hoc analysis
  • Python/R: Scripting for data analysis, automation, or statistical modeling
  • Performance Marketing: Familiarity with lead generation, CPA/CPL metrics, and insurance vertical dynamics
  • Databases: Familiarity with StratoBaseDB or similar columnar analytics databases
  • ETL/Data Pipelines: Understanding of how data flows from source systems into the warehouse
  • Version Control: Git and GitHub for managing LookML and analytics code
  • Statistical Analysis: A/B testing, regression analysis, or forecasting techniques
Qualifications & Experience:
  • 2+ years of experience in a data analyst, business intelligence, or analytics role.
  • Strong Looker experience including building dashboards, explores, and working with LookML models.
  • Strong SQL skills with the ability to write complex queries against large datasets.
  • Experience working with BigQuery or similar cloud data warehouses.
  • Ability to translate business questions into clear, structured analyses.
  • Good communication skills. You can present findings to both technical and non-technical stakeholders.
  • Comfortable working autonomously in a fast-paced, remote environment.
  • Experience in performance marketing, insurance, or lead generation is a plus.
What We Offer:

Compensation: Salary + Annual Performance-based Bonus

Benefits:

  • 401(k) with a competitive company match
  • Health insurance, including HSA option
  • Dental and vision coverage
  • Life and AD&D insurance

Work-Life Balance: Fully remote company with flexible schedules to support balance and wellness

Growth Opportunities: Potential to expand scope into analytics engineering, data strategy, or team leadership

Team: A small, collaborative team that values autonomy and getting things done

How to Apply:

Submit your resume and a short note explaining why this role excites you and how your experience with Looker and SQL-driven analytics makes you a great fit.

Quote.com is an equal-opportunity employer.

Quote.com does not sponsor or take over ownership of employment visas.



Similar Jobs

Explore other opportunities that match your interests

Business Intelligence Analyst

Data Science
•
2h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Gainwell Technologies

United State

Senior Business Intelligence Analyst

Data Science
•
2h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Apex Systems

United State

Senior Director of Data Science

Data Science
•
3h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

prosper marketplace

United State

Subscribe our newsletter

New Things Will Always Update Regularly