Snowflake Administrator

1 week ago

Toronto, Ontario, Canada Freedom Mobile Full time

A little about us


At Freedom, we're proud to be leaders in a movement that brings affordable wireless services to Canadians - we're always on the lookout for go-getters that are committed to disrupting the status quo.

Does that sound like you? We'd love to meet you.

The role

A typical day

  • Design, optimize, document, and implement the operational aspects in supporting the snowflake cloud data platform, including cost monitoring and optimizations, user security auditing etc
  • Implement Snowflake standards and methodologies for DB security both infrastructure and app level
  • Implement/support automation for administering Snowflake
  • Accounts/Databases, user management and rolesbased access control (RBAC).
  • Create and monitor Snowflake utilization and capacity plan.
  • Implement Snowflake user /query log analysis and alerts.
  • Implement data encryption/decryption/masking policies to protect PII/PCI data.
  • Implement data sharing /replication cross cloud/cross region for internal/external clients.
  • Implement/support automation for production deployment in Snowflake using GitHub.
  • Define & Perform DR and DB restore processes.
  • Work on critical incidents, user service requests and be responsible for SLA adherence, tracking, and reporting.
  • Create standards, processes, policies, and procedures as per snowflake best practices.
  • Performs support, as required, adhering to oncall processes and problem escalation processes.
  • Adheres to change management processes.
  • Share domain and technical expertise, providing technical mentorship and crosstraining to other peers and team members.

Your skills/experience

  • Must have complete understanding of Snowflake Architecture, Configurations, features and functionalities.
  • Must have knowledge of how data gets processed and consumed in the Data Platform and how to automate the completed process.
  • 4+ years of experience of Administration, scalability, performance tuning, trouble shooting, monitoring, alerts & Reporting using Native tools of Snowflake.
  • 4+ year experience in SQL, Unix Shell, Python & JSON Scripting.
  • Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
  • Understanding and Experience of working with cloud based ETL/ELT tool like Informatica IICS & Matillion.
  • Experience with architecting and maintaining high availability production systems.
  • Experience of working with cloud hosted large data warehouses.
  • Experience with AWS CLI and Networking is a plus.
  • Experience of configuring AWS services EC2, IAM, S3, security group etc. is a plus.
  • Must be capable of working independently and collaboratively.
  • Bachelor's degree in computer science, Information Science, or relevant Certifications.
  • Excellent written and verbal communication
  • Flexible, team player, "getitdone" personality.
  • Ability to organize, plan work independently and multitask
  • AWS or Snowflake certification is preferred.

