This position will be responsible for streamlining ongoing activities and assuming the lead role in the assessment, planning, coordination, and implementation of defined projects that support service, productivity, and improvements. Represent unit (dept) in cross functional, high visibility projects involving business partners outside of the department. Responsible for streamlining ongoing activities.
Power BI and SQL Skills
Data Management: Updating SQL tables with new data, cleaning up data, and refreshing Power BI dashboards
Data Analysis: Using SQL for data querying, data wrangling, and creating measurement frameworks
Integration with Power BI: Connecting Power BI to SQL Server databases and analyzing data to get insights
Primary Responsibilities:- Develop and produce high complexity departmental reports and spreadsheets to include but not limited to project or product strategy analysis, historical reporting, work flow analysis, and financial analysis.
- Identify trends, emerging issues and engage relevant stakeholders to develop project plans, organize virtual and physical events, synthesize multiple points of view and communicate findings utilizing such tools as white papers, reports and other relevant formats.
- Perform complex analysis and judgment based work over multiple disciplines to support business decisions
- Lead the creation and maintenance of various reporting dashboards. Go beyond basic reporting and delivery with the ability to analyze large amounts of data and information to provide meaningful insights and professionally communicate those insights to management and business partners.
- Lead continuous improvement of existing processes, develop new processes or enhance existing processes where required including maintenance plans, procedural documentation and custom tools for automation. Identify resources that can be utilized to support business operations or improve existing business processes. Present findings and make recommendations to management.
- Lead in the planning and implementation of new projects, programs, and plans to achieve short and long term business objectives; coordinate of the design and execution of various projects for the promotion and maintenance of the business.
- Take a lead role in supporting departmental audits including user recerts, compliance testing.
- Manage the planning, testing, and implementation of new projects, systems, products and regulatory changes impacting the unit (dept).
- Act as lead for departmental system support, coordinating with business partners, vendors and technology to address issues for the unit (dept).
- Adhere to applicable compliance/operational risk controls in accordance with Company or regulatory standards and policies.
- 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.
Acts as an advisor and coach to mentor junior team members
May provide direction and leadership to more junior staff
Education and Experience Required:Bachelor’s degree and a minimum of 4 years related business line experience,
OR in lieu of,
A combined minimum of 8 years higher education and/or work experience
Power BI and/or SQL experience
M&T Bank is committed to fair, competitive, and market-informed pay for our employees. The pay range for this position is $71,985.72 - $119,976.20 Annual (USD). The successful candidate’s particular combination of knowledge, skills, and experience will inform their specific compensation.LocationBuffalo, New York, United States of AmericaTop Skills
What We Do
M&T Bank is a multi-state community-focused bank serving New York, Maryland, New Jersey, Pennsylvania, Delaware, Connecticut, Virginia, West Virginia and Washington, D.C. Founded in 1856, the company provides banking, investment, insurance and mortgage financial services to more than 3.6 million consumer, business and government clients.
