Senior Analytics Engineer - Data Platforms (Remote)

OneClick Code; Mexico; Remote; MXN 1,071,000 - 1,236,000; Full time

Benefits offered by this job

Paid time off

US holidays

Medical coverage reimbursement

Job summary

OneClick Code is seeking a Senior Data & Analytics Engineer to own the reliability and evolution of its analytics infrastructure, including data models, data warehouse, pipelines, and billing data. You’ll translate business needs into analytics initiatives, drive definitions, and deliver measurable outcomes.

You will lead design of robust data models, optimize SaaS metrics, and ensure accurate tracking across web and native apps.

Qualifications

• 5+ years in analytics engineering or data-focused roles, preferably in a SaaS environment.
• Strong SQL for advanced querying, modeling, and performance optimization.
• Proficiency with Python for data analysis and automation.
• Experience designing, building, and maintaining databases, data warehouses, ETL/ELT pipelines, and integrations across multiple systems.
• Experience with cloud data infrastructure; AWS experience is preferred.
• Strong understanding of SaaS metrics (MRR, churn, CAC, LTV, retention).

Responsibilities

• Design, build, and maintain scalable analytics data models to support business reporting and decision-making.
• Build, maintain, and troubleshoot ETL/ELT pipelines and data transformations.
• Own source-of-truth definitions and reconcile data across application, billing, and analytics systems.
• Own the structure and optimization of SaaS metrics, including subscription lifecycle, billing, churn, retention, LTV, and revenue analytics (Stripe).
• Ensure data integrity, consistency, and governance across systems.
• Monitor data flows and proactively detect, troubleshoot, and recover from pipeline failures or missing data.
• Partner with Engineering to assess the data impact of product releases and prevent breaking changes to collection systems.
• Define tracking specifications and lead auditing of event strategy across web/native apps; improve reliability of user event data (Segment, Mixpanel).
• Perform advanced analysis using SQL and Python to generate actionable insights; identify trends, risks, and growth opportunities in SaaS metrics.

Skills

SQL

Python

Data modeling

ETL/ELT

Data warehousing

AWS

SaaS metrics

Tools

Looker/Tableau/Power BI

Amplitude

Stripe analytics

Job description

OneClick Code is seeking a Senior Data & Analytics Engineer to own the reliability and evolution of its analytics infrastructure, including data models, data warehouse, pipelines, and billing data. You’ll translate business needs into analytics initiatives, drive definitions, and deliver measurable outcomes.

You will lead design of robust data models, optimize SaaS metrics, and ensure accurate tracking across web and native apps.