Other details

  • This position requires the successful completion of a criminal and credit background check

  • Cloud and Networks Systems Administrator

    1 week ago

    Toronto, Ontario, Canada ISG Search Inc Full time

    Our client One of the world's best pension investment funds undergoing major technology transformation and modernizationWhat's in it for you Play a large part in driving the growth and transformation of key infrastructure components by designing and implementing technology solutions that meet key business needs and help build for the future.What you will...

  • Aws Cloud Administrator

    1 week ago

    Toronto, Ontario, Canada AstraNorth Full time

    Skills and Responsibilities: Conduct AWS administrative, access, and support tasks across appropriate environments. Efficiently monitor the AWS costs and develop several strategies for cost optimization. Learn the metrics and monitor the overall usage of several AWS resources with the help of Amazon CloudWatch and provide recommendations to Dev teams to fine...

  • Software Developer

    2 weeks ago

    Toronto, Ontario, Canada Fidelity Investments Full time

    Description Job Posting - Software Developer (Data Warehous Developer) You will be working on a 100% remote schedule as part of Fidelity's dynamic working arrangement. At Fidelity, we've been helping Canadian investors build better financial futures for over 35 years. We offer individuals and institutions a range of trusted investment portfolios...

  • Cloud Infrastructure Specialist

    2 weeks ago

    Toronto, Ontario, Canada ISG Search Inc Full time

    Our client One of the world's best pension investment funds undergoing major technology transformation and modernizationWhat's in it for you Play a large part in driving the growth and transformation of key infrastructure components by designing and implementing technology solutions that meet key business needs and help build for the future.What you will...

  • BI Developer

    1 week ago

    Toronto, Ontario, Canada Fidelity Investments Full time

    Description You will be working on a hybrid schedule as part of Fidelity's dynamic working arrangement. Business Overview At Fidelity, we've been helping Canadian investors build better financial futures for over 35 years. We offer individuals and institutions a range of trusted investment portfolios and services - and we're constantly seeking to...

  • Manager, Business Management Operations

    2 weeks ago

    Toronto, Ontario, Canada Indigo Full time

    Dedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170 Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail stores, distribution centres,...

  • Senior DevOps Engineer

    1 week ago

    Toronto, Ontario, Canada Healthcare of Ontario Pension Plan Full time

    Why this workplace is awesome: Emphasis on high performance and a people-centric culture Strong commitment to equity, diversity, and inclusion to foster a supportive work environment where employees can freely be themselves Membership in HOOPP's esteemed defined benefit pension plan, providing vital retirement security Competitive 100% company-paid...

  • Data Analyst

    2 weeks ago

    Toronto, Ontario, Canada Apex Systems Full time

    Client:Financial InstitutionContract/Perm & Duration:6-month Contract (Potential for extension)Location:Downtown TorontoProject: Large Data Conversion to Automated FrameworkJob Description:Responsible for the design, development, and administration of transactional and analytical data constructs/structures. Contribute towards areas of data access and...

  • Sr. DevOps Engineer

    2 weeks ago

    Toronto, Ontario, Canada Healthcare of Ontario Pension Plan Full time

    Why you'll love working here: high-performance, people-focused culture our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves membership in HOOPP's world class defined benefit pension plan, which can serve as an important...

  • CRM Operations Specialist

    2 weeks ago

    Toronto, Ontario, Canada Indigo Full time

    Dedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170 Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail stores, distribution centres,...

  • Analytics Engineer

    2 weeks ago

    Old Toronto, Ontario, Canada PdsSoft Inc Full time

    Can you envision your future accomplishments as a Analytics Engineer at PSYCHO BUNNY? WHO WE ARE ? Psycho Bunny is a worldwide menswear brand that had one mission when it was founded in New York back in 2005: to perfect the polo. Nearly two decades later, our quality-obsessed approach has built a devoted following of fashion-conscious individuals looking for...

  • Data Analyst Level 3

    1 week ago

    Toronto, Ontario, Canada AppleOne Full time

    This Data Analyst Level 3 Position Features: Hybrid 3 days in office Great Pay to $150K They are working on a migration project. Nature of the data is finance based and need the experience and confidence in executing SQL scripts and data modelling. Basic understanding of modelling data and data controls.MUST haves are:Financial experience Shell scripting...

  • CRM Operations Specialist

    1 month ago

    Toronto, Ontario, Canada Indigo Full time

    Description de l'entrepriseDedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170 Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail...

  • CRM Operations Specialist

    4 weeks ago

    Toronto, Ontario, Canada Indigo Full time

    Description de l'entrepriseDedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170 Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail...

  • CRM Operations Specialist

    1 week ago

    Toronto, Ontario, Canada Indigo Books & Music Full time

    Description de l'entrepriseDedicated to telling stories and creating experiences, Indigo is always looking for bright, energetic and customer-focused people who can help bring our exciting mission to life in one of our more than 170 Indigo, Indigospirit, Chapters and Coles stores across Canada. We offer a variety of exciting opportunities at our retail...

  • Senior Data Analyst

    2 weeks ago

    Toronto, Ontario, Canada Apex Systems Full time

    Job#: Job Description: Senior Data Analyst Apex Systems is a large staffing and consulting firm and we are looking for a Senior Data Analyst with strong SQL skills, UNIX platform experience, and financial knowledge to place at our client, a top Financial Institution. Client: Financial Institution Contract/Perm & duration: 6-month Contract...

  • Data Management Analyst/Analyst Senior

    1 week ago

    Toronto, Ontario, Canada AECON Full time

    From the roads and transit systems that connect our communities, to the communication networks that link us from coast-to-coast, and the water infrastructure that supplies our businesses and homes. Our integral work includes constructing the pipelines that join provinces with the energy that fuels the nation, and the airports and ports that connect us all....

  • Database Architect

    1 week ago

    Toronto, Ontario, Canada Richardson GMP Ltd. Full time

    As a leading Canadian wealth management organization, Richardson Wealth offers the personal touch of a boutique firm while delivering big results. With offices across the country, we are home to some of Canada's best investment advisors. We want to be the brand of choice for Canada's top advisors and their high-net-worth clients. We also have an ambitious...

  • Sr. Manager, Data Engineering

    2 weeks ago

    Toronto, Ontario, Canada Canada Goose Full time

    Job DescriptionThe Senior Manager for Data Engineering & Integrations is responsible for leading the capability and cross-functional team of data engineering and integration functions to design and deliver the modernization of integration architecture, while enabling a data engineering capability as part of the Data, Automation & AI products and services. In...

  • Specialist, Customer Sales Initiatives

    2 weeks ago

    Toronto, Ontario, Canada Coca-Cola Canada Bottling Limited Full time

    Facility Location TorontoWork Location Posting Locations TorontoAbout This Opportunity:As a Customer Sales Initiatives Specialist, you will play a pivotal role in driving topline growth through the planning and execution of field sales initiatives. Collaborating with both internal and external partners, you will be responsible for developing the National and...