Senior Business Analytics & Reporting Analyst - BSA/AML (hybrid Buffalo, NY)
About The Position
This position provides advanced support to a business unit across several simultaneous projects and programs. The analyst develops new reports and dashboards, expands existing metrics, recommends data improvements, and represents the unit in high-visibility, cross-functional projects with business partners. The role also streamlines ongoing activities and serves as a technical subject matter expert for the department’s reporting and data environment. The analyst develops and maintains Git-based source control and CI/CD practices for reporting and analytics solutions, applies SQL performance and optimization principles, and uses working knowledge of Microsoft SQL Server architecture and connectivity. The role produces complex analysis, reports, and spreadsheets; communicates data-driven insights to management; improves processes through documentation and automation; and supports departmental planning, audits, systems, and regulatory changes. The position is located in Buffalo, New York, and is described as hybrid. The annual pay range is $62,200 to $103,600 USD. A bachelor’s degree and at least three years of related business-line experience are required, or a combined minimum of seven years of higher education and/or work experience in lieu of a degree.
Requirements
- Bachelor’s degree and a minimum of 3 years of related business-line experience, or, in lieu of a degree, a combined minimum of 7 years of higher education and/or work experience.
- Working knowledge of Microsoft SQL Server architecture, including databases, linked servers or connections, authentication, service accounts, database permissions, and connectivity across data sources and environments.
- Ability to apply SQL performance and optimization principles.
- Ability to develop and maintain Git-based source control and CI/CD practices for reporting and analytics solutions.
Responsibilities
- Develop and maintain Git-based source control and CI/CD practices for reporting and analytics solutions, including repositories, branching strategies, version control, peer review, and deployment pipelines.
- Apply SQL performance and optimization principles, including efficient joins, indexing considerations, query execution plans, filtering, data aggregation, and minimizing unnecessary movement or duplication of large datasets.
- Serve as a technical subject matter expert for the departmental reporting and data environment; understand end-to-end architecture, identify inefficient or high-risk design patterns, and recommend scalable, supportable, and automated solutions.
- Develop and produce mid- to high-complexity departmental reports and spreadsheets, including project or product strategy analysis, historical reporting, workflow analysis, and financial analysis.
- Identify trends and emerging issues; engage stakeholders to develop project plans, organize virtual and physical events, synthesize differing viewpoints, and communicate findings through white papers, reports, and other formats.
- Perform complex analysis and judgment-based work across multiple disciplines to support business decisions.
- Analyze large amounts of data and information to provide meaningful insights and communicate those insights professionally to management.
- Drive continuous improvement of existing processes and develop or enhance processes, maintenance plans, procedural documentation, and custom automation tools.
- Identify resources to support business operations or improve processes, and provide input and recommendations to management.
- Participate in planning and implementing projects, programs, and plans to achieve short- and long-term business objectives; coordinate project design and execution.
- Lead support for departmental audits, including user recertifications and compliance testing.
- Manage planning, testing, and implementation of projects, systems, products, and regulatory changes affecting the department.
- Lead departmental system support and coordinate with business partners, vendors, and technology teams to address issues.
- Adhere to applicable compliance and operational risk controls in accordance with company and regulatory standards and policies.
- 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 and applicable issues raised by external regulators.
- Complete other related duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
