Data Analyst

Tillster • Los Angeles, CA

11d • €70,000 - €85,000

About The Position

The Data Analyst is a mid-level individual contributor who has moved beyond supervised execution and is developing the independence, analytical depth, and stakeholder skills needed to progress to Senior level. The role owns smaller analytical domains end-to-end, contributes to team standards, and proactively surfaces insights.

The analyst delivers work from scoping through analysis, presentation, and stakeholder follow-through; supports ad-hoc analysis and A/B testing; and contributes to GA4 reporting and tracking validation. The role designs and maintains Looker dashboards and Explores, develops documented LookML, contributes to the shared semantic layer, and supports self-service analytics.

The position takes ownership of data accuracy for assigned outputs, investigates discrepancies, writes performant SQL, and collaborates with Data Engineering and Analytics Engineering on data quality, query optimization, pipelines, and semantic-layer needs. It also contributes to coding standards and reviews, supports junior analysts, applies AI and LLM tools to analytics workflows, and actively develops skills in SQL, Python, statistical analysis, and cloud data platforms.

Requirements

• Bachelor's degree in a quantitative field such as Mathematics, Statistics, Computer Science, or Engineering, or equivalent practical experience.
• 2–4 years of experience in a data analytics or BI role.
• Strong SQL skills, including window functions and CTEs.
• At least 2 years of hands-on experience with Looker and LookML development.
• Experience with AWS or Google Cloud data warehouses, such as Redshift or BigQuery.
• Demonstrable experience building dashboards and Explores for non-technical business users.
• Working knowledge of software development best practices, including Git, PR reviews, and code style guides.
• Working knowledge of agile development processes.
• Ability to translate business questions into analytical tasks with growing independence.
• Clear, confident written and verbal communication with business stakeholders.

Nice To Haves

• Exposure to A/B testing concepts and basic experimental design.
• Foundational Python skills for data manipulation or automation.
• Familiarity with GA4 reporting and tracking fundamentals.
• Experience with AI or LLM tools applied to analytics workflows.
• Experience with Linux/OSX command line and Git.
• Understanding of ELT pipeline concepts and cloud data infrastructure.
• Prior experience mentoring or supporting more junior colleagues.

Responsibilities

• Deliver analytical work end-to-end for assigned business areas, from scoping and analysis through presentation and stakeholder follow-through, with minimal re-direction.
• Support ad-hoc analysis for Marketing, Product, Finance, and Account Management, providing interpretive framing alongside data outputs.
• Proactively surface trends, anomalies, and data-driven observations to stakeholders.
• Support A/B test experiments under the guidance of the Senior Data Analyst, including data preparation, metric tracking, and results summaries.
• Support GA4 reporting, tracking plan validation, and custom dimension and metric implementation.
• Develop working knowledge of GA-to-warehouse integration and tagging practices.
• Design, build, and maintain Looker dashboards and Explores for assigned business areas.
• Develop and document LookML dimensions, measures, derived tables, and Explore configurations in accordance with team standards.
• Flag metric definition inconsistencies and propose resolutions with the Senior Data Analyst and Analytics Engineering team.
• Expand self-service analytics for non-technical stakeholders and help reduce ad-hoc request volume.
• Maintain accurate and consistent production Explores and dashboards as warehouse structures evolve.
• Investigate discrepancies in assigned dashboards and analytical outputs, and escalate upstream issues to Data Engineering with root-cause evidence.
• Write performant SQL, including window functions and CTEs, and collaborate with Data Engineers on query optimization and derived table design.
• Develop an understanding of data pipelines feeding owned dashboards to diagnose freshness and quality issues and communicate resolution timelines.
• Collaborate with Analytics Engineers on LookML architecture and semantic-layer requirements.
• Follow and contribute to coding standards, SQL style guides, LookML conventions, documentation requirements, and PR review processes.
• Participate in code reviews and provide constructive, consistent feedback.
• Support Junior Analysts through paired working and direct feedback under the guidance of the Senior Data Analyst.
• Partner with Senior Analysts, Data Engineers, and business stakeholders; clarify questions early and communicate blockers and timelines proactively.
• Use AI and LLM tools to accelerate SQL generation, LookML authoring, documentation, and exploratory analysis.
• Experiment with AI-assisted insight narration and anomaly detection and share learnings with the team.
• Develop familiarity with self-serve analytics agent concepts such as Cortex Analyst or equivalent.
• Develop skills in advanced SQL, Python, statistical analysis, and cloud data platforms.

Benefits

• Medical, dental, vision, and FSA benefits for eligible full-time regular employees and their dependents.
• Healthcare and Dependent Care reimbursement programs.
• Employee Assistance Program (EAP) and Optum Care 24-hour confidential medical counseling services.
• Ten paid holidays per calendar year.
• 15 days of PTO during the first 12 months of continuous service and 22 days in subsequent years for eligible full-time regular employees; eligible part-time employees receive prorated PTO.
• Eligibility to participate in the 401(k) Plan effective with the employment start date.
• College tuition and education assistance programs.
• Udemy Learning courses and ongoing learning and development opportunities.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level