Data & BI Senior Assoc

KeyBank; Town of Amherst (NY); Hybrid; USD 80,000 - 150,000; Full time

Job summary

KeyBank is seeking a Senior Data & Business Intelligence Associate to source, validate, and prepare data for production reports and analytical datasets. You will leverage SQL and Python to produce complex reports and descriptive analyses that answer business questions.

In this role, you will collaborate with technology partners and business stakeholders to engineer BI solutions, automate processes, and deliver insights that drive improvements while ensuring governance and regulatory compliance.

Qualifications

• Bachelor’s degree with at least 6 years of relevant experience, or Master’s degree with at least 4 years.
• Proficient in Advanced Excel and PowerPoint.
• Intermediate/advanced query writing with complex joins; Python or SQL preferred.
• Intermediate/advanced data visualization.
• Analytical programming languages.
• Report and process automation.
• Knowledge of Google Cloud technologies and data warehousing.
• Experience using Generative AI to automate reporting and analytics.

Responsibilities

• Provide moderate to more complex analysis and reports, leveraging critical thinking and business acumen to source and translate data into business intelligence insights, reports, and analysis that answer business problems
• Collaborate and lead conversations with business and technology partners to identify and understand analytic / business needs
• Automate and standardize reports for production
• Make process improvement suggestions
• Effectively communicate key points to respective stakeholders, with the right amount of detail
• Review work product of junior staff; provide input, direction, and mentorship

Skills

Excel

PowerPoint

SQL

Python

Data Visualization

Analytical Skills

Automation

Google Cloud

Data Warehousing

Generative AI

Education

Bachelor’s degree in Data Analytics or related field

Master’s degree in Data Analytics or related field

Tools

Google Cloud Platform

SQL Tools

BI Tools

Job description

Job Summary

The Senior Data & Business Intelligence Associate is primarily responsible for the sourcing, manipulation, preparation, and validation of data for consumption – which may be in the form of production reports or as analytical data sets to answer questions or to perform predictive analysis. The Senior Data & Business Intelligence Associate uses queries and data mining to produce more complex reports and descriptive analysis that provide answers to questions such as “How do I measure?” and “What happened?”. Through self-managed data sourcing projects, the Senior Data & Business Intelligence Associate should liaise between technology partners and the business to engineer data into insightful business intelligence solutions, process improvements / automations, and reports. Success criteria include: leveraging critical thinking, technical expertise, and anticipation of business needs from technology and business partners to provide reporting and analysis or implement process improvements; leading conversations with business partners and effectively communicate with all stakeholders; and providing solutions based on an understanding of impacts / intersections with other business partners and lines of business.

Location

4910 Tiedeman Road, Brooklyn Ohio

ESSENTIAL JOB FUNCTIONS

• Provide moderate to more complex analysis and reports, leveraging critical thinking and business acumen to source and translate data into business intelligence insights, reports, and analysis that answer business problems
• Collaborate and lead conversations with business and technology partners to identify and understand analytic / business needs
• Automate and standardize reports for production
• Make process improvement suggestions
• Effectively communicate key points to respective stakeholders, with the right amount of detail
• Review work product of junior staff; provide input, direction, and mentorship

REQUIRED QUALIFICATIONS

• Bachelor’s degree (or its equivalent) in Data Analytics, Business Management, Finance, Economics, Engineering, Computer Science, Management Information Systems, or Statistics (or other related field) with at least 6 years of relevant experience; or Master’s degree (or its equivalent) in Data Analytics, Business Management, Finance, Economics, Engineering, Computer Science, Management Information Systems, or Statistics (or other related field) with at least 4 years of relevant experience
• Proficient in:
• Advanced Microsoft Excel / PowerPoint
• Intermediate/advanced query writing/coding including complex joins. Python or SQL preferred.
• Intermediate/advanced data visualization
• Analytical programming languages
• Report and process automation
• Knowledge or Skill in:
• Process flow
• Project management
• Google Cloud technologies and tools
• Navigation of data warehouse and/or data supply chain
• Utilizing Generative AI and agentic technologies to automate reporting processes, accelerate analytics, improve data discovery, generate business insights, and optimize operational workflows while maintaining data governance and regulatory compliance

EXPECTED COMPETENCIES

• Communication: Solid written and verbal communication skills; organizes material for brevity, persuasiveness, and impact; Effectively communicates key points to respective stakeholders, with the right amount of detail; Proactively shares information beyond those at the table who may have a need to know; Comfortable in situations where conflict is present; Demonstrated presentation development and delivery skills; Ability to create presentations that include the right data/information and tell the right story
• Leadership: Emerging leader across team; Serves as a role model – may coach and develop others; Provides direction / mentorship to junior staff
• Partnering / Influencing: Proven relationship building ability; Strong interpersonal skills; Can lead the conversation with business partners; Sought out to by business partners and team members; May coach and develop relationship building skills in others; Developing comfort with influencing and consulting typically with mid-level leaders
• Business Acumen: Understands assigned LOB strategy; Knows our industry, competition, and competitive environment; Possesses intellectual curiosity; Understands key drivers of financial results and business impact; Developing understanding of how business works
• Critical Thinking / Problem Solving: Leverages critical thinking and business acumen to provide solutions to increasingly more complex problems; Ties work with understanding of impacts / intersections with other business partners / LOB; Aware of potential pitfalls with each recommended solution; thoroughly vets and thinks through options before making a decision

Core Competencies

• All KeyBank employees are expected to demonstrate Key’s Values and abide by Key’s Code of Conduct.

Physical Demands

• General Office - Prolonged sitting, ability to communicate face to face in person or on the phone with teammates and clients, frequent use of PC/laptop, occasional lifting/pushing/pulling of backpacks, computer bags up to 10 lbs.

Work Location Category

• Hybrid (2+ days)

Compensation And Benefits

This position is eligible to earn a base salary in the range of $80,000.00 - $150,000.00 annually. Placement within the pay range may differ based upon various factors, including but not limited to skills, experience and geographic location. Compensation for this role also includes eligibility for incentive compensation which may include production, commission, and/or discretionary incentives.

Key has implemented an approach to employee workspaces which prioritizes in-office presence, while providing flexible options in circumstances where roles can be performed effectively in a mobile environment.

KeyCorp is an Equal Opportunity Employer committed to sustaining an inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, pregnancy, disability, veteran status or any other characteristic protected by law.

Qualified individuals with disabilities or disabled veterans who are unable or limited in their ability to apply on this site may request reasonable accommodations by emailing [e-mail].

Job Posting Expiration Date: 10/15/2026