Data Analyst

Beautifully comprehensive skin care takes a deeper commitment. As a privately held, fully integrated global skincare company, Crown Laboratories is dedicated to developing and providing a diverse portfolio of safe and effective scientific solutions for life-long healthy skin. Our three business units, aesthetics, premium beauty, and therapeutic skincare products demonstrate Crown’s mission of Skin Science for Life, which is the foundation of our commitment to partnering with consumers throughout their skin health journey, giving skin what it needs to be its healthiest and best, at every age.

Crown Laboratories, Inc. is currently recruiting for a Data Analyst. The Data Analyst plays a key role in helping the organization understand its business through the analysis of various data sources. Supporting the commercial operations teams and enabling quicker and smarter business decisions to be made.

Primary Responsibilities:

• Migrate former data platforms and integrate data into useful data warehouses for cohesive reporting and one source of truth for Skincare divisions
• Build efficient ETL processes from a variety of sources to support the weekly dashboard reporting
• Conduct ad-hoc and routine analysis on product sales and promotional activity with appropriate communication to key stakeholders
• Using Syndicated Market data (IRI/Nielsen/SPINS) build and maintain reporting dashboards that detail the competitive dynamics of the marketplace.
• Maintain and distribute daily sales reports; tracking performance against company goals and targets
• Query and analyze datasets using tools such as SQL Server, Excel, Power BI; identify opportunities for improvements/enhancements

Job Related Qualifications / Skills:

• Bachelor’s degree in a quantitative field such as Business Analytics, Business Administration, Finance
• Must have thorough experience working in Excel at an advanced level (Formulas, Data Modeling, Power Query)
  • Experience with other Analytical tools such as SQL Server and Power BI is preferred
• Strong analytical and problem-solving skills
• Understanding of consumption data; working with Syndicated data through Nielsen or IRI is a plus
• Strong written and oral communication skills, ability to convey technical information to a non-technical group
• Ability to present and lead meetings, facilitate discussions amongst commercial teams

NOTE: This job profile is intended to provide an overview of expected job duties and requirements. It is not intended to be a contract of employment, explicit or implicit. All contents are subject to change at the sole discretion of the company. Cooperation is expected of all employees. Other duties may be assigned as needed.

Equal Opportunity Employer

Learn more about the Crown family of products:

Crown Therapeutics: maker of PanOxyl®, the #1 acne wash; Blue Lizard® Australian Sunscreen, the #1 Pediatrician recommended mineral-based sunscreen brand; and Sarna®, the #1 Dermatologist recommended topical anti-itch brand and National Seal of Acceptance from the NEA, and more.

Crown Premium Skincare: includes StriVectin, comprised of a broad range of award-winning skincare solutions for all skin types, tones, and ages; and Vita Liberata, a multiple award-winning sunless tanning brand.

Crown Aesthetics: maker of SkinPen®, the first FDA-cleared micro needling device

Crown Laboratories does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies in response to job postings. No fee will be paid to third parties who submit unsolicited candidates directly to our hiring managers. All candidates must be submitted by approved Crown Laboratories vendors who have been expressly requested to make a submission by our HR team for a specific job opening. No placement fees will be paid to any firm unless such a request has been made by the Crown Laboratories HR team and such candidate was submitted to the Crown Laboratories HR team.