Finance & Accounting Systems Specialist

Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself or teams, there are roles ready to cultivate your skills and take you to the next level.

Job Description:

This position serves as liaison between global users and analysts for systems enhancements and production issues. He/She maintains the reporting systems used by the function. This position develops and executes test scenarios for existing and new functionalities. He/She builds reports necessary for end users. This position supports provides application support to users.

Responsibilities:

• Tests and evaluates code changes to ensure proper functionality and validity.

• Communicates with users to clarify issues, determine business impacts, and deliver solutions.

• Creates new business and profit plan reports in the financial reporting and planning database to support stakeholders.

• Executes test scripts to ensure test cases are operating according to expectations.

• Verifies data to ensure accuracy.

• Develops and maintains queries in the function's reporting systems to generate business reports.

• Analyzes financial reporting and data variances to identify problem root causes and implements corrective solutions.

• Maintains master project data set

• Incorporates most recent month’s manual journal entry data into master data set

• Trends new month data against project baseline manual journal entry counts

• Keeps track of manual journal entries for which some action has been taken to eliminate, automate or advance and shows such entries as a reduction against baseline counts

• Builds monthly trend reporting for review by Project Manager and eventual reporting to Senior F&A Leadership

• Prepares numerous PowerPoint decks to be reviewed with various stakeholder audiences

• Ad-hoc data pulls and analysis as requested by Close Optimization project team members

Requirements:

• Possess a Bachelor's degree in Accounting or Finance

• Demonstrate ability to perform basic (financial) analysis

• Proficient in Microsoft Office, preferably with advanced MS Excel/Access skills and SQL skills

  • Creating and managing pivot tables driven off Excel Data Model

  • Creating and managing charts/graphs

  • Designing and managing large datasets in Excel

  • Creating and managing queries driven by Power Query in Excel

• Possess M (Power Query) & DAX (Power Pivot) language knowledge is preferred

• Possess ability to communicate with stakeholders across different levels

• Possess prior working experience in an accounting or finance setting

• Display willingness to work flexible

Employee Type:

UPS is committed to providing a workplace free of discrimination, harassment, and retaliation.