Data Architecture and Insights Analyst

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 4600 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 .

We are seeking aData Architecture and Insights Analystto 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 systemsidentifygaps 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 planallocateresources and serve our retail and DTC channels effectively.

In the first90 days this person will have developed a clear understanding of Hourglasss data landscapeidentifiedthe most critical data quality gaps andestablishedthemselves 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 YOULL DO:

• Identifyand resolve data quality issues inconsistencies and manual inefficiencies across the organization.
• Build andmaintainclean 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 andmaintainingreliable 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 andoptimizerecurring data and reporting processesidentifyingopportunities to streamline and scale operations.
• Perform validation reconciliation and root-cause analysis when data issues arise ensuring accuracy and consistency across sources.
• Enhance andoptimizevisualizations to improve clarity usability and decision-making for stakeholders at all levels.
• Develop andmaintaindata documentation data dictionaries and process guides to ensure institutional knowledge isretainedand 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

YOULL LOVE THIS JOB IF:

• You are extremelyORGANIZED: You are not overwhelmed by the thought of tackling multiple tasks at a time.
• You areDETAIL ORIENTED: You appreciate the importance of having detailed and precise information.
• You are a strongCOMMUNICATOR: You collaborate well with othersand communicate findings clearly to non-technical stakeholders.
• You areANALYTICALandPROCESS DRIVEN: You have a strong interest in how data systems are structured.
• You areAGILE: You adapt well to changing needs and priorities and are able to pivot easily to achieve goals and deadlines.
• You areCREATIVE: You are innovative and forward-thinking in your approach and mindset.

QUALIFICATIONS:

• Minimum6years of experience in data analysis analytics or business intelligence.
• Strong SQL skills for querying transforming and validating data.
• Proficiencyin 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 ofdatabase 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 todemandplanning inventory management or commercial finance data.

The expected base salary range for this position is $95000 to $110000 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 or .

Equal Opportunity Employer/Veterans/Disabled

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