Systems Analyst - CMG

commercebank; Kansas City (MO); Hybrid; USD 82,000 - 109,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k)

Life insurance

Paid vacation

Paid personal time

Job summary

Commerce Bank is seeking a Systems Analyst III & Senior for CMG to provide critical data analysis and reporting to support smart business decisions.

The role requires strong SQL, finance domain knowledge, and experience with financial systems. Hybrid in-office 3 days/week in Kansas City, MO. Must be eligible to work in the US without sponsorship.

Qualifications

• Bachelor's degree in finance or accounting required.
• 3+ years financial services experience required.
• 2+ years systems experience required.
• FIS InTrader experience a plus.
• Series 52, 7, 63, and SIE desired or ability to obtain.

Responsibilities

• Serve as a business and systems resource, implementing technical solutions to business needs.
• Utilize systems to generate reports and develop and produce requested reports.
• Monitor systems and databases for functionality and availability to users, troubleshoot, and respond to user inquiries.
• Research, analyze, assist with the design, testing, and implementation of applications, sometimes cooperating with internal departments and vendors.
• Collect data and update systems information via manual input or upload.
• Review, analyze, and evaluate business systems and user needs.
• Document business and systems requirements, translate requirements into specifications, and formulate systems to reflect business unit strategies.
• Provide audit support, consultation, and recommendations to business teams in resolving technical problems.
• Perform other duties as assigned.
• Provide reliable analysis used in decision-making around funding stability, pricing, and balance sheet optimization.
• Contribute insights that influence enterprise-level funding and collateral strategy beyond day-to-day system support.
• Provide support to the Public Entity Collateralization team.
• Act as liaison between Corporate Finance, product, operations, and deposit partners to ensure liquidity and collateral strategies are executable.

Skills

SQL

SharePoint

Excel

Business Objects

Finance knowledge

Attention to detail

Communication skills

Team player

Adaptable

Education

Bachelor's degree in finance or accounting

3+ years financial services experience

2+ years systems experience

FIS InTrader experience

Series 52, 7, 63, and SIE desired

Tools

FIS InTrader

Job description

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

Annual Salary: $82,000.00 - $109,000.00 (Amount based on relevant experience, skills, and competencies.)

About This Job

The main purpose of this job is to provide critical support on a wide variety of applications and to provide essential data analysis and reports that are crucial to making smart business decisions

Essential Functions

• Serve as a business and systems resource, implementing technical solutions to business needs
• Utilize systems to generate reports and develop and produce requested reports
• Monitor systems and databases for functionality and availability to users, troubleshoot, and respond to user inquiries
• Research, analyze, assist with the design, testing, and implementation of applications, sometimes working in cooperation with internal departments and vendors
• Collect data and update systems information via manual input or upload
• Review, analyze, and evaluate business systems and user needs
• Document business and systems requirements, define scope and objectives, translate requirements into specifications, and formulate systems to reflect business unit strategies
• Provide audit support, consultation, and recommendations to business teams in resolving technical problems
• Perform other duties as assigned
• Provide reliable analysis used in decision-making around funding stability, pricing, and balance sheet optimization
• Contribute insights that influence enterprise-level funding and collateral strategy beyond day-to-day system support
• Provide support to the Public Entity Collateralization team
• Act as liaison between Corporate Finance, product, operations, and deposit partners to ensure liquidity and collateral strategies are executable

Knowledge, Skills & Abilities Required

• Intermediate computer skills, specifically with SQL, SharePoint, Excel, and Business Objects
• Knowledge of finance and fixed income accounting commonly used concepts and best practices
• 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
• Intermediate level proficiency with Microsoft Word, Excel, Teams, and Outlook

Education & Experience

• Bachelor's degree in finance or accounting, or equivalent combination of education and experience required
• 3+ years financial services experience required
• 2+ years systems experience required
• FIS InTrader experience a plus
• Series 52, 7, 63, and SIE desired, or able to obtain within specified time frame if requested

*Hybrid Schedule: In office 3 days 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 Systems Analyst III & Senior - CMG 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 $82,000 to $109,000 annually.

#LI-AC2

#LI-Hybrid

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

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, educatio