Snowflake Administrator

2 weeks ago

Toronto, 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 roles-based 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 on-call processes and problem escalation processes.
- Adheres to change management processes.
- Share domain and technical expertise, providing technical mentorship and cross-training 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, “get-it-done” personality.
- Ability to organize, plan work independently and multi-task
- AWS or Snowflake certification is preferred.

**Other details**
- This position requires the successful completion of a criminal and credit background check

  • BI Developer

    4 weeks ago

    Toronto, 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...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Capgemini Full time

    **About Capgemini**: Capgemini is a global leader in consulting, technology services and digital transformation, is at the forefront of innovation to address the entire breadth of clients opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50 year heritage and industry specific expertise, Capgemini enables...

  • Senior Data Analyst

    6 days ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location: ...

  • Senior Data Analyst

    6 days ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location:Downtown...

  • Senior Data Analyst

    6 days ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location: ...

  • Senior Data Analyst

    1 week ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location: ...

  • Senior Data Analyst

    1 week ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location: ...

  • Sr. DevOps Engineer

    1 week ago

    Toronto, Canada Healthcare of Ontario Pension Plan Full time

    Why you’ll love working here:high-performance, people-focused cultureour 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 selvesmembership in HOOPP’s world class defined benefit pension plan, which can serve as an important...

  • Senior Data Analyst

    1 week ago

    Toronto, ON, Canada Apex Systems Full time

    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. Contract/Perm & duration: 6-month Contract (Potential for extension) Downtown Toronto If you encounter...

  • Senior Data Analyst

    7 days ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    7 days ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    6 days ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    1 week ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    7 days ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    1 week ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location:Downtown...

  • Senior Data Analyst

    6 days ago

    Toronto, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    1 week ago

    Toronto, Canada Apex Systems Full time

    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 (Potential for extension) Location: ...

  • Senior Data Analyst

    1 week ago

    Toronto, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    1 week ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...

  • Senior Data Analyst

    7 days ago

    Toronto, ON, Canada Apex Systems Full time

    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 InstitutionContract/Perm & duration: 6-month Contract (Potential for extension)Location: Downtown...