IT Data Analyst

About Working at Commerce 

Building a career here is more than just steps on a ladder. It’s about helping people find financial safety and success, helping businesses thrive, and making sure people and their money are taken care of. And our commitment doesn’t stop there. Our culture is about our people, the ones in our communities and the ones that work with us.  

Here, you’ll find opportunities to grow and learn, to connect with others, and build relationships with the people around you. You’ll have the space and resources to grow into the best version of yourself. Because our number one investment is you.

Creating an award-winning culture doesn't come easy. And after 160 years, we know Commerce Bank is only at its best when our people are. If this sounds interesting to you, keep reading and let’s talk. 

Compensation Range

Hourly: $30.55 - $46.40 (Amount based on relevant experience, skills, and competencies.)

At Commerce Bank, innovation and creativity are the driving forces behind our IT team's success. We are catalysts of transformation who power applications, secure networks, and implement cutting-edge initiatives that propel our business units forward. The banking industry's rapid evolution provides us with an exciting opportunity to continuously learn, grow, and harness new technologies that elevate the experience for our customers. What sets Commerce Bank apart is our company culture and leadership, areas in which we continually invest. This commitment fosters innovation, enhances customer and employee experiences, while reinforcing our belief that our diverse team is our greatest competitive advantage. We actively seek candidates who share our passion for technology and bring fresh perspectives to the table. A diversity of backgrounds, experiences, and viewpoints allows us to develop truly innovative solutions that meet the evolving needs of our banking community. Join us in shaping the future of banking technology. At Commerce Bank IT, you'll find a culture of equity, belonging, and endless opportunities to make a lasting impact. Help us drive innovation that raises the bar for our industry. 

About This Job

The main purpose of this job is to leverage various vended and internal data sets to deliver meaningful reporting, analysis, and data solutions for IT leadership and other customers of the IT Project Management Office in support of delivering business strategic objectives.  

Job functions are approximately 80% report development/analysis, 20% other data solutions, and minimal consulting.

**Must be eligible to work in the US without sponsorship now or in the future 

Essential Functions

• Develop and maintain accurate recurring reporting with guidance from leadership

• Refresh, update, and investigate interactive visualization interfaces utilizing Planview/PowerBI/etc

• Design, develop and maintain interactive and visually pleasing PowerBI reports and dashboards with leadership guidance

• With guidance from leadership consult with our external Planview Enterprise partners and IT partners on data structure development, maintenance, troubleshooting and data transmission

• Meet deadlines with planning assistance from leadership

• Communicate and concisely present process results and methodology to manager and peers

• Adhere to department best practices and policies

• Perform other duties as assigned

Knowledge, Skills & Abilities Required

• Basic understanding of relational databases

• Ability to effectively utilize data visualization software (SAP Business Objects/ PowerBI/Tableau)

• Basic SQL query development skills

• Basic understanding of Project Management & Agile methodologies

• Willingness to assist team on complex projects

• Motivated and organized self-starter with strong attention to detail and the ability to manage multiple priorities

• Inquisitive, agile, and strong team player with excellent written, verbal, and interpersonal communication skills

• Ability to remain adaptable and resilient to all situations with an optimistic outlook and cast a positive shadow that is aligned with our culture and Core Values

• Exposure to Planview Enterprise

• Exposure to various programing languages

• Basic knowledge of Microsoft Word, Excel, Outlook, SharePoint and Teams

Education & Experience

• Bachelor’s degree in Data Analytics, Information Systems, or similarly related field or equivalent combination of education and experience required

• 2+ years data analysis experience required

*Hybrid Schedule: In office 1 day per week

**Level of role is determined by knowledge, experience, skills, abilities, and education

***For individuals applying, assigned and/or hired to work in areas with pay transparency requirements, Commerce is required by law to include a reasonable estimate of the compensation range for some roles.  This compensation range is for the IT Data Analyst I & II  job and contemplates a wide range of factors that are considered in determining most appropriate job level and making compensation decisions, including but not limited to location, skill sets, education, relevant experience and training, licensure and certifications, and other business and organizational needs. The disclosed range estimate has not been adjusted for any applicable differentials (geographic, bilingual, or shift) that could be associated with the position or where it is filled. At Commerce, compensation decisions are dependent on the facts and circumstances of each situation. A reasonable estimate of the current base pay is $30.55 to $46.40 per hour.

#LI-CR1

The candidate selected for this position may be eligible for the following employment benefits: employer sponsored health, dental, and vision insurance, 401(k), life insurance, paid vacation, and paid personal time. In addition, we offer career development, education assistance, and voluntary supplemental benefits.  Click here to learn more.

Location: 922 Walnut St, Kansas City, Missouri 64106

Time Type:

Full time