Note: The job is a remote job and is open to candidates in USA. Diverse Lynx is seeking a Senior Data Engineer to support enterprise data engineering operations. The role focuses on designing, building, enhancing, and supporting Matillion and Snowflake data pipelines, managing production incidents, ensuring SLA adherence, and driving operational improvements.
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
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)
- 10+ Years with atleast 7+ Yrs as Data engineer
- Experience working with ITSM processes including Incident, Problem, Change, and Service Request Management
Company Overview
Company H1B Sponsorship