Analytics Engineer

WarriorBabe; Philippines; Remote; PHP 900,000 - 1,800,000; Full time

Benefits offered by this job

Fully remote work

Eastern Time overlap

Career growth opportunities

Job summary

WarriorBabe, LLC is seeking an Analytics Engineer to own the reliability and performance of our Supabase/PostgreSQL database and translate business data into actionable insights. You will maintain data integrations, refresh processes, develop reliable data models, and build Metabase dashboards.

You will partner with leadership to investigate performance, identify opportunities, and recommend measurable actions.

Qualifications

• Own production PostgreSQL or Supabase database and troubleshoot performance.
• Build and maintain reliable data models and dashboards.
• Investigate performance changes and quantify findings.

Responsibilities

• Manage and optimize the Supabase/PostgreSQL reporting database, including tables, views, and queries.
• Diagnose slow queries, blocking, refresh failures, and bottlenecks; prioritize improvements.
• Maintain permissions, review schema changes, and support backups and recovery readiness.
• Plan migrations with clear steps, dependencies, and rollback procedures.
• Evaluate architecture and recommend improvements while preserving reporting continuity.
• Build, maintain, and troubleshoot production n8n workflows for data ingestion and reporting.
• Maintain Fivetran connections and API integrations with clear ownership.
• Work with CRM/ERM systems as required and handle authentication, pagination, and retries.
• Monitor data delivery and freshness, including failures hidden by scheduler status.
• Develop reusable SQL models with clear definitions and relationships.
• Define revenue, clients, conversions, refunds, renewals, retention metrics.
• Reconcile reporting with sources and prevent duplicates in dashboards.
• Document data lineage, metrics, refresh behavior, and procedures.
• Build Metabase dashboards and saved questions with proper filters and drill-throughs.
• Translate stakeholder questions into actionable reporting to support decisions.
• Verify configurations and ensure end users see the intended dashboards.

Skills

SQL proficiency

Data analysis

Business intelligence

Clear communication

Problem solving

AI-assisted development

Tools

PostgreSQL/Supabase

Metabase

n8n

Fivetran

API integrations

Git

Python/JavaScript

Job description

Why WarriorBabe?

At WarriorBabe, we believe in the power of dedication and personal growth. You'll be surrounded by a vibrant team that shares your passion for fitness and helping women flourish. Together, we are on a mission to transform lives and create a community that thrives on empowerment.

Offering personalized macronutrient plans and workout programming, WarriorBabe ensures each woman's unique needs are met. With one‑on‑one coaching, a dedicated mobile app, and a vibrant online community, WarriorBabe provides the tools and support necessary for lasting success. Ideal for women of all ages and fitness levels, WarriorBabe adapts to ensure continuous progress and achievement of fitness goals.

Our Mission

Help 100,000 women regain their personal power and feel confident in their skin.

About The Role

WarriorBabe is seeking an Analytics Engineer who can own the reliability and performance of our Supabase/PostgreSQL database and turn business data into clear, actionable insights.

You will maintain data integrations and refresh processes, develop reliable data models, and build useful Metabase dashboards. You will also work directly with leadership and business teams to investigate performance, explain what is driving results, identify opportunities, and recommend measurable actions.

You will help evaluate and improve our data architecture as the business evolves. We welcome recommendations grounded in business needs, reliability, performance, maintainability, and cost.

Success means keeping the data accurate, current, and well documented—and using it to help the business make better decisions.

Key Responsibilites

• Manage and improve our Supabase/PostgreSQL reporting database, including tables, views, materialized views, indexes, and SQL queries.
• Diagnose slow queries, blocking, failed refreshes, and resource bottlenecks; use evidence to prioritize improvements.
• Maintain appropriate permissions, review schema changes, and support backup and recovery readiness.
• Plan and validate database changes with clear dependency checks, migration steps, and rollback procedures.
• Evaluate the existing architecture and recommend practical improvements while preserving reporting continuity.

Data integrations and n8n

