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 & Tools

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