Vena Systems Analyst: Data Automation & FP&A Support

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

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.