Customer Data Engineer; Hybrid - Buffalo, NY

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.

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

No supervisory responsibility

• 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, Big Query, 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

• 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 - $ Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.

Buffalo, New York, United States of America