Hiring.Camp

Senior Solutions Developer - UCL Data Platform

Mtb

·

Oct 14, 2026

Salary
$97k – $162k
Location
Buffalo, NY, United States of America
Workplace
Hybrid
Type
Full-time
Department
IT
Seniority
Senior
Education
Bachelor
Source
Workday

Description

This role is four days onsite at our Seneca One Buffalo, NY location, with the flexibility to work from home one day per week

Overview:     

The Senior Developer is responsible for the design, development, testing, implementation, and production support of data integration and processing solutions supporting the UCL data platform and its upstream and downstream consumers. The role works primarily with Oracle Autonomous Data Warehouse (ADW), SQL/PLSQL, Oracle Cloud/OCI, data integration pipelines, and enterprise data sources, with responsibility for moving and transforming financial data through controlled development and release processes.


The position requires a developer who can independently analyze complex data requirements, design efficient SQL and data-processing solutions, troubleshoot data and performance issues, and work across Finance, Technology, architecture, testing, and vendor teams.

           

Primary Responsibilities:

  • Design, develop, test, and maintain SQL/PLSQL and Oracle ADW-based data processing solutions, including complex queries, transformations, views, extracts, and data-loading processes. UCL's current integration model includes ADW as a core processing/data platform and requires developers to work directly with substantial SQL and extract logic.
  • Develop and support ETL/ELT and data integration pipelines between enterprise data sources and Oracle ADW, including Snowflake-to-ADW integration and other upstream/downstream data movements.
  • Analyze source-to-target requirements, data mappings, transformation logic, filters, joins, reconciliation rules, and downstream extract requirements. The existing UCL process requires integration of incoming datasets into the UCL table structure/unified layer and subsequent creation of downstream extracts.
  • Partner directly with downstream consumers to understand data requirements, required fields, filters, frequency, timing, validation criteria, and delivery expectations, reducing unnecessary handoffs between development teams.
  • Investigate and resolve data-quality, transformation, reconciliation, and SQL defects, determining whether problems originate in source data, business logic, integration logic, or downstream processing.
  • Troubleshoot Oracle ADW performance, including long-running SQL, execution plans, CPU/I/O contention, parallel execution, temporary-space utilization, and other database bottlenecks.
  • Design solutions capable of supporting increasing data volume, processing frequency, batch-runtime, and SLA requirements, including the movement from monthly toward more frequent/daily processing.
  • Support integration between UCL and technologies/platforms such as Oracle DIS, Oracle DFCS, Snowflake, Workiva, Axiom, Alteryx, OCI, and other enterprise data sources/consumers as required by the application architecture.
  • Participate in development, unit testing, SIT, UAT/CERT, release, deployment, and production validation, ensuring changes can be promoted safely through DEV, TEST/SIT, CERT/UAT, PREPROD, and PROD.
  • Diagnose production and lower-environment issues involving SQL logic, data discrepancies, interfaces, batch processing, performance, configuration, and data dependencies, and work with appropriate teams through resolution. UCL/FDI delivery history shows active developer involvement in defect remediation, testing, SIT/review transitions, and release readiness.
  • Provide technical guidance and code/design review for other developers and help identify inefficient, incorrect, or unsustainable implementation approaches before they reach higher environments.

Development & SDLC Responsibilities:

The role is not just an SQL developer. Developers operate within a controlled enterprise SDLC:

    • Create and maintain Jira Stories/Tasks for development work and ensure work is associated with the appropriate Jira Feature.
    • Participate in refinement and provide technical analysis and estimates before development begins.
    • Maintain traceability between requirements, development, testing, architecture, and deployments. Feature IDs must be represented in the Solution Architecture Document, and development changes must remain traceable through the promotion lifecycle.
    • Participate in technical and architecture reviews and identify assumptions, dependencies, risks, constraints, and design issues early enough to prevent downstream rework.
    • Keep Jira work current as code/configuration progresses through development → testing → review → deployment.
    • Support documentation necessary to promote application objects/configurations/code through controlled environments.
  • Understand and adhere to the Company’s risk and regulatory standards, policies and controls in accordance with the Company’s Risk Appetite.  Identify risk-related issues needing escalation to management.
  • Promote an environment that supports a culture of belonging and reflects the M&T Bank brand.
  • Maintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.
  • Complete other related duties as assigned.

Scope of Technical Responsibilities:

Strong / hands-on

  • Oracle SQL
  • PL/SQL
  • Oracle database development
  • Oracle Autonomous Data Warehouse (ADW)
  • Complex SQL optimization and performance tuning
  • ETL/ELT development
  • Data integration and transformation
  • Source-to-target mapping
  • Data reconciliation and validation
  • Large-volume/batch data processing
  • Relational database concepts and dimensional/data-model concepts

