CTC Data Analyst III

About Working at Commerce

Wouldn't it be great to build your career at a bank that's known for helping people with their financial challenges? That's exactly what you'd be doing when you join the team at Commerce Bank. We're looking for teammates who are ready to do whatever it takes to help our customers with their everyday financial needs. You'd be helping yourself too, because Commerce has a tradition of recognizing and rewarding team members for their talent, skills and contributions.

No wonder we've been an industry leader for over 155 years and have developed a reputation as a great place to work in the financial services world. If you'd like to be a part of a team and culture that is respected by its peers and in your community, we should talk. We're always looking for the best and brightest.

Since 1906, Commerce Trust, a division of Commerce Bank, has been a leading provider of investment management, financial planning, trust and private banking services. Commerce Trust provides a full range of wealth and investment planning services to individuals and institutions. We build a comprehensive team around our client's unique personal and financial situation, managing their wealth and helping them achieve their long-term goals. Commerce Trust received the 2019 Highly Commended Private Wealth Manager Award (Over $5 Billion) by Private Asset Management and 2021 Global Finance's Best Private Banking Award for the Midwest Region. Commerce Trust administers over $57 billion in total client assets.

About this Job

The main purpose of this job is to provide essential data analysis and reporting that are crucial to making smart business decisions for the Private Bank, a division of Commerce Trust. This job will support multiple simultaneous initiatives surrounding process improvements, complex data analysis and data integrity. This job will work with with management to develop, interpret and implement reporting and data integrity best practices to drive strategic planning, budgeting and on-going support. This job will also be responsible for the accurate and timely execution of monthly/quarterly/annual internal management reporting processes to support business initiatives.

Essential Functions

• Collaborate and provide guidance to others, at all levels in the organization, to identify, understand & fulfill business reporting and/or data needs
• Design, test, and assess data prior to producing results
• Utilize various data sources to generate reports, data analytics, file transmissions etc.
• Identify problem trends in data and make recommendations for improvements/solutions to management
• Clean up data with ongoing oversight into data integrity based on business standards
• Collect data and update systems information via manual input or upload
• Assist Commerce Trust Company (CTC) team members with various systems projects, as requested
• Identify and maintain documentation of data sources and business unit resources
• Perform other duties as assigned

Knowledge, Skills & Abilities Required

• Strong knowledge of data analytics, including best practices. Expertise in available data sources and tools.
• Ability to communicate in user-friendly language to both technical and non-technical end-users
• Effective relationship-building skills
• Intermediate database knowledge
• Ability to troubleshoot and problem solve
• Demonstrate ability to analyze information and identify transactions outside normal patterns
• 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
• Moderate to Advanced level proficiency with data extraction tools and technologies (prefer ACL, Business Objects, AQT, SQL or similar) and familiarity with databases
• Advanced level proficiency with Microsoft Word, Excel, Access, Teams, and Outlook
• Ability to maintain a high degree of confidentiality

Education & Experience

• Bachelor's degree in Information Systems or Business, or equivalent combination of education and experience required
• 4+ years experience in data analytics required
• Experience in finance or wealth management preferred

Location: 922 Walnut St, Kansas City, Missouri 64106

Time Type:

Full time