This role offers a hybrid work schedule; offering the flexibility to work remotely two days a week, while providing the opportunity for in-person collaboration. Sponsorship is NOT available for this position.nnOVERVIEW:nnSpecializes in working with large and complex data sets to evaluate, recommend, and support the implementation of business strategies. Identifies and compiles data sets using a variety of tools to help predict, improve, and measure the success of key business-to-business outcomes. Mentoring junior analysts.nnThis role encompasses a comprehensive analysis lifecycle, covering requirements gathering, activity execution and design planning. Transforming raw data into structured information which will then be analyzed to glean insights that drive strategic business decisions.nnPOSITION RESPONSIBILITIES:nnIdentify the most authoritative sources of data and the most accurate data field(s) when domain data is sourced for internal projects and/or products by querying databases. Maintain advanced knowledge of domain's products and services, and an advanced understanding of how data supports those offerings.nnWrangle complex data sets using SQL or Python scripting for analysis and delivery purposes. Locate and explain data assets and connect them across different platforms and formats for multiple use cases.nnUnderstand and document complex data flows for multiple business user stories, profile and review complex mappings and specifications across multiple use cases, develop enterprise level data solutions for problem statements, and perform complex data analysis across multiple use cases.nnPrepare, create and execute large project, end to end test plans and scripts using SQL, Python, scripting and/or automation to test multiple/complex user stories.nnApplies intermediate knowledge of their business domain including Business Operations, Business Processes, Data Flows and uses of Data in order to provide appropriate data to inform business decisions.nnMentor junior analysts in understanding M&T's data policies and procedures.nnTranslate business data needs into technical source-to-target mapping specifications and sample data mock-ups that provide clear direction to data engineers to enhance current data products in collaboration with stakeholders.nnConduct root-cause analysis of defects and triage these to the relevant teams for resolution depending on the root causennConduct impact analysis ahead of proposed business and/or technical changesnnCommunicate proposed data flows or source-to-target mappings along with their pros, cons, known limitations, variance materiality etc. to a variety of stakeholders, including business SMEs, product owners, data modelers, data engineers.nnUnderstand 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.nnPromote an environment that supports diversity and reflects the M&T Bank brand.nnMaintain M&T internal control standards, including timely implementation of internal and external audit points together with any issues raised by external regulators as applicable.nnComplete other related duties as assigned.nnMINIMUM QUALIFICATIONS REQUIRED:nnBachelor’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 experiencennExperience pulling data from Structured Query Language (SQL) platformsnnExperience completing user acceptance testing for data productsnnBasic knowledge of data managementnnKnowledge of data cataloging and data lineage toolsnnExperience querying data that has been modeled in various techniques, e.g., slowly changing dimensions vs snapshots, key-value pairs vs normalized vs wide-table formats etc.nnExperience developing source-to-target mappings in various data delivery patterns, e.g., full data loads vs CDC (change data capture) formatsnnIDEAL QUALIFICATIONS PREFERRED:nnExperienced working as a member of an Agile TeamnnExperienced leading / mentoring team members on all analyst activitiesnnExperience in creating data flows and high-level solutions with datannAdvanced skills in SQLnnAdvanced knowledge of data managementnnKnowledge of assigned domain products, systems, and workflowsnnData classification and privacy experiencennExperienced using Data Governance ToolsnnKnowledge of statistic, data science techniques and toolsnnM&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.nnLocationnnWilmington, Delaware, United States of AmericannM&T Bank Corporation is an Equal Opportunity/Affirmative Action Employer, including disabilities and veterans.