Systems Analyst

Lockton Companies; Kansas City (MO); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Job summary

Lockton Companies seeks a Systems Analyst in Kansas City to support Vena administration, data operations, and automation. You will coordinate data loads, user access, and form/workflow maintenance while partnering with Finance, IT, analytics, and engineering teams.

The role emphasizes data quality, process automation, and continuous improvement within FP&A and enterprise data initiatives at Lockton.

Qualifications

• Bachelor's degree in finance, accounting, information systems, data analytics, or a related field, or equivalent experience.
• Experience working with financial data, business systems, reporting, or data processes.
• Strong Excel skills and comfort working with data.
• Ability to learn new systems and processes quickly and troubleshoot problems independently.

Responsibilities

• Vena Administration & Support: manage user administration, onboarding, access, and troubleshooting; maintain Vena forms and workflows; ensure data confidentiality.
• Data & System Operations: load and reconcile financial, payroll, and other data; support monthly, budgeting, and year-end processes; update cubes as needed.
• ETL & Automation: build and maintain Vena ETL jobs; improve recurring data-loading processes; collaborate with analytics and engineering teams on data flows.
• Continuous Improvement & Additional Support: document processes and data flows; identify data quality and efficiency improvements; support new Vena functionality.

Skills

Excel skills

Attention to detail

Communication skills

Problem solving

Learning agility

Education

Bachelor's degree or equivalent

Tools

Vena

SQL

ETL

Job description

Kansas City, Missouri, United States of America

At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.

We are seeking a Systems Analyst to support the administration and ongoing development of Vena, a financial planning and performance management platform. This role will serve as a primary point of contact for Vena, helping ensure that data, processes, and reporting remain accurate and reliable.

The role will manage recurring data loads, user administration, system support, and planning-cycle activities while identifying opportunities to improve and automate processes. You will work closely with Finance, IT, analytics, and engineering teams. Beyond core Vena responsibilities, this role offers the opportunity to contribute to broader data and analytics initiatives, giving you exposure to our enterprise data strategy and potential career growth into data and analytics work.

Key Responsibilities

Vena Administration & Support

• Manage Vena user administration, including onboarding, access, and user inactivation.
• Coordinate with IT on single sign-on and other system access needs.
• Serve as a primary point of contact for Vena questions, issues, and troubleshooting.
• Build, maintain, and troubleshoot Vena forms and workflows.
• Maintain appropriate discretion when working with sensitive financial and employee data.

Data & System Operations

• Manage recurring data and metadata loads across Vena cubes.
• Load and reconcile financial, payroll, production, and other operational data.
• Support monthly, budgeting, and year-end processes within Vena and related systems.
• Maintain and update cubes as business requirements and the chart of accounts change.
• Perform periodic data cleanup and other activities that support data quality and system performance.

ETL & Automation

• Build and maintain Vena ETL jobs, including data sources, tables, mappings, and templates.
• Improve and automate recurring data-loading and administrative processes.
• Work with analytics and engineering teams to troubleshoot data flows and implement changes.
• Use SQL, ETL, automation, or other data tools to support data and process automation where appropriate.

Continuous Improvement & Additional Support

• Document recurring processes, data flows, and system procedures.
• Identify opportunities to improve data quality, efficiency, and automation.
• Support enhancements and new functionality within Vena.
• Contribute to broader data and analytics initiatives as capacity and priorities allow.

Qualifications

• Bachelor's degree in finance, accounting, information systems, data analytics, or a related field, or equivalent experience.
• Experience working with financial data, business systems, reporting, or data processes.
• Strong Excel skills and comfort working with data.
• Strong attention to detail and commitment to data accuracy.
• Ability to learn new systems and processes quickly and troubleshoot problems independently.
• Strong communication skills and ability to work effectively with both business and technical teams.
• Experience with Vena or another FP&A, financial planning, or enterprise performance management system is a plus.
• Experience with SQL, ETL, automation, or other data tools is a plus.

#LI-JM

Equal Opportunity Statement

Lockton Companies is proud to provide everyone anequal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity.

At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learnsfrom, celebrates and thrives because of ourbreadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long-term success.

About Lockton

Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 13,100+ Associates doing business in over 155 countries are empowered to do what’s right every day.

At Lockton, we believe in the power of all people. You belong at Lockton.

How We Will Support You

At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it.

We are ready to meet you where you are today, and as your needs change over time. In addition to industry-leading health insurance, we offer additional options to support your overall health and wellbeing.