Customer Data Engineer (Hybrid - Buffalo, NY)

M&T Bank•Buffalo, NY

10d•Hybrid

About The Position

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.

Requirements

3+ years of experience as a SQL Developer or Data Engineer.
Advanced proficiency in SQL (joins, CTEs, window functions, query tuning).
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.

Nice To Haves

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

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.