Data Solutions Analyst (Regional Reporting Team)

M&T Bank; Buffalo (NY); On-site; USD 86,000 - 143,000; Full time

Job summary

M&T Bank in Buffalo, NY seeks a data analytics professional to develop and deliver BI solutions across reporting and enterprise initiatives. You will partner with Data Engineering and Data Visualization leads to acquire, transform, validate, and present data through scalable assets and dashboards.

Responsibilities include data workflow automation, governance, testing, and ad hoc reporting. Ideal candidates have 4+ years in data analysis, SQL/Python skills, and experience with BI tools within an

Qualifications

• Bachelor’s degree with 3+ years experience, or 7 years combined education/work experience
• Experience with large datasets and relational databases
• Experience developing SQL queries and performing data analysis
• Familiarity with BI, reporting, or data visualization tools
• Experience translating business requirements into reporting or analytical solutions

Responsibilities

• Compile, explore, transform, and validate data from multiple sources for reporting and analytics
• Develop, maintain, and document automated data workflows and reporting assets
• Perform data profiling, reconciliation, and quality assurance
• Support data governance through data definitions and transformation rules
• Build and maintain dashboards, scorecards, reports, and visualizations
• Collaborate with business partners to translate requirements into reporting solutions
• Assist with recurring and ad hoc reporting requests and automate where possible
• Deliver scalable, governed reporting solutions with data engineering and visualization leads
• Share knowledge and document processes for continuous improvement

Skills

Data analysis

SQL

Python

BI / Visualization

Agile methods

Education

Bachelor’s degree

Tools

BI tools

Job description

OVERVIEW

Supports the development and delivery of data, reporting, and business intelligence solutions that enable informed decision-making across regional reporting and enterprise initiatives. Partners with Data Engineering and Data Visualization leads to acquire, transform, validate, and present data through scalable reporting assets, automated processes, and interactive dashboards.

Supports the development and delivery of data, reporting, and business intelligence solutions that enable informed decision-making across regional reporting and enterprise initiatives. Partners with Data Engineering and Data Visualization leads to acquire, transform, validate, and present data through scalable reporting assets, automated processes, and interactive dashboards. Contributes to the modernization of reporting capabilities by supporting ETL development, report automation, data governance, and business intelligence initiatives that improve access to trusted, actionable insights.

POSITION RESPONSIBILITIES

• Compile, explore, transform, and validate data from multiple internal and external data sources for reporting and analytics purposes.
• Develop, maintain, and document automated data workflows and reporting assets used across reporting and analytics solutions.
• Perform data profiling, reconciliation, and quality assurance activities to ensure accuracy and consistency of outputs.
• Support data governance initiatives through documentation of data definitions, business rules, and transformation logic.
• Build and maintain dashboards, scorecards, reports, and visualizations. Partner with Data Visualization leads to ensure adherence to reporting standards, visualization best practices, and user experience expectations.
• Support dashboard testing, deployment, enhancement, and ongoing maintenance activities.
• Collaborate with business partners to understand reporting needs and support data-driven decision making. Translate business requirements into reporting solutions that provide actionable insights to business partners and leadership.
• Assist with recurring and ad hoc reporting requests while identifying opportunities to improve efficiency through automation.
• Partner closely with Data Engineering lead and Data Visualization lead to deliver scalable and governed reporting solutions.
• Share knowledge, document processes, and contribute to continuous improvement efforts across the team.
• Provide support and training to stakeholders as needed.
• 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.

MANAGERIAL/SUPERVISORY RESPONSIBILITY

No supervisory responsibility.

MINIMUM QUALIFICATIONS REQUIRED

• Bachelor’s degree and a minimum of 3 years of related experience, or in lieu of a degree, a combined minimum of 7 years higher education and/ or work experience, including a minimum of 3 years related experience
• Experience working with large datasets and relational databases.
• Experience developing SQL queries and performing data analysis.
• Familiarity with business intelligence, reporting, or data visualization tools.
• Experience translating business requirements into reporting or analytical solutions.

IDEAL QUALIFICATIONS PREFERRED

• 4 or more years related work experience in data analysis
• Intermediate skills in programming languages such as SQL, Python
• Experience working with a statistical analysis software package
• Experience with one or more cloud databases.
• Experience working within an agile environment

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

Location

Buffalo, New York, United States of America