Senior Data Platform Engineer (Oracle ADW/ETL)

M&T Bank; Buffalo (NY); Hybrid; USD 97,000 - 162,000; Full time

Job summary

M&T Bank in Buffalo, NY is seeking a Senior Developer to design, develop, test, and support data integration on the Oracle ADW platform. The role is four days onsite at Seneca One Buffalo, with one day remote weekly.

The candidate will build ETL/ELT pipelines, optimize complex SQL, and ensure data quality across finance and technology teams, delivering reliable data movement and timely releases.

Qualifications

• Associate’s degree with 5+ years in solutions development or bachelor’s with 3+ years experience; or 7+ years combined education/work.
• Advanced proficiency in at least one relevant platform.

Responsibilities

• Design, develop, test, and maintain SQL/PLSQL and ADW-based data processing solutions.
• Develop ETL/ELT pipelines between enterprise sources and ADW, incl. Snowflake-to-ADW.
• Analyze data mappings, transformation logic, and downstream extracts.
• Collaborate with downstream consumers to understand data requirements and SLAs.
• Troubleshoot data-quality, reconciliation, and SQL defects; resolve issues with teams.

Skills

Oracle SQL

PL/SQL

Oracle ADW

SQL optimization

ETL/ELT

Data integration

Data transformation

Source-to-target mapping

Data reconciliation

Batch processing

Dimensional modeling

Education

Associate’s degree

Bachelor’s degree

7+ years combined experience

Tools

OCI

Oracle DIS

Snowflake

ORDS

Workiva/Wdata

Axiom

Enterprise schedulers

Jira

Git

CI/CD

Job description

M&T Bank in Buffalo, NY is seeking a Senior Developer to design, develop, test, and support data integration on the Oracle ADW platform. The role is four days onsite at Seneca One Buffalo, with one day remote weekly.

The candidate will build ETL/ELT pipelines, optimize complex SQL, and ensure data quality across finance and technology teams, delivering reliable data movement and timely releases.