Data Solutions Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Take ownership of the architecture and progression of MANSCAPED’s Snowflake environment.

• Create and uphold data modeling standards across essential business domains.

• Design schemas, datasets, and views that facilitate BI, analytics, reporting, and AI applications.

• Develop and sustain intricate SQL queries, stored procedures, and performance-optimized data structures.

• Enhance Snowflake performance, manage warehouse utilization, and oversee cost management.

• Approve modifications to schemas, RBAC adjustments, Snowflake architecture updates, and significant pipeline changes.

• Define and implement the enterprise RBAC framework within Snowflake across various business functions.

• Collaborate with Technology, Infrastructure, Security teams, and Analytics stakeholders.

• Set standards for row-level security, masking policies, PII management, and permission-aware data access.

• Actively identify risks related to access, governance, data quality, and warehouse expenditures.

• Design and supervise data pipeline architecture standards.

• Serve as the technical lead on the Analytics side for ETL/ELT requirements.

⛳️ Requirements

• Over 10 years of experience in data architecture, analytics engineering, data warehousing, data platform leadership, or enterprise data solutions.

• Extensive hands-on experience with Snowflake, covering architecture design, schema development, performance tuning, RBAC, views, SQL, and stored procedures.

• Strong background in building and scaling modern data warehouse and ETL/ELT frameworks.

• Experience in crafting robust data models for BI, analytics, executive reporting, and cross-functional business applications.

• Proven track record of establishing data governance, access control, and data quality frameworks.

• Experience in collaboration with Technology, Security, Infrastructure, BI, and business teams.

• Solid understanding of data pipeline architecture, source-system mapping, transformation logic, and downstream reporting requirements.

• Familiarity with AI-ready data architecture and AI-assisted analytics workflows.

• Experience with consumer, Ecommerce, retail, or omnichannel data settings.

• Strong analytical, debugging, and problem-solving abilities.

• Capacity to explain complex technical topics to non-technical stakeholders.

• Exceptional communication, stakeholder-management, and cross-functional leadership capabilities.

🏝️ Benefits

• 20 accrued vacation days per year.

• 40 hours of paid sick leave every year.

• 3 paid mental health days.

• 9 paid holidays.

• Paws & Claws coverage for pets.

• Comprehensive life insurance, AD&D, and long-term disability coverage.

• Comprehensive medical, dental, and vision insurance plans.

• Health Savings Accounts (HSA) and Flexible Spending Accounts (FSA).

• Accident and critical illness plans.

• Employee 401(k) plan with company matching.

• Monthly utility allowance for Wi-Fi and phone expenses.

• Generous discounts on products.

• Wellness challenges to encourage health.

• Paid parental leave.

• Recognition initiatives to celebrate hard work.

• One paid volunteer day annually.

• A certified Great Place to Work with opportunities for career advancement.