Senior Data Architect - SQL, Snowflake, Cloud

The Bank sponsors individuals for TN and H-1B transfers on a case by case basis. Please note that this position is not open to anyone on a H-1B or F-1 student visa including those eligible for CPT/OPT or the Stem OPT extension.

This role follows a hybrid work schedule; offering the flexibility to work remotely two days a week, while providing the opportunity for onsite and in person collaboration the other three days.

FUNCTION:

Develops and maintains data models and data architecture designs. Plans, evaluates, recommends, and designs data models to ensure technology projects are cost-effective, compliant with enterprise policies and corporate technology standards and meet business and technology strategies.

Tech Stack - SQL, Snowflake, Erwin Data Modeler, DCAM

POSITION RESPONSIBILITIES:

• Develop strong relationships with all data providers, data product consumers and other data stakeholders to understand design possibilities and data usage needs.
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
• Design and model data for cloud-based data architecture solutions using Snowflake as the primary data platform.
• Develop and implement data modeling best practices to ensure scalability, performance, and reliability.
• Design and develop scalable, high-performance data architectures on the Snowflake cloud data platform to meet the evolving business needs and data growth.
• Develop and maintain documentation of the data architecture, data flow, data models and metadata for various audiences.
• Support the creation of data assets, which may include a data model, associated metamodel, common business vocabulary, ontologies, and taxonomies, which will then be used to guide solution development and achieve consistency of data assets across the enterprise
• Contribute to and communicate data management standards relating to the location, media type and cybersecurity requirements to facilitate efficient and secure management of all data elements
• Collaborate with data teams to establish appropriate data access management approaches.
• Ensure consumers have the information and resources they need to use the data products (e.g., access to data, interactive documentation to help them understand data operations, etc.)
• Produce design artifacts with data modeling and other related tools.
• Deconstruct user story into technical designs, map to existing reference architecture and create new architecture patterns for use cases that don't map into an existing reference model.
• Participate in backlog grooming sessions with the data product team to ensure technical data solution and data models meet acceptance criteria.
• Work closely with the data engineering team to ensure the implementation adheres to the design and any technical obstacles are identified and addressed.
• 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.
• 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.

MINIMUM QUALIFICATIONS REQUIRED:

• Bachelor's degree and a minimum of 5 years related experience, or in lieu of a degree, a combined minimum of 9 years higher education and/ or work experience, including a minimum of 5 years related experience
• Experience with data modeling tools and other data discovery and management tools.
• Experience with data modeling, preferably using Erwin Data Modeler tool.
• Experience implementing data architecture and data integration concepts.
• Experience with data architecture capabilities on multiple platforms including Cloud, SQL, and other industry standard applications.

IDEAL QUALIFICATIONS PREFERRED:

• Minimum of 3 years data architect experience.
• Experience implementing data governance practices.
• Experience in FinTech.
• Experience with Agile methodology and working on an Agile team.
• Experience with Data Capability Assessment Model (DCAM).
• The Open Group Architecture Framework (TOGAF), Cloud Solution Architecture on Azure, Amazon Web Services (AWS) and/or Google Cloud Platform (Google Cloud Platform) Certification.

M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $107,656.56 - $179,427.60 Annual (USD). The successful candidate's particular combination of knowledge, skills, and experience will inform their specific compensation.

Location
Wilmington, Delaware, United States of America