Financial Systems Analyst or Senior

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.

The Financial Systems Analyst is an experienced position in the Finance department and will be heavily involved in data management and analysis, investor reporting, regulatory reporting, financial system processing/administration, and interdepartmental collaboration. Regarding data management and financial systems, the successful candidate will have experience working with large data sets and will be familiar with database structure and architecture. 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 results (verbal and written) in a method suitable for those at all levels in the organization.

Essential Functions

• Financial Systems - Act as a reliable resource for financial reporting and data matters in the financial reporting software (Axiom). Performs monthly system administration including integration and review of hierarchy and table/account mappings. Assists and supports the finance 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, 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.
• Data Analysis & Management - Critically evaluates data of different types, discerns data patterns, and identifies data outliers using a high level of attention to detail. On a monthly basis, queries SQL data, runs Axiom imports, and validates results to core systems. Investigates and resolves 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 helps to ensure data is reported accurately. Reviews 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.

Minimum Formal Qualifications for the Regular Position:

• Bachelor's Degree in Finance, Data Analytics, Accounting, IT or similar area of study.
• 3+ years' experience in finance or accounting work (preferably in a Financial Institution) to include:
• 2+ Experience using software systems and databases (Axiom experience preferred), and creating complex financial models, to include managing and analyzing large data sets.
• 1+ Experience with regulatory filing of the NCUA 5300 Call Report (Preferred)

Minimum Formal Qualifications for the Sr. Position:

• Bachelor's Degree in Finance, Data Analytics, Accounting, IT or similar area of study.
• 5+ years' experience in finance or accounting work (preferably in a Financial Institution) to include:
• 3+ Experience using software systems and databases (Axiom experience preferred), and creating complex financial models, to include managing and analyzing large data sets.
• 2+ Experience with regulatory filing of the NCUA 5300 Call Report (Preferred)

Each year of relevant work experience may be exchanged for a year in a relevant degree program or vice versa. For example, a requirement of a bachelor's degree in accounting and 2+ years of account experience could be substituted for a high school diploma and 6 years of relevant accounting work experience or a master's degree in accounting and 0 years of work experience.

Technical or Specialized Knowledge/Skills:

• Strong knowledge of Microsoft Excel (formula creation and modification).
• General understanding of a financial institution's financial statements, budgeting and forecasting concepts, and report creation
• Understanding of the concept of profitability at the organization, product, channel, and member level, including FTP (Funds Transfer Pricing) calculation for loans and deposits.
• Aptitude to learn new and emerging concepts very quickly.
• Experience learning/navigating/administering a variety of software systems and databases.
• Understanding of how change may impact internal financial systems and reporting.
• Uses analytical skills to address data integrity and reconciliations between reporting systems.
• Familiarity with large data sets. Strong understanding of how to analyze and summarize results in a timely manner.
• Self-motivated, independent problem solver with excellent financial intuition and drive to explore the interaction of data across systems
• Propensity to work efficiently and effectively with limited instruction
• Collaborate effectively by sharing ideas and requirements with both technical and non-technical audiences through meetings, working group sessions, whiteboard sessions using data visualization skills
• Ability to clearly articulate the message (verbal and written) in a method suitable for those at all levels in the organization.
• SQL knowledge/exposure.

Certifications Required:

• None

Environmental, Physical and Psychological Requirements:

• Standing - Occasionally
• Walking - Occasionally
• Sitting - Frequently
• Lifting - Rarely (40 Lbs)
• Carrying - Rarely
• Pushing - Rarely
• Pulling - Rarely
• Balancing - Rarely
• Stooping - Rarely
• Kneeling - Rarely
• Crouching - Rarely
• Crawling - Rarely
• Reaching - Occasionally
• Handling - Occasionally
• Grasping - Occasionally
• Feeling - Occasionally
• Talking - Frequently
• Hearing - Frequently
• Repetitive Motions - Frequently
• Eye/Hand/Foot Coordination - Occasionally
• Noises louder than normal speaking volume - Occasionally
• Temperature Changes - Rarely
• Atmospheric Conditions - Rarely

The pay range for the Regular position is: $30.26 to $39.72 per Hour (S15)

The pay range for the Senior position is: $35.89 to $47.10 per Hour (S16)

Final compensation for this position will be determined by various factors such as relevant work experience, specific skills and competencies, education, certifications, and internal pay equity.

We anticipate this position to close on 4/26/2024. Please submit your application at your earliest convenience to be considered.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.

Benefits Summary Sheet - 2024

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)