Data Movement Engineer (Snowflake)
- Contractor 3.6 3.6 out of 5 stars New Haven, CT 06511 Hybrid work $50
- $58 an hour
- Contract Nesco Resource, LLC 862 reviews $50
- $58 an hour
- Contract Data Movement Engineer (Snowflake) Own the Snowflake ecosystem.
Build modern, cloud-scale data solutions. We're supporting a large organization in the middle of a major data platform modernization, transitioning core systems into a cloud-first architecture. They're hiring a Data Movement Engineer (Snowflake) to take a lead role in designing, optimizing, and supporting Snowflake-based data solutions that power analytics, reporting, and enterprise decision-making. This is a high-impact contract opportunity for someone who enjoys production ownership, performance tuning, and building resilient, scalable data platforms. What You'll Do You'll own Snowflake data operations and play a critical role in the reliability and evolution of the data platform: Lead the full lifecycle of Snowflake data operations: monitoring, troubleshooting, optimization, and continuous improvement Design, build, and optimize Snowflake pipelines, transformations, and data models Translate business and technical requirements into Snowflake-native data movement solutions Develop and tune advanced SQL, warehouses, and storage strategies for performance and scalability Implement best practices across ingestion, transformation, security, and data modeling Support advanced patterns including CDC and SCD Type 2 Work with Data Vault and dimensional modeling frameworks Provide production support across Snowflake, IBM DB2, and orchestration tools (Airflow, ESP) Perform root cause analysis on data issues, pipeline failures, and performance degradation Lead data quality initiatives including validation, reconciliation, lineage, and governance Partner closely with data architects, engineers, analysts, and application teams Provide technical leadership, conduct code reviews, and mentor junior engineers Create and maintain documentation, runbooks, and production support playbooks Contribute to architecture decisions, effort estimates, and long-term platform improvements Participate in on-call or after-hours support as needed What You Bring 5+ years in data engineering, data warehousing, or analytics engineering roles Strong Snowflake expertise (development, optimization, security, modeling); certification a plus Advanced SQL skills across platforms such as Snowflake, Oracle, SQL Server, and/or DB2 Experience with cloud data platforms and modern data architectures Working knowledge of
CDC, SCD
Type 2 , and enterprise data modeling techniques Familiarity with Data Vault and dimensional modeling Experience supporting production data environments and incident management Proficiency with orchestration tools like Airflow or ESP Comfort with scripting (Python, Shell) and version control (Git) Experience with ServiceNow, Jira, or similar tools Strong problem-solving skills, ownership mentality, and ability to work independently Excellent communication, documentation, and time-management skills Nice to Have Background supporting large-scale Snowflake environments Experience in modernization or cloud migration initiatives Exposure to CI/CD for data platforms Passion for mentoring and influencing technical direction Education Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience) 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. Skills Qualifications 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 inSnowflake(development, data modeling, security). Snowflake certification preferred. Strong proficiency in SQL and scripting languages (e.g., Python, Shell). Experience withcloud 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 inCDCandSCD Type 2implementations using SQL. Solid understanding of data architecture, dimensional modeling, and frameworks likeData Vault. Ability to solve problems using analytical thinking skills. Must work well independently and be inquisitive. Strong organizational and time management skills. Education Bachelors degree in computer science, Information Systems, or related field. 5+ years of experience in Snowflake development and data warehousing. Physical Demands Must be able to remain in a stationary position for a majority of the workday. PRO113 #LI-ME1 Nesco Resource offers a comprehensive benefits package for our associates, which includes a MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services. Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
