Information Technology_USA - USA_Senior Data Scientist

Real Soft•Jacksonville, FL

4d•Remote

About The Position

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

8-12+ years of experience
Matillion Snowflake
Advanced SQL
Sr Data Engineer
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).
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

Nice To Haves

Experience with AWS components in data pipelines (Lambda, storage/services) is a plus per requirement

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