Senior Data Analyst

About Auctane

About the Role

Stakeholder and Analytics Delivery

• Partner with stakeholders to define analytics deliverables and uncover the decision behind each request.
• Document metric definitions, data grain, dimensionality, filters, refresh cadence, and acceptance criteria.
• Perform exploratory and root-cause analysis on sales, revenue, margin, retention, and operational performance.
• Write findings, caveats, and recommendations for non-technical executive audiences.

Data Engineering and Quality

• Build tested, version-controlled dbt transformation models in BigQuery and Databricks.
• Write advanced SQL and optimize queries using partitioning, clustering, incremental logic, and cost-aware design.
• Implement dbt tests, source freshness checks, and anomaly monitoring.
• Use Git, pull-request review, and CI/CD practices for analytics code.

BI and Semantic Layer

• Develop LookML views, explores, derived tables, and reusable measures.
• Build and maintain Looker dashboards, Looks, schedules, alerts, Power BI semantic models, DAX measures, and reports.
• Optimize dashboard performance, query cost, content organization, and row-level access controls.
• Document metrics, train stakeholders, and enable self-service analytics.

Modernization and Governance

• Support reporting migration and consolidation across GCP, BigQuery, Databricks, Looker, and Power BI.
• Automate recurring manual reporting using Python and scheduled orchestration.
• Document models, metric definitions, and lineage in dbt docs and Confluence.
• Follow and improve standards for naming, testing, code review, and release management.

Required Qualifications

• Bachelor's degree in a quantitative or technical field, or equivalent hands-on experience.
• At least 5 years of experience building BI and analytics solutions on a cloud data platform.
• At least 3 years of advanced SQL experience in production analytics.
• At least 3 years of hands-on dbt experience with production models.
• At least 3 years of dashboard and report development in a modern BI tool.
• Experience gathering requirements from business stakeholders with limited supervision.
• Experience with Google Cloud Platform, particularly BigQuery.
• Proficiency with Python and Git-based development workflows.

Preferred and Additional Experience

• Looker and LookML experience is strongly preferred.
• Experience with Databricks, Power BI, Tableau, semantic layers, orchestration tools, or AI analytics tooling is valuable.
• Experience in logistics, transportation, e-commerce, SaaS, finance analytics, or post-merger BI migration is valuable.
• Strong communication, ownership, curiosity, and ability to manage shifting priorities are emphasized.

Workplace and Schedule

• The role is hybrid with three days per week in the office.
• Auctane states that Austin team members work in the office on Tuesdays, Wednesdays, and Thursdays.

Benefits

• Benefits include flexible time off, paid holidays, 401(k) matching, merit reviews, health plans, wellness resources, education reimbursement, and employee assistance.