Data Architecture and Insights Analyst

Hourglass Cosmetics•West Hollywood, CA

23h•Hybrid

About The Position

Hourglass Cosmetics is 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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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