Customer Data Engineer (Hybrid
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).