Über
Years St. Louis, MO Contract Role
Onsite from Day 1
Role Summary: We are seeking a Data Engineer (ELT oriented) to design, build, and support cloud data pipelines with a primary focus on Matillion and Snowflake. The engineer will own ingestion, transformation, orchestration, quality, and performance for high value data products, collaborating closely with product, analytics, and platform teams
Matillion - REQUIRED, candidates without hands-on experience will be rejected Snowflake - REQUIRED Data Engineer - ETL - REQUIRED
Experience Required 10
Years with at least 7
Yrs as Data engineer
Technical/Functional Skills 8 12 years total experience with 5
years in ETL/ELT engineering using industry tools; 1
year hands on Matillion (or strong equivalent with rapid ramp up) 2
years building and operating Snowflake (warehouse objects, stages, tasks, streams, performance tuning) 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)
Roles & Responsibilities Design & Build ELT Pipelines: Develop end to end ELT pipelines that extract from APIs, RDBMS, files, and third party sources, and load into Snowflake/data lake targets; operationalize using Matillion (or equivalent). Modeling & Curation: Create and maintain schemas/data models (staging, curated, data marts); document source to target mappings, lineage, and standards. CDC & Incremental Loads: Implement Change Data Capture (CDC) strategies (Snowflake features/Matillion patterns/AWS services) to minimize latency and cost. Data Quality & Governance: Embed validation rules, recon checks, exception handling, and error trapping; ensure security and compliance (RBAC/masking where applicable). Performance & Cost Optimization: Tune SQL/warehouse sizing, job parallelism, partitioning, and caching to meet SLAs with predictable spend. Ops & Reliability: Configure schedules/monitors, own incident triage and on call rotation for ELT runs; provide root cause analysis and preventive fixes. 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
Generic Managerial Skills: Liaison with Customer IT & Business Team
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.
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.