Data Solutions Architect

Role Description

Reporting to the VP of Strategy, Insights & Analytics, we are seeking a Data Solutions Architect to serve as the primary architect and guardian of our enterprise data ecosystem and the primary liaison between Analytics/SIA and Technology.

• Own the architecture and evolution of MANSCAPED’s Snowflake environment.
• Establish and enforce data modeling standards across core business domains.
• Design schemas, datasets, and views that support BI, analytics, reporting, and future AI-enabled use cases.
• Develop and maintain complex SQL queries, stored procedures, and performance-optimized data structures.
• Optimize Snowflake performance, warehouse utilization, and cost management.
• Approve schema changes, RBAC changes, Snowflake architecture changes, and material pipeline modifications, with appropriate oversight and cross-functional alignment.
• Define and implement the enterprise RBAC model within Snowflake across business functions, ensuring sensitive data assets are secure, governed, and accessible to the right audiences.
• Partner with Technology, Infrastructure, Security teams, and Analytics stakeholders on identity management, access provisioning, Microsoft Entra ID integration, and enterprise data governance.
• Establish standards for row-level security, masking policies, PII handling, access reviews, and permission-aware data availability.
• Proactively surface risks related to access, governance, data quality, and warehouse spend.
• Design and oversee data pipeline architecture standards, partnering with Technology on production operations, SLAs, and system reliability to ensure high-integrity movement of data across systems.
• In partnership with Snowflake and Daasity, serve as the Analytics-side technical lead for ETL/ELT requirements, transformation logic, and source-to-target data mapping.
• Collaborate with Technology, SaaS vendors, and application teams to ensure downstream data is reliable and reporting-ready, supporting integration of platforms including Shopify, NetSuite, Amazon, 3PL/WMS, and other business critical systems.
• Partner with the BI team to ensure Snowflake data models and governed datasets are optimized for Looker development and self-service reporting and the BI-owned semantic layer.
• Help create “Single source of the Truth” by grounding core metrics in consistent, trusted, and well-documented data structures.
• Translate recurring business questions into reusable data products that support executive reporting, forecasting, channel analysis, product performance, and strategic planning.
• Ensure data is accessible through traditional BI reporting and future AI-assisted workflows.
• Establish and maintain technical architecture standards, source-to-target mapping, and data dictionaries and observability standards across critical pipelines and data sets.
• Implement automated validation frameworks and reconciliation checks, with transparent documentation that reduces tribal knowledge and builds confidence in core datasets.
• Partner with Analytics, BI, Technology, and business stakeholders to define ownership, lineage, and usage rules for critical data assets.
• Collaborate with Finance, Marketing, DTC, Retail, Operations, Product, Customer Experience, and Executive Leadership to understand current and future data needs.
• Communicate complex technical issues clearly across audiences, balancing speed, governance, and scalability in all decisions.
• Advise the VP of Strategy, Insights & Analytics on risks/dependencies, roadmap tradeoffs, resourcing, and long-term data architecture priorities, balancing internal and external transformation resources to meet business timelines.
• Other duties as required.

Qualifications

• 10+ years of experience in data architecture, analytics engineering, data warehousing, data platform leadership, or enterprise data solutions.
• Deep hands-on experience with Snowflake, including architecture design, schema development, performance optimization, RBAC, views, SQL, and stored procedures.
• Strong experience building and scaling modern data warehouse and ETL/ELT environments.
• Experience designing robust data models for BI, analytics, executive reporting, and cross-functional business use.
• Proven ability to establish data governance, access control, and data quality frameworks in complex business environments.
• Experience partnering with Technology, Security, Infrastructure, BI, and business teams.
• Strong understanding of data pipeline architecture, source-system mapping, transformation logic, and downstream reporting needs.
• Familiarity with AI-ready data architecture, natural-language query interfaces, or AI-assisted analytics workflows.
• Experience with consumer, Ecommerce, retail, marketplace, subscription, wholesale, or omnichannel data environments.
• Strong analytical, debugging, and problem-solving skills.
• Ability to simplify complex technical topics for non-technical stakeholders.
• Excellent communication, stakeholder-management, and cross-functional leadership skills.

Benefits

• Enjoy a generous 20 accrued vacation days per year to relax, travel, and spend quality time with your loved ones.
• We provide 40 hours of paid sick leave annually, ensuring you can take the time you need to recover.
• Take 3 paid mental health days to recharge and take care of your emotional well-being.
• We offer 9 paid holidays throughout the year to give you the opportunity to celebrate important moments and take a break from work.
• Our plan helps you take care of your furry family members, giving you peace of mind.
• Access comprehensive medical, dental, and vision insurance plans, along with Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA).
• Our confidential Employee Assistance Program offers resources to help you navigate life's challenges.
• Enrollment in our accident and critical illness plans can provide financial support during the most difficult of times.
• We offer an employee 401(k) plan and company match.
• You will receive a monthly utility allowance to help cover the costs of Wifi and phone usage.
• Enjoy a generous discount on our products as part of our employee discount program.
• Participate in our exciting wellness challenges designed to promote a healthy and active lifestyle.
• We offer paid parental leave to support you during a pivotal time in your life.
• Our regular recognition initiatives ensure you are acknowledged for your hard work and achievements.
• We offer one paid volunteer day per year, allowing you to support a cause that means the most to you.
• We are a certified Great Place to Work, growing rapidly and offering incredible opportunities for advancement.

Compensation Range

$170,000 — $180,000 USD