Sr Finance Systems Administrator

Empowered to live. Inspired to work. 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. How we support you 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! Casual/seasonal & intern team members are not eligible for benefits except for state-mandated programs. 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. A typical day System Administration 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. Budgeting & Forecasting Support 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 calculations. Profitability Support 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 basis. Data Management 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. Reporting Support 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. The skills and experience we prefer you have 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. Certified Public Accountant (CPA) or Certified Management Accountant (CMA) preferred. 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. Knowledge and experience in Syntellis Axiom software is a plus. How we will take care of you Our job titles may span more than one career level (associate, senior, principal, etc.). The actual title and base pay offered is dependent upon many factors, such as: training, transferable skills, work experience, business needs and market demands. The base pay range is subject to change and may be modified in the future. This role is eligible for variable compensation and other benefits. Base Pay: $84,400 – $127,700 USD Compeer Financial is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Must be authorized to work for any employer in the United States. Compeer is unable to sponsor or take over sponsorship of an employment visa at this time. #J-18808-Ljbffr Compeer Financial