Sr Advisor Snowflake Devolpement
Orgill · Collierville, TN · 2 days ago
On-siteOTHRFull-time
About the role
We are seeking a Senior Snowflake Data Architect with 10 years of experience to serve as the strategic lead for our Master Data Management (MDM) team. You will be responsible for the end-to-end architectural vision, aligning Snowflake's capabilities with the enterprise-wide goal of creating a "single source of truth". This role requires a high-level strategist capable of translating complex business requirements into scalable, secure, and actionable technical roadmaps that support analytics and retail services.
Responsibilities
- Strategic Architecture & Project Leadership:
- Lead the long-term evolution and maintenance of the Snowflake cloud platform to support enterprise-level MDM implementation.
- Design complex data schemas (Star/Snowflake) and master data domains that unify fragmented data from sources like Salesforce.
- Act as the primary technical bridge to BI, Retail Services, and cross-functional teams to elicit high-level business requirements.
- Convert enterprise goals into a prioritized backlog of technical tasks and architectural blueprints for the implementation team.
- Governance, Security & Performance:
- Configure and manage enterprise-grade security, including advanced Role-Based Access Control (RBAC) and data masking within Snowflake.
- Implement and enforce security best practices to meet strict global compliance and data privacy requirements.
- Manage and optimize the Snowflake environment to ensure high-performance delivery for business intelligence initiatives.
- Technical Integration & Mentorship:
- Oversee the integration of the complete data analytics stack, ensuring seamless flow between Snowflake, Python-based automation, and Tableau.
- Serve as the final escalation point for complex technical issues and data stack downtime.
- Guide and mentor junior to mid-level developers on data warehousing concepts and database design.
Qualifications
- Minimum 7+ years of hands-on experience in Snowflake or comparable cloud-based data platforms.
- Bachelor's degree in Information Technology, Computer Science, or a related field.
- Expert-level understanding of data warehousing concepts, MDM lifecycle, and database design.
Skills
- Technical Skills:
- Expert-level SQL and Python for building automated, scalable data pipelines.
- Advanced proficiency in Tableau to translate raw data into actionable insights.
- Deep familiarity with data structures and extraction methodologies from CRM systems.
- Soft Skills:
- Strategic problem-solving ability to resolve systemic, multi-layered technical challenges.
- Collaborative leadership and effective communication skills to align diverse stakeholders with the MDM strategy.