Data Analytics Engineer III

Summary

Join the MyFitnessPal Data Engineering team as a skilled Analytics Engineer and make a positive impact on users' health and fitness journeys. You will bridge the gap between engineering and analytics, focusing on creating reliable data models. A critical aspect is leading data quality and governance efforts, supporting the long-term strategy. You will collaborate with the Data Platform team to enhance capabilities and efficiency, conduct ad hoc analysis, and support business teams with self-service analytics. This role requires expertise in data modeling, QA/QC processes, SQL, Python, and data warehousing. The ideal candidate is a self-starter, problem-solver, and strong collaborator.

Requirements

• Experience with dbt and modern data modeling practices (e.g., Kimball, Inmon frameworks)
• Proven expertise in implementing and maintaining QA/QC processes for data pipelines, including automated testing and anomaly detection
• Proficiency in SQL and development languages like Python
• Ability to lead both day-to-day efforts and contribute to the long-term data governance strategy
• Strong problem-solving skills and a self-starter mindset, capable of independently driving projects to completion
• Ability to perform ad hoc analysis and data investigations with an engineering mindset, ensuring efficiency and reproducibility
• Experience with data warehouses like Snowflake or relational databases such as MySQL
• Understanding of data governance principles, including data lineage, access policies, and quality frameworks
• Experience with Airflow or similar orchestration tools for managing ETL/ELT pipelines
• Familiarity with API integration and design patterns, including REST
• Proven ability to develop scalable, high-volume data pipelines for downstream analysis and operational indicators
• Experience triaging and resolving production data issues
• Knowledge of data at scale and experience with data validation frameworks
• Familiarity with AWS or other cloud computing platforms

Responsibilities

• Lead day-to-day efforts to ensure data quality, governance, and reliability, while driving long-term data governance strategy across the organization
• Design and implement automated data quality assurance (QA) and quality control (QC) processes to ensure accurate, consistent, and complete data, monitor data workflows and resolve anomalies or inconsistencies in production pipelines
• Develop and maintain data validation frameworks and testing strategies for pipelines and transformations, identifying and addressing issues proactively
• Conduct ad hoc analysis and investigations with an engineering mindset, delivering actionable insights to support partner stakeholder teams and cross-functional initiatives
• Work closely with the Data Platform team, contributing to the continuous improvement and scalability of the organization’s data infrastructure. Evaluate and improve existing pipelines, data models, and processes to provide more scalable and efficient solutions
• Support business teams by enabling self-service analytics and providing training on data tools and workflows. Integrate with services and systems across MyFitnessPal engineering teams to ensure a seamless flow of data. Collaborate with data scientists, analysts, and business teams to ensure data models meet analytical and operational needs
• Interact with stakeholders to define and document technical requirements for data pipelines, transformations, and integrations

Preferred Qualifications

• Experience with data visualization tools (e.g., Tableau, Looker, Power BI)
• Knowledge of Python frameworks for analytics engineering or automation
• Familiarity with data privacy regulations like GDPR and CCPA

Benefits

• Healthcare
• Parental planning
• Mental health benefits
• Annual performance bonus
• A 401(k) plan and match
• Responsible time off
• Monthly wellness and technology allowances
• Face-to-Face Connections
• Flexible time-off policy and work on your own terms with our Responsible Time Off benefit
• 2 volunteer days off per calendar year
• Mentorship Program
• Paid maternity and paternity leave
• Comprehensive assistance for fertility-related matters
• Monthly Wellness Allowance
• Reward and recognition platform
• MyFitnessPal Premium
• Virtual learning and development library, and participate in training opportunities
• Competitive medical, dental, and vision benefits
• Retirement savings program
• Competitive employer match