Data Visualization Analyst

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

Job summary

M&T Bank Corporation in Buffalo, NY is seeking a BI Visualization Specialist to design and publish advanced dashboards and reports. You will collaborate with data teams to query and structure data, ensuring visuals follow templates and enable data-driven decisions.

The role emphasizes UAT support, risk awareness, and adherence to controls. The ideal candidate has 3+ years of Power BI dashboard experience, strong SQL skills, and familiarity with DAX and Power BI REST APIs.

Qualifications

• Bachelor’s degree or equivalent with 3+ years of related BI experience.
• 3+ years creating dashboards and reporting using Power BI.
• Experience with SQL to analyze, extract and transform data.
• Knowledge of DAX for data analysis and transformation.

Responsibilities

• Leverage BI platforms to structure and create advanced visuals.
• Publish dashboards/reports, manage access and permissions.
• Query and structure data with data teams for dashboards.
• Support analytics through descriptive and diagnostic visuals.
• Ensure visuals follow established templates and standards.
• Assist in user acceptance testing and defect documentation.
• Adhere to risk, regulatory standards and internal controls.

Skills

Power BI dashboards

SQL

DAX

Power BI REST APIs

Power Automate

Education

Bachelor’s degree in a related field

Tools

Power BI

SQL

Power BI REST APIs

Power BI DAX

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.

PAY RANGE

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

COMPANY OVERVIEW

Great companies have an enduring sense of purpose. At M&T, our purpose is a simple one: make a difference in people’s lives and uplift the communities we serve.

M&T Bank Corporation is a financial holding company headquartered in Buffalo, New York. M&T’s affiliates offer advice, guidance, expertise and solutions across the entire financial spectrum, combining M&T Bank’s traditional banking services with the wealth management and institutional capabilities offered by Wilmington Trust. M&T Bank has a network of over 1,000 branches and 2,200 ATMs that span 12 states from Maine to Virginia and Washington, D.C. For more than 165 years, M&T has striven to take an active role in our communities and build long-lasting relationships with our customers. We are a bank for communities—combining the capabilities of a large bank with the care of a locally focused institution.

As an employer of choice, we are proud to offer competitive benefits ranging from medical and retirement to forty hours of paid volunteer time, each year. Our core values – integrity, ownership, collaboration, curiosity, and candor – drive the work we do. We seek to further build upon our record of success by bringing in top talent and fresh skill sets while continuing to support the growth and development of all our team members.

View M&T’s Human Capital Report to learn more.

EMPLOYMENT POLICY

M&T Bank is unwavering when it comes to providing equal employment opportunities to all employees and applicants without regard to race, color, national origin, religion, ethnicity, sex, gender identity, age, disability, citizenship, pregnancy, veteran status, military status, marital status, sexual orientation, genetic information or any other characteristic protected under applicable federal, state or local laws.

M&T Bank Corporation has policies and procedures in place to promote a drug free workplace.