Sr. Data Analyst - Tableau Developer

KeyBank • Brooklyn, OH

2d • $80,000 - $150,000 • Hybrid

About The Position

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 candidate 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.

Requirements

• Bachelor’s Degree in Information Technology/Systems (IT / MIS), Business Analytics, Computer Science, or other related quantitative or IT field of study.
• 2 to 4 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.
• Tableau Desktop, Tableau Server / Tableau Cloud, SQL, Data Visualization and Dashboard Design, Microsoft Excel

Nice To Haves

• 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.).
• Python, SAS, BigQuery, Power BI, ETL and Data Integration Tools

Responsibilities

• 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.
• Partner 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.
• Maintain and continuously develop knowledge of banking products (e.g. – lending, deposits, etc.) and understand its applicability to data analytics, testing, and monitoring strategies.
• Develop knowledge of financial services industry source systems (e.g. loan origination/servicing, deposits, etc.), operations/process flows, banking regulations, and compliance frameworks.

Benefits

• Eligibility for incentive compensation which may include production, commission, and/or discretionary incentives.
• A list of benefits for which this position is eligible.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level