Data Analyst

Osea Los Angeles , CA 90001

Posted 2 weeks ago

Join our fast growing beauty brand and become a fundamental member of our expanding team. At OSEA Malibu, we are always looking to apply the power of data-driven insights to more efficiently manage and accelerate the growth of our business. Our Data Analyst will be central to this and a critical role in the company. This role will have interaction with all functional areas of the business (Sales, Finance, Operations, Marketing and Product Development) and focus on generating both backward and forward looking data insights to help support a majority of our business decisions. The ideal candidate will additionally share our commitment to wellness in both our products and work-life balance. Our mission is to create effective, results-driven skincare that is safe for the planet and humankind.

Key Responsibilities:

  • Demand Planning
    • Develop demand forecasts at multiple levels (i.e. Per Customer, Per Channel, etc).
    • Review historical sales trends, research demand drivers (i.e. Customer POS data, industry trends, etc) and evaluate forecast accuracy on a continual basis.
    • Coordinate cross-functional research activities to reconcile significant variances and refine the model(s) to reflect updated sales and marketing assumptions.
    • Utilize a collaborative approach with Sales, Marketing and Finance to ensure that current and accurate information is driving the demand forecast.
    • Provide input to Operations and Sales to collaboratively develop inventory strategies on existing items, new products and product exits.
  • Generalized Reporting
    • Manage and help create all monthly KPI reports/Dashboards.
    • Update current reports on the prescribed frequency and generate key insights/takeaways that key stakeholders should be aware of.
    • Work to automate and simplify current reports as much as possible to drive to real-time visibility where it makes sense.
    • Learn the various systems utilized by each functional area (i.e. ERP, Google Analytics, Shopify, Quickbooks) and work within them to generate actionable reporting and insights that can be used by key stakeholders to drive the business.
    • Make suggestions on future reporting needs, systems and strategies to ensure we have accurate, well organized and clean data.
  • Finance
    • Aid in the development and maintenance of a rolling 3-year financial model for the company.
    • Help the various functional areas develop business cases around key investments or revenue generating initiatives.
    • Regularly review and analyze how our products pricing impacts sales velocity with an eye on margin. Make recommendations to suggested changes that align with company goals.
  • Visibility
    • Facilitate and manage demand planning for customer meetings to achieve ongoing consensus between the business and the supply chain.
    • Publish data to the key functions on at the right frequency to ensure each team has what they need to do their job.


  • 4 year degree preferred
  • Interest and enthusiasm for health, wellness and beauty and keeping up with trends in the industry
  • Enjoy solving problems. You love taking on difficult challenges and finding creative solutions. You dont get flustered easily. If you dont know the answer you dig until you find it, or until you have enough evidence to make a strong recommendation.
  • Highly proficient in Microsoft Excel, Statistics, Forecasting and Forecasting Methods, SQL and CSV.
  • You have a strong knowledge in the following areas:
    • Demand planning software
    • Google Analytics
    • Cordial
    • Shopify
  • Have a strong understanding of the KPIs in retail.
  • Have experience with business and revenue modeling techniques.
  • Have an ability to conduct a cost/benefit analysis.
  • Are experienced in developing business cases.
  • Have great attention to detail and organization.
  • Have excellent written and verbal communication that enables you to work collaboratively across functions.
  • Must be willing to fall in love with our products, work in a collaborative environment and most importantly have fun while we work.


Medical, dental and vision insurance, generous vacation benefits, 401k, facials, team lunches and more!

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst


Posted 3 weeks ago

VIEW JOBS 10/4/2020 12:00:00 AM 2021-01-02T00:00 Shopkick, the leading multi-chain shopper rewards app, is looking for a Data Analyst who will provide insights to our most important clients, use data analysis to improve the Shopkick app/product, and bring an analytical perspective to teams across the company. We are actively seeking candidates who combine both the baseline technical skills required (see below) with strong "soft" abilities, including communication, influence, presentation, and prioritization. This role will provide the right candidate with an unusually broad level of influence at Shopkick and exceptionally strong opportunities for growth. The Data Analyst will be responsible for: * Developing dashboards and reporting to support revenue teams as needed * Attending "live" (zoom) meetings with sales teams, clients, and Marketing to represent Shopkick from an Analytics perspective * Using SQL, Python, Excel, and/or other BI tools to answer ad-hoc questions about client campaign performance. * Creating custom analysis of the Shopkick user base to generate insights about user growth and retention * Driving increased user retention and lower cost-per-activation, in concert with Marketing * Constructing and oversee A/B/* experiments as part of Shopkick's "test-and-learn" culture * Creating benchmarks and other aggregate insights that would be of interest to key clients, the press, and other external partners * Creating, measuring, and documenting KPIs that will drive focus across the business Preferred Qualifications * Bachelor's Degree or higher in a quantitative field (Math, Computer Science, Engineering, Data Analysis, etc.). * Ability to create intermediate-level SQL, from scratch, including table joins, subqueries, and basic window functions (rank, row_number, etc.). * Understanding of data visualization best-practices and significant experience in at least one tool through which that understanding can be expressed (Excel, Tableau, Python / matplotlib or other visualization libraries, etc.) * Experience with one or more data visualization / dashboarding tools, esp. Sisense / Tableau / PowerBI / etc. * Ability to construct intermediate level Python or R code to assist with data cleaning, transformation, analysis, or visualization * Interest in "both sides" of our business, including how to make the user's in-app experience better and how to improve service and performance for our advertising clients * Ability to translate analytical results to a data-supported story; excellent written and oral communication skills * Interest in digital advertising; understanding of advertising principles * 2+ Years of experience in a similar role A Plus If You: * Have experience with Google BigQuery or other columnar data store (Vertica, etc.) or "big data" technologies * Have experience with JIRA/Confluence * Have a Master's Degree in a related field * Have experience with common 3rd party event-based analytics packages, such as Google Analytics, Amplitude, or Mixpanel * Have experience with advertising campaign analysis * Have experience with app user analytics * Have comfort with statistical analysis (i.e. can prove that differences in outcomes are statistically significant at a target level) * Have Stephen Few, Cole Nussbaumer Knaflic, or Edward Tufte on your bookshelf Any unsolicited resumes/candidate profiles submitted through our website or to personal email accounts of employees of Shopkick are considered property of Shopkick and are not subject to payment of agency fees. Shopkick Los Angeles CA

Data Analyst