Analytics Engineer

The posting, as Warriorbabe wrote it

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
Database ownership and performance

• 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, relationship

[…]
ce 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.