Data Analyst

Job Duties

Analytics & Insight Delivery

• Own the end‑to‑end delivery of complex analytical initiatives – framing the business question, scoping the analysis, execution, presentation, and follow‑through on stakeholder action. Proactively surface KPI trends, anomalies, opportunities, and risks.
• Support ad‑hoc analysis for Tillster customers, executives, and internal stakeholders, providing interpretive framing and actionable recommendations.
• Operate as a trusted analytics advisor to Marketing, Product, Finance, Engineering, Account Management, and Support/Operations. Challenge assumptions based on data and translate complex findings into decision‑relevant narratives.
• Design and support A/B test experiments with statistically valid methodology – hypothesis definition, sample sizing, guardrail metrics, and results analysis.

Google Analytics & Data Collection

• Act as the team’s primary Google Analytics subject matter expert: own GA4 reporting, custom dimensions/metrics design, tracking plan validation, and GA‑to‑warehouse integration.
• Advise on tagging strategy for new product features and platform launches in partnership with the Lead MarTech Solutions Architect.

BI Development & Semantic Layer

• Design, build, and maintain high‑performing explores and dashboards in Looker for stakeholders across Marketing, Product, Finance, Engineering, and Support/Operations.
• Develop LookML for owned domains, ensuring documented, tested, and consistent standards.
• Ensure metric definitions in owned domains are canonical and align with the Analytics Engineering team.
• Expand self‑service analytics capabilities – enabling non‑technical users to answer their own questions and reduce ad‑hoc request volume (target coverage across ≥2 new business units per half‑year).
• Proactively maintain accuracy and consistency of production explores and dashboards as underlying data warehouse structures change.

Data Quality & Platform Collaboration

• Own the accuracy and freshness of all data products in scope; identify and investigate quality issues and partner with engineers to resolve upstream problems.
• Write high‑quality, performant SQL, including complex window functions and CTEs; collaborate on query optimisation, compute cost efficiency, and derived table design.
• Collaborate on LookML architecture and semantic layer design for owned domains, providing analytical requirements and validating data models.
• Partner with the Senior BI & AI Analyst on customer analytics definitions for segmentation, LTV, and churn use cases.
• Understand data pipelines feeding dashboards to diagnose freshness and quality issues and communicate resolution timelines.

Standards, Mentorship & Team Development

• Own coding standards and analytical best practices for the team – SQL style guides, LookML conventions, documentation requirements, and PR review processes.
• Mentor Junior Data Analysts through paired analysis, direct feedback, and structured reviews; track improvement over time.
• Build and contribute reusable assets to shared team libraries (SQL query patterns, LookML components, analysis frameworks, documentation templates).
• Contribute to at least one standards update, governance policy, or best‑practice guide per year.

AI‑Augmented Analytics & Self‑Serve Agent Development

• Apply LLM and AI tools (Gemini, GPT‑4, Cortex Analyst, or equivalent) to accelerate analytics workflows, including automated insight narration, anomaly detection, and AI‑assisted dashboard annotation.
• Design and build self‑serve analytics agents that enable non‑technical stakeholders to query data and surface insights in natural language.
• Configure Cortex Analyst or equivalent AI‑assisted BI platforms to extend self‑service beyond traditional dashboard interaction.
• Define quality standards for AI‑generated outputs – accuracy validation, hallucination detection, and review process before sharing externally.
• Prototype and propose AI tooling that reduces repetitive analytical work; present prototypes to the manager with build‑vs‑buy recommendation.

Skills Required with Years of Experience

Core Technical Skills (5‑7 years total experience)

SQL & Data Analysis – 4‑5 years

• Advanced SQL (window functions, CTEs, query optimization)
• Complex analytical queries and performance tuning

Business Intelligence Tools – 3‑4 years

• Looker expert (LookML development, explores, dashboards)
• Data visualization and self‑service analytics design

Google Analytics – 2‑3 years

• GA4 implementation, configuration, and reporting
• Tracking strategy and warehouse integration

Python/Programming – 1‑2 years (preferred)

• Data manipulation and automation
• Version control (Git) and code review

Statistical & Analytical Skills (3‑5 years)

A/B Testing & Experimentation – 2‑3 years

• Experimental design and statistical testing
• Hypothesis formulation and results interpretation

Statistical Analysis – 3‑4 years

• Descriptive and inferential statistics
• Trend analysis and anomaly detection

AI & Emerging Technologies (1‑2 years)

AI‑Augmented Analytics – 1‑2 years

• Hands‑on LLM usage (GPT‑4, Gemini, Cortex Analyst)
• AI agent development and prompt engineering
• AI output validation and quality standards

Business & Communication Skills (4‑6 years)

Stakeholder Management – 4‑5 years

• Cross‑functional collaboration (Marketing, Product, Finance, Engineering)
• Executive communication and presentation
• Trusted advisor relationships

Business Analytics – 3‑4 years

• Customer analytics (segmentation, LTV, churn)
• KPI development and metric definition
• Translating business questions to analytical frameworks

Leadership & Mentorship (2‑3 years)

Team Leadership – 2‑3 years

• Mentoring junior analysts
• Code review and standards enforcement
• Building team best practices and documentation

Project Management – 3‑4 years

• End‑to‑end analytical project ownership
• Managing multiple concurrent initiatives
• Proactive insight delivery

EEO Statement

Mexico’s Federal Labor Law and Constitution prohibit discrimination in hiring and employment practices based on protected characteristics including sex, gender, age, disability, religion, nationality, marital status, health status, sexual orientation, social condition, and other protected categories.

Our company is an equal opportunity employer and does not discriminate on the basis of race, color, religion, national origin, gender identity, sexual orientation, age, family/parental status, marital status, veteran status, disability, or other protected status.