OVERVIEW:

We are seeking a highly skilled SQL Developer to design, maintain, and optimize the data model powering our Customer Data Platform (CDP). This role is critical in shaping a unified, scalable Customer 360 data layer that supports analytics, segmentation, and personalized customer engagement.

You will work closely with data engineering, analytics, and marketing teams to ensure high-quality, reliable, and performant customer data across the organization.

POSITION RESPONSIBILITIES:

• Design, develop, and maintain scalable, high-performance data models supporting a Customer Data Platform.
• Build and optimize complex SQL queries, views, and data transformations.
• Develop and manage customer-centric data structures (profiles, events, identity resolution models).
• Integrate and harmonize data from multiple sources (CRM, web, mobile, transactional, marketing platforms).
• Support and enhance Customer 360 data models, enabling segmentation and personalization use cases for users of the platform.
• Collaborate with stakeholders to translate business requirements into efficient, scalable data solutions.
• Monitor and improve data quality, integrity, and consistency across the CDP ecosystem.
• Implement and maintain ETL/ELT pipelines to support data ingestion and transformation.
• Troubleshoot and resolve data discrepancies and performance issues.
• Document data models, schemas, and lineage for governance and transparency.
• 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 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.

MANAGERIAL/SUPERVISORY RESPONSIBILITY:

No supervisory responsibility

MINIMUM QUALIFICATIONS REQUIRED:

• Bachelor’s degree and a minimum of 3 years related experience, or in lieu of a degree, a combined minimum of 7 years higher education and/ or work experience, including a minimum of 3 years related experience

• Knowledge of relational databases

• Knowledge of the types of issues data can have

• Basic knowledge of data management

• Intermediate skills in Structured Query Language (SQL)

• Basic knowledge of statistics, data science techniques and tools

• Strong experience with data modeling (relational and dimensional models).

• Hands-on experience with modern data warehouse platforms (e.g., Snowflake, Redshift, BigQuery, Azure Synapse).

• Experience developing and maintaining ETL/ELT pipelines.

• Solid understanding of data integration and transformation best practices.

• Experience working with large-scale datasets and optimizing performance.

• Strong problem-solving and analytical skills.

IDEAL QUALIFICATIONS PREFERRED:

• 3+ years of experience as a SQL Developer or Data Engineer.
• Advanced proficiency in SQL (joins, CTEs, window functions, query tuning).
• Experience with Customer Data Platforms (CDPs) or customer analytics environments.
• Knowledge of customer identity resolution and event-based data modeling.
• Familiarity with data transformation frameworks.
• Experience with orchestration tools.
• Understanding of marketing data ecosystems (CRM, CDP, marketing automation tools).
• Exposure to streaming/event data pipelines.
• Knowledge of data governance and privacy regulations (GDPR, CCPA).

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $85,800.00 - $143,000.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