Overview:The Commercial Lending data organization is a Data Engineering team supporting the Commercial and Business Banking lines-of-business, playing a pivotal role in integrating and optimizing data engineering solutions between the various core banking systems and the lending origination and underwriting platform. We focus on building data pipelines, ensuring Data quality, Integrity, Reporting using ETL platforms.Responsible for facilitating moderately complex to complex projects from proposal through post implementation. Participates in meetings with lines of business to identify their requirements in how an application looks and feels to the end user; provides feedback on them and serve as a business-technical relationship between the client and technology teams. Serves as functional lead to ensure test plans and specifications are completed in a timely basis and project meets established milestones. Responsible for various system testing activities not covered by other teams such as clients completing User Acceptance Testing (UAT).Primary Responsibilities:· Evaluate datasets for quality, accuracy, and perform intermediate data analysis using applications or querying datasets to assess initial data quality.· Utilize Big data, distributed data processing technologies, and Structured Query Language (SQL) skills to profile or identify data quality issues in various database technologies.· Identify, assess, monitor, document, and communicate potential quality issues in the way data is collected, stored, processed, or used.· Create SQL scripts to create objects, validate and manipulate largest volume of data.· 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.· Prepare well documented requirement specifications for assigned projects, test plans, test cases, acceptance criteria, contributing to Jira stories and execution of test cases. Responsible for research analysis of moderately complex data ensuring functional design of assigned projects is accurate. Serve as mentor to less experienced staff by assisting in application training, research analysis and project methodology consultation.· Serve as functional lead on moderately complex projects for assigned application(s). Schedule and facilitate project team meetings and working sessions as applicable.· Participate, arrange and co-ordinate project or requirement level discussions, triages, analysis, data mapping exercises or workshops.· Lead and drive ART level / project initiatives to derive, document and establish functional and non-functional requirements. Participate in reviewing and/or authoring JIRA stories to establish requirements, testcase coverage and acceptance criteria.· Meet with business client to discuss requested application changes related to an enterprise-wide or business initiative, compliance/regulatory requirement, required system change due to contractual agreement or system maintenance (business as usual [BAU]) ensuring a thorough understanding of specifications for assigned applications. Participate in design discussions and document/deliver functional specifications.· Participate in meetings with lines of business to identify their requirements in how an application looks and feels to the end user and provide feedback to clients regarding business requirements to ensure technology applications support internal/external customer needs and products/services as provided by lines of business. Review business requirements with technology team to ensure understanding of project requirements.· Coordinate and provide estimates for moderately complex to complex projects and complete estimates for assigned component on large projects, inclusive of timelines and project phases.· Serve as subject matter expert to consult and advise on how applications may be impacted by enterprise-wide initiatives, like an acquisition or upgrade or major change in products/services provided to customers.· Work with vendor to gain thorough understanding of project functionality and provide insight on implementation.· Review and/or create thorough, detail documentation of project requirements, data integration, process flows, data transformation, data mapping, presentation views and other project related & support documentation.· May act as Test Coordinator for large project initiatives involving multiple applications.· Participate in and document data mapping for integration of systems, conversion, and acquisition related projects to understand how applications may need to change or be impacted by enterprise-wide initiatives, like regulatory requirements, other system enhancements or business initiatives.· Work with other testing and technical teams, when applicable, to prepare test plans and scripts based on functional specifications and manage and/or execute test cases verifying changes and enhancements work and perform as required. Serve as functional lead with other project team members on other systems that impact the project.· Monitor requirement specifications, Jira stories and change requests to ensure project stays within scope and meets regulatory requirements, while ensuring adherence to business requirements and Corporate Technology standards. Ensure the Bank process and documentation is followed to ensure adherence to Corporate Technology standards and regulatory requirements.· Ensure efficient and timely resolution of issues arising from testing or implementation to ensure expected performance. Ensure issues, incidences and questions are documented, reported, and resolved as required.· Coordinate and manage post-implementation by getting feedback, resolving any issues, and completing a debrief including actual to plan for timeframe and financials.· Proactively, Identify risks, draft a mitigation plan and report task and / or program status to the leadership team· 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 diversity 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.· Be an active participant and a positive player in all initiatives or tasks.· Collaborate with team(s) and with leadership on project status, updates, risks, gaps or feedback on all initiatives or tasks.Education and Experience Required:· Combined minimum of 5 years' higher education and/or operational/business analytics experience· Strong data analytical skills· Strong in creating Techno-Functional requirements and testcases.· Good understanding of SQL language and database design concepts· Strong verbal and written communication skills· Strong organizational skills· Strong time management skills· Strong lateral thinking skills· Strong problem-solving skills· Proactive· Results-driven and Detail-oriented.· Ability to understand business supported and its’ terminology.· Ability to effectively present to all levels of management· Very effective in managing analysis, workshops and result oriented outcomes.· Ability to multitask for various components of moderately complex to complex projects.· Excellent problem-solving skills to assist in issue resolution and general queries.· Proficiency with personal computers as well as pertinent software packagesEducation and Experience Preferred:· Bachelor's degree· Subject matter expert in business with knowledge or experience utilizing application/system being supported.· Capable of working on multiple projects of a moderately complex to complex nature.· Proven understanding of applications supported with a sound good knowledge of interfacing/integrated applications.· Very effective in managing analysis, workshops and result oriented outcomes.· Ability to effectively use project management, word processing and spreadsheet applications.· Good understanding of the Bank’s application framework.· Familiarity with application development software and hardware platforms.· Very Good understanding of SQL language, databases, and data models· Proficient in reverse engineering SQL code· Expert Data analytical and data lineage skills· Expert in creating Techno-functional requirements and testcases· Hands on experience with Tableau or PowerBI is a plus· Ability to understand business supported and its’ terminology.· Ability to effectively present to all levels of management· Ability to multitask for various components of moderately complex to complex projects.· Ability to coordinate between applications and business units.· Ability to work in a team environment as well as autonomously.· Ability to recognize project milestones and delivery dates.· Ability to recommend and implement solutions.· Proactive· Results-driven and Detail-oriented.· Growing understanding of Bank acquisition methodology or relevant conversion experienceM&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $82,783.41 - $137,972.36 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.LocationBuffalo, New York, United States of America
