Data Architecture and Insights Analyst

About the role

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.

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.

Qualifications

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

Benefits

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.