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.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.