Data Movement Engineer (Snowflake) - Contractor

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.

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). Snowflake certification preferred. 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.

Bachelors degree in computer science, Information Systems, or related field. 5+ years of experience in Snowflake development and data warehousing.

Must be able to remain in a stationary position for a majority of the workday.

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.