Data Architecture and Insights Analyst

Hourglass Cosmetics; West Hollywood (CA); Hybrid; USD 95,000 - 110,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Retirement savings plan with company‑m

Paid holidays

Discretionary vacation time

Job summary

Hourglass Cosmetics is seeking a Data Architecture and Insights Analyst to improve data quality, structure, and analytical processes across the organization. This role supports Finance, Demand Planning, Commercial Sales, and IT to enable reliable reporting and informed decision making.

In this hybrid role, you will own data flows between systems, evolve the Power BI environment, and automate recurring processes.

Qualifications

• 6+ years of experience in data analytics, analytics, or business intelligence.
• Strong SQL skills for querying, transforming, and validating data.
• Proficiency in Excel for data validation, reconciliation, and analysis.
• Experience with Power BI, including data modeling and cross-source integration.
• Demonstrates practical use of AI-assisted tools (Copilot, ChatGPT, Claude).
• Ability to communicate data findings clearly to non-technical stakeholders.
• Must be able to work from Corporate Office at least 60% of the time.

Responsibilities

• Identify and resolve data quality issues and inefficiencies across the organization.
• Build and maintain clean, well-structured data tables for reporting and analysis.
• Own and evolve the Power BI environment with dashboards and reports for leadership.
• Support forecasting, sell-through analysis, and inventory reporting with reliable datasets.
• Review and understand data sources and workflows across ERP and planning platforms.
• Automate recurring data and reporting processes to scale operations.
• Perform validation, reconciliation, and root-cause analysis for data integrity.
• Develop and maintain data documentation, dictionaries, and process guides.
• Collaborate with Finance, Demand Planning, IT, and Commercial on evolving data needs.

Skills

SQL

Excel

Power BI

AI tools

Data analysis

Cross-functional collaboration

Communication

Attention to detail

Tools

ERP systems (NetSuite/SAP)

Job description

HOURGLASS COSMETICS — Data Architecture and Insights Analyst (Hybrid Role)

Connected by creativity and driven by purpose. Hourglass Cosmetics is a vegan and cruelty‑free beauty brand, redefining luxury cosmetics with high‑performance products, innovative formulas, and award‑winning franchises. Recognized by Forbes, Fast Company and Time Magazine as one of the most inventive beauty companies, Hourglass leads the industry with its breakthrough products and its commitment to animal welfare. Founded in 2004, Hourglass is globally available in 32 markets and over 4,600 doors including Sephora, Ulta, Neiman Marcus, Selfridges, Space NK and more. Hourglass became part of the Unilever Prestige division in 2017. Discover more about the Hourglass brand story and mission on our website hourglasscosmetics.com.

We are seeking a Data Architecture and Insights Analyst to improve data quality, structure, and analytical processes across the organization. This role is central to enabling reliable reporting and better decision‑making — particularly in support of finance, demand planning, commercial teams, and cross‑functional operations.

This person will own how data flows between systems, identify gaps and inefficiencies, and build scalable datasets and reporting infrastructure. As Hourglass continues to grow, the accuracy and integrity of our data is foundational to how we plan, allocate resources, and serve our retail and DTC channels effectively.

In the first 90 days, this person will have developed a clear understanding of Hourglass’s data landscape, identified the most critical data quality gaps, and established themselves as a trusted partner to Finance, Demand Planning, Commercial Sales, and IT. Within six months, they will have improved the reliability of key reporting outputs and begun systematically automating and documenting recurring processes.

What You’ll Do

• Identify and resolve data quality issues, inconsistencies, and manual inefficiencies across the organization.
• Build and maintain clean, well‑structured data tables used for reporting and downstream analysis.
• Own and evolve the Power BI environment, including data models, dashboards, and reports used by leadership and cross‑functional teams.
• Support demand planning and commercial finance functions by building and maintaining reliable datasets for forecasting, sell‑through analysis, and inventory reporting.
• Review and understand existing data sources, structures, and workflows across systems, including ERP and retail planning platforms.
• Automate and optimize recurring data and reporting processes, identifying opportunities to streamline and scale operations.
• Perform validation, reconciliation, and root‑cause analysis when data issues arise, ensuring accuracy and consistency across sources.
• Enhance and optimize visualizations to improve clarity, usability, and decision‑making for stakeholders at all levels.
• Develop and maintain data documentation, data dictionaries, and process guides to ensure institutional knowledge is retained and workflows are reproducible.
• Manage multiple concurrent requests and projects, setting clear expectations with stakeholders on timelines and priorities.
• Collaborate with cross‑functional teams — including Finance, Demand Planning, IT, and Commercial — to support evolving data needs.
• Perform other job‑related duties as assigned.

You’ll Love This Job If

• You are extremely ORGANIZED: you are not overwhelmed by the thought of tackling multiple tasks at a time.
• You are DETAIL ORIENTED: you appreciate the importance of having detailed and precise information.
• You are a strong COMMUNICATOR: you collaborate well with others and communicate findings clearly to non‑technical stakeholders.
• You are ANALYTICAL and PROCESS DRIVEN: you have a strong interest in how data systems are structured.
• You are AGILE: you adapt well to changing needs and priorities and are able to pivot easily to achieve goals and deadlines.
• You are CREATIVE: you are innovative and forward‑thinking in your approach and mindset.

Qualifications

Required

• Minimum 6 years of experience in data analysis, analytics, or business intelligence.
• Strong SQL skills for querying, transforming, and validating data.
• Proficiency in Excel for data validation, reconciliation, and analysis.
• Experience with Power BI, including data modeling and understanding how data connects across sources.
• Demonstrates practical working knowledge of AI‑assisted tools (such as Microsoft Copilot, ChatGPT, or Claude) to support data work, research, and task efficiency — with the ability to use these tools iteratively and critically as part of day‑to‑day workflows.
• Strong attention to detail and a genuine commitment to data accuracy and integrity.
• Understanding of database concepts and data pipelines.
• Ability to communicate data findings clearly to non‑technical stakeholders, including Finance, Commercial, and Operations teams.
• Demonstrated ability to work cross‑functionally and manage competing priorities in a fast‑paced environment.
• Must be able to work from Corporate Office at least 60% of the time.

Preferred

• Familiarity with ERP or retail planning systems (e.g., NetSuite, SAP, or similar).
• Experience working in a consumer goods, beauty, or retail environment.
• Exposure to demand planning, inventory management, or commercial finance data.

The expected base salary range for this position is $95,000 to $110,000 per year. The exact base salary is determined by various factors including experience, skills, education, geographic location, and budget.

This position is also eligible for participation in the company discretionary bonus plan, based on personal performance and company results.

In addition to base salary, Hourglass Cosmetics offers a competitive benefits package to eligible employees, including medical insurance, dental insurance, vision insurance, life insurance, accident insurance, critical illness insurance, disability insurance, retirement savings plans and company match, paid family leave, education‑related programs, paid holidays, discretionary vacation time, and more.

Hourglass is an organization committed to diversity and inclusion to drive its business results and to create a better future every day for its diverse employees, global consumers, partners and communities. If you are an individual with a disability and need accommodation in order to apply for a job listing, please contact us at 310‑392‑7799 or [e-mail].

Equal Opportunity Employer/Veterans/Disabled

Applicants and employees are protected from discrimination under Federal law. For more information, please see Know Your Rights.