Data Analyst

Hourglass Cosmetics

Data Analyst improving data quality and analytical processes at Hourglass Cosmetics. Responsible for reporting accuracy and reliable data infrastructure in a rapidly growing company.

Posted 4/24/2026full-timeWest Hollywood • California • 🇺🇸 United StatesMid-LevelSenior💰 $95,000 - $110,000 per yearWebsite

Tech Stack

Tools & technologies

ERPSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisSQLExcelPower BIdata modelingdata validationdata reconciliationroot-cause analysisdata documentationdata pipelines

Soft Skills

attention to detaildata accuracycommunicationcross-functional collaborationproject managementprioritizationproblem-solvingcritical thinkingadaptabilitystakeholder management