Senior Data Analyst

About the role

This is not a ticket-queue analyst role. We are not looking for someone to refresh dashboards when stakeholders ask. We are looking for a senior individual contributor who owns analytics delivery across both Mastermind.com and AI Advantage end to end: data model design, pipeline maintenance, business-facing reporting, and real-time decision support for Sales, Marketing, Client Success, Events, and Operations leadership across both organizations.

Responsibilities

• Build, maintain, and improve dbt models that support reporting across Sales, Marketing, Client Success, and Operations
• Partner with data engineering resources to manage Fivetran connectors and Python-based ingestion workflows
• Own data quality monitoring, documentation, and schema governance for core business domains
• Partner directly with Sales, Marketing, and Operations leaders to scope and deliver analysis that drives decisions
• Build and maintain reporting dashboards in Hex and Google Sheets for leadership and team-level consumption
• Design and run cohort analyses, funnel breakdowns, attribution models, LTV calculations, and revenue performance reporting
• Translate complex findings into clear, actionable narratives for non-technical audiences
• Use AI tools including Claude, ChatGPT, Cursor, and Copilot to accelerate SQL development, dbt model creation, Python scripting, QA, and documentation
• Prototype lightweight internal apps and dashboards when a spreadsheet is not the right output
• Stay current on AI-assisted analytics tooling and bring new approaches to the team
• Maintain and improve GCP/BigQuery infrastructure including Cloud Functions, Cloud Scheduler, and related services
• Support analytics enablement for business stakeholders by building self-serve reporting where appropriate
• Identify and close gaps in data coverage across key business processes

Requirements

• 5+ years of analytics, business intelligence, analytics engineering, or hybrid data experience
• Expert SQL including joins, CTEs, window functions, subqueries, and performance-aware query writing
• Strong Python for data work: pandas, API ingestion, scripting, automation, reporting workflows
• Hands-on dbt experience in a real production environment including models, tests, macros, and documentation
• Cloud data warehouse experience; BigQuery is preferred, Snowflake or Redshift is acceptable
• Demonstrated ability to partner with non-technical stakeholders and deliver clear, actionable analysis
• Concrete examples of using AI tools to accelerate analytics work
• Ability and willingness to work onsite in Scottsdale, AZ, five days per week