Data Visualization Analyst

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

Job summary

M&T Bank is seeking a BI analyst to develop and refine descriptive and diagnostic visuals using established templates to enable data informed decisions. You will structure dashboards, publish reports, and collaborate with data teams.

The role emphasizes Power BI, SQL, and DAX skills with experience building dashboards and applying visual storytelling. Buffalo, NY area; competitive pay and compliance awareness are offered.

Qualifications

• 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
• Minimum of 3 years experience creating Dashboards and Reporting using Power BI
• Experience developing basic dashboards/reports and data visualizations
• Intermediate knowledge of data visualization approaches
• Experience using SQL to analyze, extract, and transform data
• Experience using DAX to analyze, extract and transform data

Responsibilities

• Leverage BI platforms to structure and create advanced charts, graphs and other visuals
• Navigate and publish BI dashboards/reports, provide access, and manage permissions
• Query and structure data for use in dashboards/reports with SQL
• Support creation of visualizations using metadata and established templates
• Develop descriptive and diagnostic reporting to identify trends and outliers
• Adhere to risk, regulatory standards and internal controls
• Assist in user acceptance testing and document defects

Skills

Data visualization

SQL

DAX

Dashboard design

Education

Bachelor’s degree

Tools

Power BI

SQL

DAX

Rest APIs

Power Automate

Job description

OVERVIEW

Develops and refines descriptive and diagnostics visuals utilizing established templates and standards to enable data informed decisions. Assists in dashboard/report user acceptance.

OVERVIEW

Develops and refines descriptive and diagnostics visuals utilizing established templates and standards to enable data informed decisions. Assists in dashboard/report user acceptance.

POSITION RESPONSIBILITIES

• Leverage one or more Business Intelligence (BI) platforms to structure and create advanced charts, graphs and other visuals.
• Navigate and publish BI dashboards/reports, provide access, and manage permissions
• Use knowledge of programming languages to work with data teams to query and structure data for use in dashboards/reports.
• Use intermediate knowledge of business and technical metadata to support creation of visualizations.
• Support business insights through the development of descriptive and diagnostic reporting by selecting appropriate visuals to identify trends and outliers.
• Use established templates, standards and themes to create uniform visuals for a given audience.
• Assist business partners and more experienced visualization team members in conducting user acceptance testing of data visualizations, documenting identified defects and refining dashboards/reports.
• 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 belonging 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

None

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
• Minimum of 3 years experience creating Dashboards and Reporting using Power BI
• Experience developing basic dashboards/reports and data visualizations
• Intermediate knowledge of data visualization approaches
• Experience using Structured Query Language (SQL) to analyze, extract, and transform data
• Experience using DAX to analyze, extract and transform data

IDEAL QUALIFICATIONS PREFERRED

• 5+ Years experience creating Dashboards and Reporting using Power BI
• 5+ years experience in Power BI DAX queries and optimization
• 3+ years experience in utilizing Rest APIs in Power BI
• Experience with Row Level Security in Power BI
• Experience with the Power Automate platform
• Proven design experience across fields such as data, user experience, and/or graphics
• Knowledge of data management concepts and terminology
• Knowledge of SCCM, Ivanti, Jira, and ServiceNow
• Knowledge of Cybersecurity capabilities and reporting
• Certification in data storytelling and/or data visualization tools

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