Company Description

Ent Credit Union exists to improve the financial quality of life of the people we serve. This mission drives us every day, but we are more than our mission. We're also individuals using our unique abilities to make our organization, and the communities we serve, better than they were yesterday. We're a not-for-profit that puts people above profits and actively invests in our community. Our rapidly growing team is expanding our reach to serve more people throughout Colorado. To spread our mission far and wide, we need people like you. If you're interested in a paycheck with a purpose, apply with us today. Our people make the difference, and we truly believe you are our greatest asset.

Job Description

The Financial Systems Administrator is an experienced position in the Finance department and actively maintains the overall structure and reliability of the financial system(s) used for financial reporting, forecasting, profitability, budgeting, call report, allowance for credit loss (CECL), investor reporting, and associated general ledger postings. This position is responsible for continual system processing and administration, data management and analysis, investor and regulatory reporting, and interdepartmental collaboration. Regarding data management and financial systems, the successful candidate will have experience working with large data sets and will have hands-on data warehouse knowledge, a high proficiency in SQL, and a strong understanding of credit union finance. The successful candidate will use their attention to detail and problem-solving skills to ensure the data is accurate and validated to core systems. Focusing on data analysis and reporting, the successful candidate will focus on four types of dynamic analytics: (i) descriptive ("what happened?"), (ii) diagnostic ("why did it happen?"), (iii) predictive ("what will happen?"), and (iv) prescriptive ("how can we make it happen?"). The successful candidate has an intellectual curiosity that allows them to draw conclusions from results and see how it may impact other functions in the organization. This candidate must be a self-starter, a forward-thinker, comfortable working in a highly collaborative environment and be able to articulate the res

Essential Functions Financial Systems Admin (currently Axiom) - Act as a primary resource for financial reporting and data matters in the financial reporting software (Axiom). Develops, performs, and maintains monthly system administration functions including integration and comprehensive system architecture. Assists and supports the finance operations team (Financial Analysts). Helps to implement the improvement roadmap to accommodate constantly developing finance tasks and team requests. Develops and manages financial models to support general ledger postings, CECL, budgeting, forecasting, profitability, ad-hoc analysis, and business decision-making. Continuously look for opportunities to leverage systems and tools to enhance the effectiveness and efficiency of internal and external reporting. Supports the primary data miner for the Finance and Treasury departments. Adjusts and writes ad hoc queries against data warehouse or other internal systems using primarily MS SQL. Works closely with business intelligence/data warehouse group to obtain the necessary information to provide clear recommendations and analysis. Data Analysis & Management - Critically evaluate data of different types, discern data patterns, and identifie data outliers using a high level of attention to detail. On a monthly basis, queries SQL data, runs Axiom import, and validates results to core systems. Creates and maintains reports for the CFO's functional areas. Investigate and resolve variances. Updates existing processes or creates new processes, if needed. Investor Reporting - Reviews data files received from Ent's purchased participations to ensure accuracy and all pertinent information is reported to meet our reporting requirements (GAAP). Preps files for import into Axiom and reconciles data to source documents. On a monthly basis, processes SQL queries, imports data, and creates reporting packages for our sold loan participation investors. Reconciles results to core systems and sends reporting packages to our trustees and investors. Prepares monthly GL entries for the accounting department to post. Regulatory Reporting - General understanding in the preparation of the NCUA 5300 Call Report. Works with the senior analyst to understand how pages talk with each other and help to ensure data is reported accurately. Review the updates to instructions from NCUA to gain an understanding of what is being asked. Intra/Interdepartmental Collaboration - Collaborate with department leaders to update income/expense allocations for more accurate profitability reporting. Able to effectively communicate the needs and requests asked by finance of other departments. Comfortable communicating with employees at all levels in the organization. Bank Secrecy Act: Remains cognizant of and adheres to Ent policies and procedures, and regulations pertaining to the Bank Secrecy Act.

Qualifications

Minimum Formal Qualifications for the Administrator Position: Bachelor's Degree in Information Systems, Data Analytics, Finance or similar field of study 3+ years' experience in finance or accounting work (preferably in a Financial Institution) to include: 2+ years' experience using software systems and databases (Axiom experience preferred), and creating complex financial models, to include managing and analyzing large data sets. 1+...

Equal Opportunity Employer - minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity