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.

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 Companys risk and regulatory standards, policies and controls in accordance with the Companys 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:

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

IDEAL QUALIFICATIONS PREFERRED:

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