Sr Finance Systems Administrator

Compeer Financial • Lakeville, MN

15h • Hybrid

About The Position

Compeer Financial is a member-owned cooperative located in Illinois, Minnesota and Wisconsin. We bring together team members with a variety of backgrounds and experiences to help provide financial services to support agriculture and rural communities. Join us in a culture that not only promotes meaningful work and professional development, but provides a flexible, hybrid work environment and excellent benefits, which empower you to thrive both personally and professionally.

Where you will work: This position offers a hybrid work option up to 50% remote and is based out of the Lakeville, MN or Mankato, MN office locations.

The contributions you will make: Administers and optimizes the organization's financial planning and profitability applications. Responsible for the design, development, support, smooth operation, maintenance and enhancement of the organization's budget model and profitability analysis tools.

Requirements

• Bachelor’s degree in accounting, finance or related field or an equivalent combination of education and experience sufficient to perform the essential functions of the job.
• Minimum 7 years of related work experience in data management and/or data administration, including experience in system administration, financial data architecture, budgeting processes, financial analysis and planning, and the ability to manage complex systems that track and analyze financial performance and profitability across an organization.
• 5 years of related work experience in financial planning, financial analysis or financial reporting, or equivalent.
• Solid knowledge and understanding of Compeer’s data, data definitions, data sources and data flow.
• Strong working knowledge of financial planning, budgeting, forecasting, and profitability.
• In-depth experience leading functional and technical design with an emphasis on data architecture and mapping.
• Well organized, with the ability to manage multiple projects simultaneously.
• Ability to collaborate with cross-functional teams.
• Aptitude to dig into a system and troubleshoot issues; enjoys being a problem solver.
• Intermediate knowledge of SQL Server Management Studio, SQL Server Reporting Services.
• Strong interpersonal, collaboration, communication, problem solving, analytical, project management, organizational and time management skills.
• Ability to work independently and collaboratively with other teams to achieve goals and represent the business.
• High degree of confidentiality.
• Exceptional Microsoft Excel skills, including knowledge of complex formulas.
• Valid driver’s license.

Nice To Haves

• Certified Public Accountant (CPA) or Certified Management Accountant (CMA) preferred.
• Knowledge and experience in Syntellis Axiom software is a plus.

Responsibilities

• Leads the product lifecycle of our financial planning and profitability applications, including understanding functional requirements, application design, the development of artifacts, integration testing, performance testing and
• Oversees the design and configuration, maintenance, and optimization of the budgeting and profitability system. Ensures the systems are performing efficiently, working with the vendor and our internal technology department to ensure regular updates and patches are applied.
• Coordinates integrations with other systems, ensuring seamless data flow.
• Collaborates with finance business partners, finance leadership and other key stakeholders to identify and implement system improvements to enhance efficiency and performance.
• Manages user access and permissions to ensure appropriate security access and protect sensitive information within the system.
• Automates finance-related workflows to optimize productivity and compliance.
• Provides technical support to finance business partners, addressing questions and resolving issues.
• Documents and maintains system procedures, system configurations and change logs.
• Trains users on system functionality and best practices; ensures third party vendor management procedures are followed and appropriate documentation from vendor is obtained and adhered to.
• Partners with Enterprise Risk Management team to conduct model validations on an ongoing basis.
• Utilizes knowledge of accounting and finance to support, design and implement budget methodology.
• Creates and maintains the budget model including the master budget input templates, cash flow forecaster, payroll budgeting module, utility files and key driver files.
• Maintains budget and forecast input procedures based on updates made to the process each cycle.
• Maintains the master data tables for accounts, dimensions and departments.
• Creates, populates and maintains data and dimension tables and creates and configures budget driver tables and account calculation.
• Utilizes knowledge of accounting and finance to support, design and implement profitability allocation methodology.
• Designs and optimizes complex allocation models, ensuring accuracy, transparency and runtime efficiency.
• Collaborates with finance business partners to define requirements and implement best practices.
• Automates finance-related workflows to optimize productivity and compliance.
• Provides technical support to finance business partners, addressing questions and resolving issues.
• Documents and maintains system procedures, system configurations and change logs.
• Trains users on system functionality and best practices; ensures third party vendor management procedures are followed and appropriate documentation from vendor is obtained and adhered to.
• Partners with Enterprise Risk Management team to conduct model validations on an ongoing.
• Performs ETL process, data mapping and transformation from source data to financial system.
• Ensures data accuracy, integrity and security within the finance system.
• Create and maintain system metadata and associated data architecture.
• Balances daily data loads to our general ledger system to maintain data accuracy and ensure financial models are accurate.
• Identifies and resolves data discrepancies.
• Creates reports within the budget and profitability system to aide in the model review and analysis by finance business partners.
• Collaborates with finance business partners to create value-added budget and profitability reporting.
• Trains finance business partners on the data structure and reporting design and creation.
• Acts as an internal resource to maximize value of budget and profitability system data.

Benefits

• Hybrid model – up to 50% work from home
• Flexible schedules including ample flexibility in the summer months
• Up to 9% towards 401k (3% fixed Compeer contribution plus up to 6% match)
• Benefits: medical, dental, vision, HSA/FSA, life & AD&D insurance, short-term and long-term disability, wellness program & EAP
• Vacation, sick leave, holidays/floating holidays, parental leave, and volunteer paid time off
• Learning and development programs
• Mentorship programs
• Cross-functional committee opportunities (i.e. Inclusion Council, emerging professional groups, etc.)
• Professional membership/certification reimbursement and more!

What This Job Offers

• Job Type: Full-time
• Career Level: Senior