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)