• Build, maintain, and troubleshoot production n8n workflows used for data ingestion, synchronization, and reporting.
• Maintain Fivetran connections and custom API integrations, with clear ownership of each source, writer, destination, and downstream dependency.
• Work with CRM, ERM, and other business systems as required.
• Handle authentication, pagination, rate limits, duplicate events, partial failures, retries, and safe backfills.
• Monitor actual data delivery and freshness, including failures that may be hidden behind a successful workflow or scheduler status.

Data modeling and reporting reliability

• Develop reusable SQL models with clear record definitions, keys, relationships, and treatment of historical changes.
• Maintain agreed definitions for revenue, clients, conversion, refunds, renewals, retention, and other business metrics.
• Reconcile reporting with its underlying sources and distinguish missing data from a verified zero.
• Prevent duplicate counts and inconsistent totals across dashboards, including differences caused by dates, time zones, attribution, or counting rules.
• Document data lineage, metric definitions, refresh behavior, known limitations, and operating procedures.

Metabase dashboards

• Build and maintain Metabase dashboards, saved questions, filters, and record‑level drill‑throughs.
• Translate stakeholder questions into reporting that supports a specific business decision.
• Verify saved configuration and the dashboard users actually see, including filters, totals, drill‑throughs, and links to operational records.
• Maintain documentation alongside analytical dashboards and preserve dependent reports when making changes.

Business analysis and insights

• Proactively analyze acquisition, sales conversion, revenue, refunds, renewals, retention, and coaching performance.
• Investigate performance changes by relevant cohorts, products, channels, teams, and time periods.
• Distinguish business changes from data‑quality problems and clearly separate evidence, hypotheses, and remaining uncertainty.
• Present findings with their business impact, recommended action, and a practical way to measure the result.
• Partner with business owners to evaluate whether actions taken improved outcomes.

AI-assisted development and analysis

• Use AI tools such as Claude or OpenAI to accelerate SQL development, data modeling, n8n workflow design, troubleshooting, documentation, and business analysis.
• Use AI to explore patterns, develop hypotheses, review queries and calculations, and identify potential errors or edge cases.
• Validate AI-generated code, calculations, and conclusions against source data and reproducible checks before deploying changes or presenting findings.
• Protect confidential information and protected health information (PHI) when using AI, following company policies and using approved tools.

Qualifications

• Hands‑on ownership of a production PostgreSQL or Supabase database, including troubleshooting and performance optimization.
• Strong SQL skills, including joins, CTEs, window functions, aggregation, query plans, and indexing.
• Practical experience building and troubleshooting production n8n workflows. Be prepared to explain a workflow you personally implemented and how it handled failures.
• Experience with API integrations, webhooks, authentication, pagination, rate limits, and reliable synchronization.
• Experience with Metabase or a comparable BI platform, with the ability to work hands‑on in Metabase.
• Demonstrated ability to investigate business performance, quantify findings, and recommend actions.
• Practical experience using AI tools such as Claude or OpenAI to build, improve, analyze, and check work, with the ability to explain and independently verify the results.
• Ability to explain technical issues and business conclusions clearly to nontechnical stakeholders.
• Experience using Git and maintaining clear technical documentation and controlled production changes.

Preferred Experience

• Working knowledge of HIPAA and the privacy and security considerations involved in handling protected health information (PHI) across databases, integrations, and reporting.
• CRM and ERM data structures, relationships, and integrations.
• Fivetran configuration and monitoring.
• Payment, subscription, refund, renewal, or customer‑retention reporting.
• Python or JavaScript for scripting and automation.
• Experience with Metabase for understanding and reconciling existing reports.

What Success Looks Like

• Business teams can understand what key metrics mean and trace results to supporting records.
• Data integrations and reporting refreshes operate within agreed freshness and completeness expectations, with actionable monitoring.
• Database and dashboard improvements have documented validation and preserve dependent reporting.
• Leadership receives useful explanations and recommendations, with follow‑up on the actions taken.
• Architecture recommendations include their benefits, tradeoffs, costs, and a practical implementation path.

Why Join Us

• Fully remote work with flexibility and Eastern Time overlap.
• Ownership across the database, integrations, reporting, and business analysis.
• Direct collaboration with business leaders and the opportunity to influence decisions.
• An environment that values precision, clear communication, and practical improvements.