Financial Systems Administrator or Senior

Summary

Join Ent Credit Union as a Financial Systems Administrator and maintain the reliability of financial systems used for reporting, forecasting, and budgeting. You will be responsible for system administration, data management, investor reporting, and interdepartmental collaboration. This role requires experience with large datasets, SQL, and credit union finance. You will perform data analysis, focusing on descriptive, diagnostic, predictive, and prescriptive analytics. The ideal candidate is a self-starter, forward-thinking, and comfortable working collaboratively. This position offers a competitive salary and benefits package.

Requirements

• Bachelor's Degree in Finance, Business Administration, Data Analytics, Accounting, Data Analytics / Business Analytics, or Information systems
• 3+ years' experience in finance or accounting work (preferably in a Financial Institution) required to include: 1+ years' experience using Axiom (required)
• Bachelor's Degree in Finance, Business Administration, Data Analytics, Accounting, Data Analytics / Business Analytics, or Information systems
• 5+ years' experience in finance or accounting work (preferably in a Financial Institution) required to include: 1+ years' experience using Axiom (required)
• 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
• Demonstrated experience with relational databases such as Microsoft SQL Server
• 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
• None

Responsibilities

• 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
• 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
• 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
• 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
• 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
• Remains cognizant of and adheres to Ent policies and procedures, and regulations pertaining to the Bank Secrecy Act

Preferred Qualifications

• 2+ years' experience using software systems, databases, and creating complex financial models, to include managing and analyzing large data sets (preferred)
• 1+ years' experience with regulatory filing of the NCUA 5300 Call Report. (preferred)
• 1+ years' experience with POWER BI, Tableau, or other data visualization tools. (preferred)
• 3+ years' experience using software systems, databases, and creating complex financial models, to include managing and analyzing large data sets (preferred)
• 2+ years' experience with regulatory filing of the NCUA 5300 Call Report. (preferred)
• 2+ years' experience with POWER BI, Tableau, or other data visualization tools. (preferred)

Benefits

• Affordable insurance, 24/7 doctor access, and a nationwide provider network
• 3% automatic contribution after three months, plus up to 6% matching
• During your first year, enjoy 16 days of paid time off (PTO) plus 9 paid holidays. And it grows from there
• Paid time off to give back to the community
• Up to $10,000 annually for higher education and assistance for certifications
• Significant savings on home, car, and personal loans
• This position is eligible for our corporate bonus program based on company performance