Sr. Data Analyst - Tableau Developer

KeyBank; Brooklyn (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

KeyBank is seeking a data visualization professional to design and maintain Tableau dashboards that support regulatory compliance and risk management. You will work with REA, Risk Management, Internal Audit, Data Analytics, and Technology to convert data into actionable insights for oversight.

Ideal candidates have strong Tableau and SQL skills, experience with large datasets, and a solid understanding of banking processes.

Qualifications

• Bachelor's Degree in IT/Systems, analytics, CS or related field.
• Minimum 2 years' data analysis and reporting experience in risk/compliance or audit contexts.
• Strong SQL skills with complex joins and performance optimization.
• Experience with banking products and transactional/customer data.

Responsibilities

• Design, develop, and maintain Tableau dashboards and scorecards for risk monitoring.
• Collaborate with business teams to gather reporting requirements and translate into solutions.
• Analyze data to identify trends, assess compliance, and determine root causes.
• Develop data models and visualization standards for regulatory reporting.
• Connect Tableau to SQL Server, cloud warehouses, data lakes, and reporting repositories.

Skills

SQL

Tableau

Data Visualization

Excel

Analytical Thinking

Communication

Problem Solving

Collaboration

Education

Bachelor's Degree in IT/Systems

Tools

Tableau Desktop

Tableau Server/Cloud

Python

SAS

BigQuery

Power BI

Job description

Location

4910 Tiedeman Road, Brooklyn Ohio

Job Description

As part of Key's second line-of-defense Compliance Risk Management function, the Risk Evaluation and Assurance Program (the "REA Program") has the responsibility for evaluating Key's ongoing compliance with applicable laws and regulations through the execution of compliance and operational risk monitoring and testing across Key's lines of business, products, and functional activities. This role will be responsible for designing, developing, and maintaining Tableau dashboards and reporting solutions that support regulatory compliance, risk management, control monitoring, and executive decision-making. The ideal candidatde possesses strong data visualization skills, experience working with large and complex datasets, and an understanding of governance, risk, and compliance processes. This individual will work closely with REA, Risk Management, Internal Audit, Data Analytics, and Technology partners to transform data into actionable insights that support effective risk oversight and regulatory compliance.

Essential Job Functions

• Work within a team of risk evaluation and assurance professionals, working to design, develop, and maintain Tableau dashboards, scorecards, and self-service reporting solutions to provide an independent second-line-of-defense approach to risk-based monitoring, testing, and analytics.
• Demonstrate strong collaboration skills by partnering with business teams to gather reporting requirements and translate them into scalable analytical solutions.
• Explore and analyze data to identify trends and outliers, evaluate compliance with internal policy/procedures and/or regulatory requirements, and assess root cause(s) of any issues identified.
• Develop data models and data visualization standards that support regulatory reporting, compliance monitoring, control testing, risk assessments, and issue management activities. Ensure data accuracy through validation, reconciliation, and quality assurance procedures. Optimize Tableau workbooks for performance, usability, scalability, and maintenance.
• Connect Tableau to multiple data sources, including SQL Server, cloud-based data warehouses, data lakes, and enterprise reporting repositories.
• Develop and support automated reporting processes and recurring management reporting packages. Create technical documentation, data dictionaries, and user training materials.
• Support audits, regulatory examinations, and management inquiries related to compliance reporting and analytics.
• Working knowledge, as well as ability and interest in maintaining, and continuously developing knowledge of banking products (e.g. - lending, deposits, etc.) and ability to understand its applicability to data analytics, testing, and monitoring strategies.
• Ability and interest in developing knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks.

Required Qualifications

• Bachelor's Degree in Information Technology/Systems (IT / MIS), Business Analytics, Computer Science, or other related quantitative or IT field of study.
• Minimum 2 years of practical and functional experience in data analysis and reporting typically achieved through work as a: business, data, operations, compliance, or risk analyst; internal auditor; or role that includes significant aspects of the listed essential job functions.
• Strong SQL skills, including complex joins, aggregations, window functions, and performance optimization.
• Skill and ability to work with big data and navigate data warehouse(s) and retrieving, combining, and analyzing data.
• Experience with retrieving and a proficient understanding of banking products and transactional data and customer information data.
• Autonomous, self-motivated, and flexible with the ability to adapt quickly to change or shifting priorities in a fast-paced environment.
• High ethical standards, strong critical/strategic thinking, detective, analytical, and problem-solving skills.
• Strong interpersonal skills, effective communication (verbal and written) with the ability to develop and maintain strong, collaborative relationships in a team environment and with mid- to senior-level management and internal clients.
• Required Technical Skills: Tableau Desktop, Tableau Server / Tableau Cloud, SQL, Data Visualization and Dashboard Design, Microsoft Excel

Preferred Skills/Competencies

• Knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks.
• Advanced knowledge, professional certification, or expertise in database querying, data transformation, data visualization, and/or analytical software or programming languages (e.g. SAS, SQL, ACL, Tableau, etc.)
• Preferred Technical Skills: Python, SAS, BigQuery, Power BI, ETL and Data Integration Tools

COMPENSATION AND BENEFITS

This positio