Snowflake Data Platform Administrator

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values - Care, Commitment, Community, and Confidence.

We are seeking a highly skilled Senior Snowflake Administrator to manage and optimize our Snowflake cloud data platform. The ideal candidate will have extensive experience in Snowflake implementation, AWS services, PostgreSQL administration, and on-prem to cloud migration. This role involves performance tuning, cost optimization, and collaboration with multi-functional teams to ensure seamless data operations.

What you'll do

Snowflake Administration:

• Administer and manage the Snowflake cloud data platform, ensuring efficient performance, security, and reliability.
• Implement and configure Snowflake solutions, including data warehousing, data integration, and data migration.
• Optimize Snowflake performance through query tuning, resource management, and data modeling.
• Monitor and solve issues in Snowflake environments to ensure high availability and performance.
• Implement cost optimization strategies, such as right-sizing virtual warehouses, reducing auto-suspend times, and consolidating workloads.
• Apply Snowflake's cost insights for identifying and acting on opportunities for cost savings.

AWS Integration:

• Integrate Snowflake with AWS services such as S3, Glue, Lambda, and EC2 to improve data workflows and analytics.
• Design and implement data pipelines using AWS services to facilitate seamless data movement and transformation.
• PostgreSQL Management:
• Manage PostgreSQL databases, including performance tuning, backups, and recovery.
• Ensure data integrity and security across PostgreSQL environments.
• Develop and implement automation scripts for database management tasks.

Performance Tuning:

• Optimize query performance by using techniques like clustering, query pruning, and result caching.
• Conduct regular performance assessments and implement improvements to enhance query execution times and overall system efficiency.
• Use Snowflake's Query Acceleration Service and other advanced features to improve performance for complex queries.

On-Prem to Cloud Migration:

• Lead and manage the migration of on-premise databases to cloud platforms, ensuring minimal downtime and data integrity.
• Develop migration strategies and plans, including data transfer, schema conversion, and application integration.
• Partner with team members to achieve a smooth transition and resolve any migration-related issues.

Collaboration and Support:

• Collaborate with data engineering, analytics, and IT teams to ensure effective communication and integration.
• Offer technical support and mentorship to team members and collaborators.
• Participate in on-call rotations to provide 24/7 support for critical issues.

Documentation and Best Practices:

• Maintain comprehensive documentation of Snowflake and PostgreSQL configurations, processes, and procedures.
• Establish and maintain standard processes for database management, security, and compliance.

What you'll bring

• 5+ years of experience as a Snowflake Administrator.
• Demonstrable experience in implementing and managing Snowflake solutions.
• Solid understanding of AWS cloud services and integration.
• Proficiency in PostgreSQL database administration.
• Experience with cloud computing platforms (e.g., AWS, Azure, GCP).
• Excellent problem-solving skills and attention to detail.
• Clear communication and collaboration skills.
• Ability to work independently and as part of a team in a fast-paced environment.
• Experience with other cloud platforms like AWS will be nice to have.
• Knowledge of Python, Terraform or other scripting languages for automation.
• Familiarity with CI/CD pipelines and DevOps practices.
• Certification in Snowflake, AWS, or PostgreSQL.

What you'll get

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
• Outstanding Career Development opportunities.
• We'll support your professional development education.
• Competitive vacation package with the option to purchase 5 extra days off per year.
• Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.
• Corporate wellness programs to support our employees' physical and mental health.
• Hybrid flexible work model.

Please note that we may use AI tools to help us through the recruitment process. This is a new position which has been posted both internally & externally.

Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.