Finance Systems Analyst II
United Community Bank
full-time
Posted on:
Location Type: Office
Location: Blairsville • 🇺🇸 United States
Visit company websiteSalary
💰 $49,972 - $62,677 per year
Job Level
JuniorMid-Level
Tech Stack
CloudETLSQL
About the role
- Designs, builds and maintains processes which extract and prepare data from disparate data sources using ETL tools, for loading to Finance System databases where necessary to support EPM tools.
- Provides timely updates to Finance System databases where applicable.
- Implements methods for reconciling Finance System databases to source system data and ensures data integrity.
- Establish, develop and maintain reporting from Accounting administered system tools.
- Identifies opportunities and implements procedures to automate and streamline existing data processes.
- Assists with the Finance System budget application as defined by the SLA with Management Reporting.
- Assist with the administration of Accounting’s system tools.
- Assists with monthly closing process where applicable.
- Supports M&A activity by assisting with GL mapping, daily data feed preparation and executing GL data integration to begin at legal close.
- Assist in maintaining documentation for financial management tools and processes developed internally.
- Support Accounting staff with training and knowledge transfer where applicable of EPM and related tools.
- Provide back up to the Finance Systems Administrator.
- Respond timely to all audit inquiries as assigned.
- Other duties as assigned.
- Participate in all required compliance training, including Bank Secrecy Act/anti-money laundering training.
Requirements
- Bachelor’s degree in info systems or related field preferred; Finance/Accounting experience a plus.
- Minimum 2 years related experience: or equivalent combination of education and experience.
- Proficient with the Microsoft Office Suite; emphasis on Advanced Excel skills.
- Experience with SQL Server Management Studio preferred.
- Strong background in data systems design as it relates to an understanding of the applied management cycle of EPM tools used both in-house and that of cloud environments.
- Experience with data mining tools such as Alteryx, Monarch or other similar tools.
- Sound writing and documentation skills.
- Strong verbal communication skills.
- Ability to work extended hours as needed.
- Participate in all required compliance training, including Bank Secrecy Act/anti-money laundering training, as well as internal and external training programs, online training, meetings, and seminars/conferences, etc.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETL toolsdata extractiondata preparationdata integrityreportingautomationGL mappingdata integrationAdvanced ExcelSQL Server Management Studio
Soft skills
writing skillsdocumentation skillsverbal communicationtrainingknowledge transfertimelinessproblem-solvingcollaborationadaptabilityattention to detail
Certifications
Bachelor’s degree in info systemsBank Secrecy Act traininganti-money laundering training