Sr Advisor Snowflake Devolpement

Orgill, Inc.; Collierville (TN); On-site; USD 150,000 - 200,000; Full time

Job summary

Orgill, Inc. is seeking a Senior Snowflake Data Architect with 10 years of experience to lead our Master Data Management efforts and shape the strategic architecture for enterprise analytics.

You will drive the end-to-end Snowflake roadmap, oversee security, governance, and performance, and mentor developers across data warehousing concepts and database design.

Qualifications

• Minimum 7+ years of hands-on Snowflake or comparable cloud data platforms experience.
• Bachelor’s degree in IT/CS or related field.
• Expert-level understanding of data warehousing concepts, MDM lifecycle, and database design.

Responsibilities

• Lead the architectural vision for Snowflake to support enterprise-level MDM.
• Design complex data schemas (Star/Snowflake) to unify data from sources like Salesforce.
• Bridge business requirements to BI/retail teams and convert goals into technical roadmaps.
• Oversee integration of the data analytics stack with Snowflake, Python, and Tableau.

Skills

SQL

Python

Tableau

CRM systems

Strategic leadership

Education

Bachelor’s degree in Information Technology, Computer Science, or related field

Tools

Snowflake

Job description

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.

Strategic Architecture & Project Leadership Enterprise MDM Strategy & Design

• Architectural Vision: Lead the long-term evolution and maintenance of the Snowflake cloud platform to support enterprise-level MDM implementation.
• Conceptual to Physical Modeling: Design complex data schemas (Star/Snowflake) and master data domains that unify fragmented data from sources like Salesforce.
• Requirement Transformation: Act as the primary technical bridge to BI, Retail Services, and cross-functional teams to elicit high-level business requirements.
• Actionable Roadmapping: Convert enterprise goals into a prioritized backlog of technical tasks and architectural blueprints for the implementation team.

Governance, Security & Performance

• Global Access Strategy: Configure and manage enterprise-grade security, including advanced Role-Based Access Control (RBAC) and data masking within Snowflake.
• Compliance Framework: Implement and enforce security best practices to meet strict global compliance and data privacy requirements.
• Optimization Oversight: Manage and optimize the Snowflake environment to ensure high-performance delivery for business intelligence initiatives.

Technical Integration & Mentorship

• Ecosystem Alignment: Oversee the integration of the complete data analytics stack, ensuring seamless flow between Snowflake, Python-based automation, and Tableau.
• Advanced Troubleshooting: Serve as the final escalation point for complex technical issues and data stack downtime.
• Technical Leadership: Guide and mentor junior to mid-level developers on data warehousing concepts and database design.

Qualifications & Tech Stack Experience & Education

• Experience: Minimum 7+ years of hands-on experience in Snowflake or comparable cloud-based data platforms.
• Education: Bachelor’s degree in Information Technology, Computer Science, or a related field.
• Mastery: Expert-level understanding of data warehousing concepts, MDM lifecycle, and database design.

Technical Skills

• Data Engineering: Expert-level SQL and Python for building automated, scalable data pipelines.
• Visualization: Advanced proficiency in Tableau to translate raw data into actionable insights.
• CRM Systems: Deep familiarity with data structures and extraction methodologies.

Soft Skills

• Strategic Problem-Solving: Ability to resolve systemic, multi-layered technical challenges.
• Collaborative Leadership: Effective communication skills to align diverse stakeholders with the MDM strategy.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.