Snowflake/Talend

Location: 

US

Category:  Finance, Data & Analytics

Feel Good About Doing Good

The Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to members and their families through our life insurance, long-term care insurance, disability income insurance, investment and annuity products. Charity is at the core of our missions: our profits are donated to help those in need and to support our faith - $1.73B over the past ten years.

 

While we have many employees who are not Catholic, we follow the Church’s teachings in our investment strategies and our employee benefits. As part of our religious mission, we support the pro-life cause by contributing to the March for Life and pregnancy resource centers, we oppose assisted suicide and euthanasia, we are evangelists for the Catholic faith, and we help Christians who are facing religious persecution in the Middle East.  We all work together to support our two million members as they volunteer to help others in their parishes and communities around the world.

 

Share Your Talent. Live Your Purpose.

We are a growing and purpose-driven community of professionals. Join us to discover how you can meet your goals and ours!

#LI-Remote

Overview

We are seeking an experienced Snowflake\SQL Database Administrator (DBA) to join our team and manage, optimize, and maintain our database platforms. As a Snowflake\SQL DBA, you will play a critical role in the administration of corporate databases, ensuring performance, scalability, and security for our data infrastructure.

Core Responsibilities

    • Administer and manage Snowflake\SQL databases to ensure availability, integrity, and security.
    • Ensure proper backup and recovery procedures for all databases.
    • Implement, monitor, and optimize database performance for query optimization.
    • Implement best practices for database tuning, partitioning, and indexing.
    • Manage database access controls, user roles, and permissions.
    • Collaborate with developers, data engineers, and business intelligence teams to support data integration and analytics needs.
    • Provide technical support and troubleshooting
    • Work with the team to ensure smooth data pipeline operations and integrate with other data sources and platforms.

Skills Qualifications

  • Required Skills:
    • Proven experience as a Snowflake\SQL DBA or Database Administrator.
    • Expertise in Snowflake\SQL optimization techniques.
    • Proficiency in Snowflake\SQL, including complex queries and performance tuning.
    • Experience with Snowflake\SQL security features, including role-based access control (RBAC), data masking, and encryption.
    • Familiarity with ETL processes and data integration tools (e.g., Talend, Informatica).
    • Strong understanding of database performance monitoring, query optimization, backup and restore techniques.
    • Ability to work with cloud platforms.
  • Preferred Skills:
    • Certifications in Snowflake or other cloud data platforms (Azure).
    • Knowledge of scripting languages like Python or PowerShell for automation.

Education

    • Bachelor’s degree in computer science, Information Technology, or a related field.
    • Relevant certifications (e.g., Snowflake\Microsoft SQL Certified Professional) are a plus.

Physical Demands

Authorization to work in the US is required.

This position is not eligible for visa sponsorship.