Apply on Employer Site

Knights of Columbus · 1 day ago

Data Movement Engineer (Snowflake) - Contractor

New Haven, CT

Full-time, Contract

Onsite

Senior Level

5+ years exp

The Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to its members. They are seeking a Data Movement Engineer to provide production support for ETL environments and lead the design and optimization of Snowflake-based data solutions.

Insurance

H1B Sponsor Likely

Responsibilities

Manage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelines

Proactively identify and resolve issues related to data integrity, latency, and pipeline failures to maintain smooth operations

Translate stakeholder requirements into Snowflake-specific solutions for data movement

Develop and optimize SQL queries, warehouse configurations, and data models for performance, reliability, and scalability

Design, develop, and optimize Snowflake data pipelines and models

Recommend and implement best practices for data ingestion, transformation, storage, security and data modeling

Support advanced features like Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2)

Support frameworks like Data Vault and dimensional modeling in Snowflake

Monitor and troubleshoot data pipeline failures and performance issues in ETL and Snowflake environments

Thoroughly test all production solutions prior to implementation

Perform root cause analysis of data discrepancies, latency, and integrity issues

Provide production support for IBM DB2, Snowflake, and orchestration tools (Airflow, ESP)

Collaborate with other teams to implement fixes and preventive measures

Perform data quality analysis, report issues, and propose solutions

Ensure data accuracy, completeness, and consistency across systems

Implement validation and reconciliation checks within pipelines

Support data governance initiatives including metadata management and lineage tracking

Lead the design, development, and maintenance of Snowflake processes

Provide technical leadership, code reviews, and mentorship to junior developers

Coordinate with business stakeholders, data architects, and application teams to gather requirements and deliver solutions

Communicate issue status, impact, and resolution timelines effectively

Maintain comprehensive documentation for all Snowflake-related issues, fixes, and scripts, ensuring they are version-controlled and aligned with data architecture and security standards

Develop and maintain production support playbooks and detailed ticket resolution procedures to enable consistent and efficient incident handling

Prepare effort estimations and contribute to architectural decisions

Provide regular updates and reports on issue trends and improvement initiatives

On-call and/or after-hours work required

Qualification

SnowflakeSQL query developmentData warehousingData Vault 2.0Cloud database technologiesOrchestration toolsIncident management toolsPythonShell scriptingAnalytical thinkingOrganizational skillsTime management

Required

Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis

Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, Oracle, SQL Server, DB2)

Strong expertise in Snowflake (development, data modeling, security)

Strong proficiency in SQL and scripting languages (e.g., Python, Shell)

Experience with cloud database technologies

Familiarity with orchestration tools (ESP, Airflow) and version control systems (Git)

Experience with incident management tools (e.g., ServiceNow, Jira) and CI/CD practices

Expertise in CDC and SCD Type 2 implementations using SQL

Solid understanding of data architecture, dimensional modeling, and frameworks like Data Vault

Ability to solve problems using analytical thinking skills

Must work well independently and be inquisitive

Strong organizational and time management skills

Bachelor's degree in computer science, Information Systems, or related field

5+ years of experience in Snowflake development and data warehousing

Preferred

Snowflake certification preferred

Company

Knights of Columbus

Knights of Columbus has grown from several members in one council to 15,342 councils and 1.9 million members throughout the United States,.

Founded in 1882

New Haven, Connecticut, USA

1001-5000 employees

http://www.kofc.org

H1B Sponsorship

Knights of Columbus has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2020 (1)