
Data Solutions Architect
Posted 1 day ago

Posted 1 day ago
This is a fully remote position, open to applicants in United States.
• 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.
• 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.
• 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.
The Access Group
Core BTS
TD SYNNEX
Law School Admission Council (LSAC)
Get handpicked remote jobs straight to your inbox weekly.