Snowflake Data Engineer

Competencies: 10-12+ years of experience Matillion Snowflake Advanced SQL Sr Data Engineer Role Summary: 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. Technical/Functional Skills 8 12 years total experience with 5+ years in ETL/ELT engineering using industry tools; 1+ year hands on Matillion 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). Experience with AWS components in data pipelines (Lambda, storage/services) is a plus per requirement Strong problem solving, communication, and ability to multitask in a team oriented environment Excellent verbal and written communications skills and ability to multi-task within a team-oriented environment 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) Experience Required 10+ Years with atleast 7+ Yrs as Data engineer Roles & Responsibilities 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. Documentation & KT: Maintain runbooks, SOPs, design notes; deliver KT to peers and cross functional stakeholders. Stakeholder Management: Present progress/risks to project and business teams; align deliverables to priorities and release timelines Key Responsibilities 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. Generic Managerial Skills Liaison with Customer IT & Business Team Good Communication & Presentation Skills #J-18808-Ljbffr Siri InfoSolutions Inc