Data Analyst - EABI

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 more than 155 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

Annual Salary: $68,500.00 - $104,000.00 (Amount based on relevant experience, skills, and competencies.)

About This Job

The main purpose of this job is to perform report development and data analysis that help business lines obtain information needed to make strategic & tactical decisions to grow revenue and/or reduce expense. This position identifies opportunities for process automation and enhancements to existing reporting to keep pace with their business clients' changing needs and improve overall efficiency.

Essential Functions

• Develop reporting solutions and process automation for Enterprise Analytics clients to support strategic decision-making and to meet regulatory requirements
• Develop reporting, dashboard, and visualization solutions in SAP Business Objects and Microsoft Power BI
• Create database queries using SQL on Teradata and other relational databases or big data environments
• Model semantic layers for business intelligence tools between data sources and reporting levels
• Identify opportunities to increase efficiency through process automation
• Collaborate with IT partners to facilitate the secure movement and accurate storage of data
• Perform requirements gathering with internal business line partners to understand client's needs
• Perform analysis of key business line and enterprise metrics for management
• Create process documentation and perform code/process reviews
• Perform other duties as assigned

Knowledge, Skills, & Abilities Required

• Working knowledge of SAP Business Objects, Microsoft Power BI, or other business intelligence software
• SQL query development skills
• Strong understanding of relational databases
• Exposure to data modeling or data architecture concepts
• Foundational knowledge of Python preferred
• Strong problem-solving ability, creativity to interpret design requirements, and understanding of logical process flow
• Ability to leveraging education, colleagues, self-initiative, and training opportunities to develop solutions
• 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 communicate clearly and concisely to individuals of various backgrounds and levels of knowledge.
• Ability to influencing others in both verbal and written communication
• 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
• Advanced level proficiency with Microsoft Word, Excel, Teams and Outlook
• Exposure to Workday reporting development preferred

Education & Experience

• Bachelor's Degree in Information Systems or related field, or equivalent combination of education and experience required
• 2+ years experience in Data Analyst, Business Intelligence Analyst, or similar position required
• Experience developing SAP Business Objects universes preferred
• Experience with talent data, people data, or Human Resources Management Information Systems data strongly preferred
• Workday experience strongly preferred
• Workday reporting development experience preferred

**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 Data Analyst II - EABI & Data Analyst III - EABI 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, it is not typical for an individual to be hired at or near the top of the range for their role, and compensation decisions are dependent on the facts and circumstances of each situation. A reasonable estimate of the current base pay is $68,500 to $104,000 annually. Depending on the job level, this position may be eligible for additional compensation through performance-based incentive plan(s) that will correspond to meeting performance goals. 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.

#LI-Remote

Location: 811 Main St, Kansas City, Missouri 64105

Time Type:

Full time