Senior Snowflake Data Engineer

Role Description

We are seeking a highly skilled Senior Data Engineer with strong hands-on experience in Matillion, Snowflake, and production support operations. The ideal candidate will be responsible for designing, building, enhancing, and supporting enterprise data pipelines while ensuring operational stability, incident resolution, and continuous improvement of data platforms.

• Manage and support production ELT pipelines and Snowflake environments.
• Handle incidents, service requests, root cause analysis, and problem management activities.
• Work closely with business and support teams to ensure SLA adherence.
• Monitor job failures, troubleshoot issues, and implement permanent corrective actions.
• Participate in on-call support and release activities as needed.
• Experience working with ITSM processes including Incident, Problem, Change, and Service Request Management.
• Maintain runbooks, SOPs, design notes; deliver KT to peers and cross-functional stakeholders.
• Present progress/risks to project and business teams; align deliverables to priorities and release timelines.
• Design, develop, and maintain scalable ELT pipelines using Matillion and Snowflake.
• Implement CDC and incremental loading solutions for enterprise data platforms.
• Develop and optimize Snowflake objects, procedures, tasks, and data models.
• Ensure data quality, governance, security, and operational reliability.
• Collaborate with business, analytics, and platform teams to deliver data solutions.
• Perform performance tuning and cost optimization for Snowflake workloads.
• Support production deployments and transition solutions into steady-state operations.

Qualifications

• 10+ Years of overall experience with at least 7+ years as a Data Engineer.

Requirements

• 8-12 years total experience with 5+ years in ETL/ELT engineering using industry tools.
• 1+ year hands-on Matillion experience.
• 2+ years building and operating Snowflake (warehouse objects, stages, tasks, streams, performance tuning).
• 3+ years of hands-on Snowflake experience, including schemas, tasks, streams, stored procedures, performance tuning, and data optimization.
• Advanced SQL: Stored procedures, functions, triggers, error handling; proven query tuning on large datasets.
• Demonstrated experience implementing CDC patterns (batch/near real time).
• Strong problem solving, communication, and ability to multitask in a team-oriented environment.
• Excellent verbal and written communications skills.
• Demonstrated proficiency developing and supporting extract, transform, and load (ETL) and extract, load, transform (ELT) processes.
• Experience building self-service reporting solutions using business intelligence software (e.g., OBIEE, Looker, Power BI, etc.).
• Ability to maintain documentation on ELT process and procedures.
• Experience conducting project-specific data analysis that includes analyzing and mapping required data and supporting all facets of the ELT process.
• Ability to assist with the creation and maintenance of ELT specifications (e.g., source-to-target maps).

Preferred Skills

• Experience with AWS components in data pipelines (Lambda, storage/services).
• Liaison with Customer IT & Business Team.
• Good Communication & Presentation Skills.