Data Visualization Analyst

M&T Bank; South Dakota; On-site; USD 86,000 - 143,000; Full time

Benefits offered by this job

Competitive pay

Job summary

M&T Bank in Buffalo, NY seeks a BI Visualization Specialist to develop advanced visuals and dashboards using Power BI. You will structure and publish dashboards, collaborate with data teams to prepare data, and ensure visual consistency with templates and standards.

Strong SQL and DAX skills are expected, plus experience with REST APIs in Power BI. Ideal candidates will have a bachelor’s degree or equivalent plus 3+ years of dashboard/reporting experience, and a solid grasp of data

Qualifications

• Bachelor’s degree or equivalent required; 3+ years related experience preferred.
• Minimum 3 years experience creating dashboards and reporting using Power BI.
• Experience using SQL to analyze, extract, and transform data.
• Experience using DAX for data extraction and transformation.

Responsibilities

• Leverage BI platforms to create advanced visuals and dashboards.
• Publish dashboards/reports and manage access and permissions.
• Collaborate with data teams to query and structure data for visualizations.
• Support diagnostics and descriptive analytics to identify trends and outliers.
• Create visuals using established templates and themes for consistency.
• Support user acceptance testing of data visualizations and document defects.

Skills

Power BI

SQL

DAX

Rest APIs (Power BI)

Data Visualization

Education

Bachelor’s degree or equivalent

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.

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