NR Consulting ยท 1 day ago
Data Movement Engineer (Snowflake)
New Haven, CT
Full-time
Hybrid
Senior Level
5+ years expNR Consulting is embarking on the modernization of its core data platforms, seeking a Data Movement Engineer to provide production support for existing and future ETL environments. The role involves leading the design, optimization, and support of Snowflake-based data solutions, while managing data operations and ensuring data integrity.
ConsultingInformation TechnologyStaffing Agency
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
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
Company
NR Consulting
NR Consulting is an information technology consulting firm that offers contingent hiring, direct hires, and managed IT services.
1001-5000 employees
H1B Sponsorship
NR Consulting 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
2025 (1)
2022 (1)
Funding
Current Stage
Late StageLeadership Team
Sharabh Goyal
Founder & CEO
Company data provided by crunchbase