Data Architecture and Insights Analyst

Hourglass Cosmetics•West Hollywood, CA

15h•Hybrid

About The Position

Hourglass Cosmetics is seeking a Data Architecture and Insights Analyst to enhance data quality, structure, and analytical processes across the organization. This role is crucial for enabling reliable reporting and improving decision-making, particularly for finance, demand planning, commercial teams, and cross-functional operations. The individual will manage data flow between systems, identify data gaps and inefficiencies, and develop scalable datasets and reporting infrastructure. As Hourglass expands, accurate and integrated data is fundamental for planning, resource allocation, and effectively serving retail and direct-to-consumer channels. In the initial 90 days, the analyst will gain a comprehensive understanding of Hourglass’s data landscape, pinpoint critical data quality issues, and establish credibility with Finance, Demand Planning, Commercial Sales, and IT. Within six months, they are expected to improve the reliability of key reports and begin automating and documenting routine 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