BODi, a leader of in-home fitness programs and nutritional products, is on the lookout for top-notch talent. We’re an equal-opportunity employer who offers competitive compensation and incredible incentive opportunities, filled with smart, friendly people and positive energy. Are you ready to help us achieve our goal of helping people live healthier, more fulfilling lives? Read on.
 
Why is the Data & Analytics team important to BODi?

The Data & Analytics team (DNA) works closely with departments across the organization to utilize our rich data assets to drive strategic business decisions and enable an optimal consumer experience across all our platforms. Our goal is to extract actionable insights to increase business performance and leverage customer behavioral data to develop capabilities that help enhance our ability to attract, engage and retain digital subscribers. We utilize leading data science and advanced analytics techniques to influence acquisition channels, subscriber retention strategies, product development and personalization. The DNA team provides functional expertise across an end-to-end data and analytics ecosystem that consists of strategic analytics, business intelligence, cloud data infrastructure, data architecture and engineering, data product management, consumer & marketing analytics, product analytics and data science. Together we unleash the power of data to help our customers achieve their fitness and nutrition goals to enjoy a healthy, fulfilling life.
 

Role Description
As a Lead Analyst, BI and Business Strategy Analytics, you will be responsible for preparing data for providing insights and strategy by analyzing the data. You will do analysis and visualization, from consulting with data engineering to understand the flow of data, through our ELT process modeling our data warehouse, to the BI tools that our business teams use to gain insights. You’ll work directly with stakeholders and with leaders in data to understand their needs, plan and execute changes to our data models, and evangelize the effective use of that data. You bring software engineering best practices to production and maintenance of analytics code and bring an engineering mindset to discussions on how data is modeled from its source to its use in
the data warehouse as business data & reporting data. You are analytic and bring structure in your work, you champion consistency and predictability and you are self-driven and motivated. You enjoy making a data warehouse clean and usable. You guide others in the understanding of the data. You are naturally able to collaborate with data engineers, data analysts, software engineers as well as product & business people. You are an expert at SQL, can write complex queries in snowflake and can use Python to automate your analytics work. You can create visualization with tools like Tableau and can tell story with data. If you’re an individual who thrives in a fast-paced environment and wants to help build a best-in-class data analytics practice from the ground up, then this is the role for you.

This role will support the growing portfolio of products at BODi, including Beachbody on Demand, Shakeology, Performance Line Tasks and Responsibilities:

• Conducts in-depth analysis of customer behavior to identify trends, patterns and opportunity for growth, sharing critical insights with the leadership team in regular team meetings

• Conducts data analyses on CRM campaign performance, paid media channels performance

• Presents insights in leadership meetings, performs forecasting for paid media, CRM channels, analyze performance of paid media, CRM and affiliate channels

• Works with SVP and VPs of individual channels on channel strategy by analyzing data to increase revenue on these channels to meet the target

• Capture business requirements for analytics and translate complex ones into technical requirements. Collaborate with data engineers to design & implement end-to-end solutions

• Build reports, dashboards, models and tools to analyze and present operations related data that is associated with customer pipeline, product usage, forecasting and business productivity.

• Build queries based on business requirements and reports/dashboards; set up and maintain and refresh accurate data based on business requirements

• Analyze data, perform source to target mapping to business needs, identify discrepancies in data, transform and summarize data to build visualization

• Maintain existing dashboards and help in production support

• Collaborate with architects and engineering teams to optimize queries for performance and efficiency

• Work with business stakeholders; demonstrate product built and train them to use the data/visualizatio

• Define and align common KPIs across multiple functional groups (marketing, commerce, operations) and business objectives (acquisition, sales, engagement, retention, digital).

• Ensure data provided in reports and dashboards are highly accurate and reliable for critical reporting and decision making

• Document reports implementation, issues and business logic. Create end user documentation

• Assist new users and business partners with onboarding, onboarding, troubleshooting and orientation.

• 6 years of full-time work experience as a Strategy data analyst, BI Visualization analyst, data analyst, data engineer or software engineer.

• Hands-on experience with data model development and reporting in data visualization tools such as Tableau, Data Studio, DOMO, and familiar with spreadsheets (Excel, Sheets).

• Minimum 3 years of analytics experience with mastery SQL and query optimization experience.

• Experience using DBT in production cloud data warehouse environment, Snowflake or Big Query is a big plus.

• Hands on experience with Snowflake

• Excellent story telling skills with data and can provide business insights

• Excellent analytical and problem-solving skills, combined with strong business judgement and an ability to present analysis in a clear and compelling manner.

• Proactive mind set with a strong sense of ownership.

• Excellent verbal and written communications skills with the ability to clearly present ideas, concepts, and solutions

• Quick learner both in terms of new technical skills and acquiring domain knowledge.

• Strong understanding of data warehouse, relational and columnar databases.

• Experience with email marketing, paid media channels and Affiliate marketing

Experience and Skills (Plus):

• Deep understanding of best practices around marketing, e-commerce, email marketing, paid media management and subscription retention KPIs, is a huge plus

• Highly skilled in SQL, manipulating multiple data formats (CSV, XML, JSON), Software engineering experience with hands-on experience automating tasks with scripting (Python would be perfect).

• Experience with API data integration analysis and data preparation.

• Experience with processes to transform data in data warehouse, set up and schedule jobs, such as DBT, Python, Airflow.

• Experience in using Python and R for statistical modelling and creating machine learning models will be a plus.