Business Systems Analyst III

The Alternative Investments Team provides accounting pricing and reconciliation services for our alternative investment fund clients. This group is a growing team that continues to add to our client portfolio. With additional clients and the evolution of client needs comes the opportunity to grow our knowledge base and expand our technological capabilities.

Were looking for a Business Systems Analyst III to help our alternative investments team scale beyond our current Excel-based infrastructure. As we onboard several large new clients we need someone who can both manage the hands-on work of bringing in new clients historical data and lead the effort to modernize the systems and validation processes that our team relies on every day.

This is a high-visibility role that sits at the intersection of fund accounting operations and systems/process design. Youll work directly with a team of experienced fund accountants who understand the business deeply but need a partner who can translate that institutional knowledge into scalable systematized workflows.

How you will spend your time:

• Client onboarding: Lead the ingestion and validation of historical data sets for new private equity hedge fund and fund-of-funds clients ensuring data integrity from day one.
• Process modernization: Evaluate our existing Excel-based validation processes (data scraped from source documents tied out against totals and cross-checked against a separate reporting system) and redesign them for a more scalable platform.
• Systems selection & implementation: Research recommend and help implement tools or platforms (e.g. database-backed solutions low-code platforms or custom applications) that can replace manual workbook-by-workbook validation with something that scales across a growing client base.
• Automation & tooling: Partner with our existing VBA/Excel automation to identify what should be migrated replaced or bridged during the transition minimizing disruption to daily operations.
• Documentation & training: Document new processes and train team members on new tools as theyre rolled out.
• Cross-functional collaboration: Work closely with fund accountants technology teams and client-facing staff to ensure new systems meet both operational and client-reporting needs.

What were looking for:

• Experience in business systems analysis process improvement or data operations ideally within financial services fund administration or asset management.
• Strong understanding of data validation and reconciliation concepts (tying data from one source system to another).
• Advanced Excel skills required; VBA experience is a strong plus since youll be working alongside significant existing Excel/VBA infrastructure.
• Experience with database concepts (SQL) and/or experience helping organizations move from spreadsheet-based processes to scalable systems (e.g. database applications workflow tools or reporting platforms).
• Ability to manage large data volumes and design processes that hold up as data volume grows.
• Strong communication skills comfortable working with both technical and non-technical stakeholders and able to document processes clearly.
• Self-starter who can work independently in a remote environment.
• You are detail oriented organized and have project management experience

Bonus Points if:

• You have familiarity with private equity hedge fund or fund-of-funds accounting and reporting.
• You have experience with low-code/no-code platforms (e.g. Power Apps Airtable) or scripting languages (Python) for data processing.
• You possess prior experience supporting a client onboarding function in financial services.

*The BSA III position is remote eligible

Compensation Range:

The posted compensation range on this listing represents UMBs good faith and reasonable estimate based on its budget and what it expects to be the starting pay for this role but the actual compensation may vary by geographic location experience level and other job-related factors. Please see the description of benefits included with this job posting for additional information.

UMB offers competitive and varied benefits to eligible associates such as Paid Time Off; a 401(k) matching program; annual incentive pay; paid holidays; a comprehensive company sponsored benefit plan including medical dental vision and other insurance coverage; health savings flexible spending and dependent care accounts; adoption assistance; an employee assistance program; fitness reimbursement; tuition reimbursement; an associate wellbeing program; an associate emergency fund; and various associate banking benefits. Benefit offerings and eligibility requirements vary.

Are you ready to be part of something more
Youre more than a means to an enda way to help us meet the bottom line. UMB isnt comprised of workers but of people who care about their work one another and their community. Expect more than the status quo. At UMB you can expect more heart. Youll be valued for exactly who you are and encouraged to support causes you care about. Expect more trust. We want you to do the right thing no matter what. And expect more opportunities. UMBers are known for having multiple careers here and having their voices heard.

UMB and its affiliates are committed to inclusion and diversity and provide employment opportunities to all employees and applicants for employment without regard to race color religion sex (including gender pregnancy sexual orientation and gender identity) national origin age disability military service veteran status genetic information or any other status protected by applicable federal state or local law. If you need accommodation for any part of the employment process because of a disability please send an e-mail to to let us know the nature of your request.

If you are a California resident please visit our Privacy Notice for California Job Candidates to understand how we collect and use your personal information when you apply for employment with UMB.