Systems Analyst

Lockton; Kansas City (MO); On-site; USD 80,000 - 110,000; Full time

Job summary

Lockton seeks a Systems Analyst to administer and develop Vena, guiding data integrity, processes, and reporting. You’ll oversee data loads, security, and user access while partnering with Finance, IT, analytics, and engineering to enhance workflows.

You will contribute to broader data initiatives, gain exposure to enterprise data strategy, and grow into analytics-focused work within a collaborative environment.

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.

Responsibilities

• 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.
• 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.
• 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.
• 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.

Education

Bachelor's degree or equivalent in finance, accounting, information systems, data analytics

Tools

Vena

SQL

Job description

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.