Senior Tech Lead - Snowflake Administration
Requisition ID: 181391
Career Group: Corporate Office Careers
Job Category: IT Data & Integration
Travel Requirements: 0 - 10%
Job Type: Full-Time
Country: Canada (CA)
Province: Nova Scotia; Alberta; Ontario
City: Stellarton / Calgary / Mississauga
Location: Foord St. Office
Postal Code: B0K 1S0
Our family of 131,000 employees and franchise affiliates share a collective passion for delivering exceptional shopping experiences and amazing food to all our customers. Our mission is to nurture the things that make life better – great experiences, families, communities, and our employees. We are a family nurturing families.
A proudly Canadian company, we started in a small town in Nova Scotia but we are now in communities of all sizes across this great country. With over 1,600 stores in all 10 provinces, you may know us as Sobeys, Safeway, IGA, Foodland, FreshCo, Thrifty Foods, Lawtons Drug Stores or another of our great banners but we are all one extended family.
Ready to Make an impact?
Sobeys is full of exciting opportunities, and we are always looking for bright new talent to join our team! We currently have a full-time opportunity for a Senior Tech Lead - Data Platforms. This role can be based out of one our main offices including: Stellarton, NS; Mississauga, ON; Calgary, AB.
Here’s where you’ll be focusing:
As a Senior Tech Lead - Data Platforms with Sobeys, you will:
- Work in the Platform Administration team within the Enterprise Data Office.
- Perform all administration functions within the Snowflake platform
- Implement cost monitoring techniques and optimizations.
- Implement and support automation for production deployment in Snowflake.
- Define and implement Snowflake standards and methodologies.
- Implement and support automation for administering Snowflake accounts, databases, and roles.
- Implement data sharing and replication.
- Create Snowflake utilization and capacity plan.
- Propose and implement database and Snowflake query performance optimizations.
- Identify system bottlenecks and recommend solutions.
- Implement Snowflake user and query log analysis and alerts.
- Implement data encryption/decryption/masking policies to protect sensitive data.
- Support the Enterprise Data Office data engineering teams to standardize data integration patterns that will facilitate seamless data flow between source systems and the Snowflake platforms.
- Support in the delivery of the enterprise-wide data architecture/data modeling strategy for our Enterprise Data Lake and a business consumption layer that aligns with the organization's business goals and objectives.
- Champion the Enterprise Data Office goals and guiding principles:
- Build trust in data and how we use it.
- Establish and embed collaborative ways of working to accelerate our data transformation.
- Champion the safe and scalable use of data across the organization
#LI-Hybrid
What you have to offer:
- Technical expertise in all aspects of Snowflake.
- Hands-on experience in administering Snowflake.
- Experience in implementing Snowflake external functions.
- Experience securing sensitive data PII/PCI/PHI data in snowflake.
- Knowledge of security administration (SAML, SCIM, etc).
- Experience with architecting and maintaining high availability production systems.
- Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts.
- Experience with DevOps concepts.
- Knowledge of security controls for the public cloud (encryption of data in motion/rest and key management).
- Demonstrated proficiency of index design, query plan optimization and analysis required.
- Hands-on experience in administration of relational Databases, Data Warehouse and Data marts.
- Drive for continuous learning around Snowflake features and enhancements.
Your experience and resume will show us:
- Bachelor’s Degree and 5+ years of work experience in Computer Science, Information Systems, or another related field.
- Minimum 4+ years of related experience in Snowflake administration.
- Extensive hands-on experience with SQL.
- Strong communication and written skills.
We offer teammates competitive total compensation packages that will vary by role and location. Some websites share our job opportunities and may provide salary estimates without our knowledge. These estimates are based on similar jobs and postings for general comparison, but these numbers are not provided by or monitored for accuracy by our organization. We look forward to discussing the specific compensation details relevant to this role with candidates who are selected to move forward in the recruitment process.
Sobeys is committed to accommodating applicants with disabilities throughout the hiring process and will work with applicants requesting accommodation at any stage of this process.
While all responses are appreciated only those being considered for interviews will be acknowledged.
We appreciate the interest from the Staffing industry however respectfully request no calls or unsolicited resumes from Agencies.