Data Solutions Architect
MANSCAPED · United States · 2 wk ago
RemoteRemoteEngineeringFull-time
Who We Are
MANSCAPED® is a leading men’s grooming and lifestyle consumer brand. Founded as the category creator of below-the-waist grooming, we’ve grown into a global omnichannel powerhouse available on manscaped.com, Amazon, and in major retailers such as Target®, Walmart, and Best Buy.
Responsibilities
- 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
- Audit and 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
- Standardize 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
- Partner with Technology, Infrastructure, Security teams, and Analytics stakeholders on identity management, access provisioning, Microsoft Entra ID integration, and enterprise data governance
- 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
- Work 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
- 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
- Implement automated validation frameworks and reconciliation checks, with transparent documentation that reduces tribal knowledge and builds confidence in core datasets
- Collaborate with Analytics, BI, Technology, and business stakeholders to define ownership, lineage, and usage rules for critical data assets
- Partner with Finance, Marketing, DTC, Retail, Operations, Product, Customer Experience, and Executive Leadership to understand current and future data needs
- 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
- 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, e-commerce, retail, marketplace, subscription, wholesale, or omnichannel data environments
Benefits
- Twenty accrued vacation days per year
- Forty hours of paid sick leave annually
- Three paid mental health days
- Nine paid holidays
- Paws & Claws coverage for pets
- Comprehensive life insurance, AD&D, and long-term disability coverage
- Medical, dental, and vision insurance plans, along with Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA)
- Employee 401(k) plan and company match
- Discounts on MANSCAPED products
- Regular recognition initiatives
- Parental leave
- Wellness challenges