Senior Data Engineer (Matillion)

Diverse Lynx LLC
St. Louis, MO, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
1 year minimum
Compensation
$156,000
Working hours
Regular working hours

Tech stack

Application Programming Interfaces (APIs) Data Analysis Microsoft Azure Big Data Databases Extract Transform Load (ETL) Python (Programming Language) Oracle Business Intelligence Enterprise Edition Performance Tuning Query Optimization Power BI SQL Stored Procedures
+7 more
Scripting Sql Optimization Snowflake Data Management Looker Analytics Data Pipelines Databricks

Job 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.

Requirements

Python Programming/Scripting Language, Data Science, Microsoft Windows Azure, Application Programming Interface (API), Production Support, Data Management, Continuous Improvement, Operational Support, Database Extract Transform and Load (ETL), Warehousing, Competencies: 10+ Years with at least 7+ Yrs as Data engineer Digital : Microsoft Azure Digital : Application Programming Interface (API) Digital : Python for Data Science Digital : Databricks, * 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 Eligible to workimization.
  • 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)

About the company

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…