Working knowledge / desirable

  • Oracle Cloud Infrastructure (OCI)
  • Oracle DIS / enterprise data-movement technologies
  • Snowflake
  • REST APIs / Oracle REST Data Services (ORDS)
  • Workiva/Wdata integrations
  • Axiom
  • Enterprise schedulers / batch processing
  • Jira
  • Git / source control
  • CI/CD and automated deployment practices

Education and Experience Required:

  • Associate’s degree and a minimum of 5 years' solutions development and/or relevant enterprise technology  experience or a Bachelor's degree and minimum of 3 years' solutions development and/or relevant enterprise technology experience or in lieu of a degree, a combined minimum of 7 years' education and/or relevant work experience, including a minimum of 3 years’ solutions development and/or relevant enterprise technology  experience
  • Advanced proficiency in a minimum of one relevant platform

Education and Experience Preferred:

  • Advanced analytical skills specific to solutions development
  • Experience working in a team environment
  • Ability to work autonomously
  • Ability to  multitask on  complex projects
  • Strong organizational and time management skills
  • Proficient verbal and written communication skills
  • Experience working in an agile framework to meet business objectives

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $97,100.00 - $161,800.00 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

Location

Buffalo, New York, United States of America

Skills

CI/CDSQLOracleSnowflakeETLGitJiraREST

Similar Jobs

30

Solutions Developer Senior

Arizona State University·US·Hybrid

2w ago

Senior Solutions Developer

Cai·Manila, National Capital Region·Hybrid

1mo ago

Senior Cloud Application Developer / AWS Solutions Architect

MKS2 Technologies·Remote +1·Remote

Senior Manager, Developer Solutions

Discord·New York City, New York +1

1d ago

Senior Strategic Business Developer, K-12 Financial Solutions

Blackbaud·US·Remote

1d ago

Senior Software Developer, Dealer Solutions

Leap Tools·Toronto, Ontario·Remote

1w ago

Sr Business Solutions Developer

TC Energy·US·Hybrid

1w ago

Sr. Director, Developer Solutions Strategist

Cloudflare·Austin, Texas·Hybrid

3w ago

Senior Full Stack Web Developer - Platform Solutions

Readdle·Kyiv, Kyiv City +1·Remote

1mo ago

Senior Solutions Developer - OFSAA

Mtb·Buffalo, New York·Hybrid

1mo ago

Senior Solutions Developer - Business Intelligence and Analytics

Mtb·Buffalo, New York·Hybrid

1mo ago

Sr. Software Developer (software installation and deployment solutions)

AspenTech is·Pune, Maharashtra

1mo ago

Senior Backend Developer (Enterprise Solutions Unit)

Semrush·Madrid, Spain·Remote

1mo ago

Angular Senior Developer, IT Solutions

Edwards·India-Pune

1mo ago

Digital Solutions - AI & Automantion - Senior Developer (MuleSoft)

Connorgp·Baltimore, Maryland +10·Remote

2mo ago

Senior Solutions Architect, APJC (Developer Platform) - Hindi Speaking

Cloudflare·Singapore·Hybrid

2mo ago

Senior Full-Stack Developer (AI-Accelerated Solutions, GCP Focus) - LATAM

Sell2Rent·Remote

2mo ago

Microsoft Certified Solutions Senior SharePoint Developer

HarmonyTech·Washington, District of Columbia·Remote

2mo ago

Senior AI Data Scientist – Solutions Developer

Usaa·US·Remote, Hybrid

3mo ago

(SENIOR) FULLSTACK DEVELOPER - INTERNAL SOLUTIONS (M/W/D)

Wilken·Ulm, Baden-Wurttemberg

3mo ago

Sr. Tech Business Developer, Just Walk Out Technology by Amazon - AWS Solutions

Amazon Company

Senior Developer, Private Markets Solutions Delivery

Investpsp·Montréal, Quebec

4mo ago

Senior Full Stack Developer (Technical Solutions)

Flyscoot·Singapore·Hybrid

4mo ago

Senior Solutions Architect & Developer - Payment Systems & Cust Reporting

Mizuho Mizuho is in growth·US

4mo ago

Senior Software Developer, Fund Solutions

Theapexgroup·Pune, Maharashtra·Onsite

5mo ago

Senior Full Stack Developer, Smart Factory Solutions

Magna·Michigan, US

7mo ago

WCube Solutions - Senior Software Developer - Node.js/RESTful API

WCube·Gurugram, Haryana

1y+ ago

Sr. Java Developer VOIP/SIP Solutions

Industryprofessionals·Hybrid

Senior AI Solution Developer - ERP (f/m/div.)

Robert Bosch·Lisbon, Portugal·Hybrid

Today

Senior AI Solution Developer - CRM (f/m/div.)

Robert Bosch·Lisbon, Portugal·Hybrid

Today