This job listing has expired and the position may no longer be open for hire.

F&A Specialist at UPS

Posted in Transportation 30+ days ago.

Location: Alpharetta, Georgia





Job Description:

UPS Supply Chain Solutions (SCS) is seeking a dynamic Finance & Accounting Systems Specialist to assist with key projects and gain first-hand experience in enhancing an enterprise-level Finance department with current Business Intelligence technologies. He/She will be directly responsible for improvements in our established processes, as well as an active collaborator in our ongoing development of new analysis and reporting tools. The SCS Finance & Accounting Systems Specialist will have the opportunity to learn/develop their skills with SQL databases, SSAS tabular models, advanced Excel functionalities and Microsoft Power BI.

Responsibilities and Duties

  • Assists with department’s reporting migration to SSAS tabular and Power BI
    • Designs, deploys, and documents Power BI and Excel PowerPivot reports
    • Automates data imports using SQL Server Data Tools
    • Collaborates on overall design of the SSAS model
  • Updates old reports with current technologies (SQL, PowerPivot, Power BI) to reduce runtime and improve accuracy
  • Provides ad-hoc SQL support to existing monthly profitability model team
  • Learns and documents UPS Freight Forwarding business knowledge to facilitate cross training and solidify knowledge base of the team

Knowledge and Skills

  • Captures/documents specific and accurate information; learns subjects thoroughly and in detail; completes work with thoroughness; supplies appropriate details when requested; maintains organized files
  • Possesses ability to generate simple reports using basic functions in software, and/or writing basic queries; identifies information required to complete reports and identifies existing reports generated by others
  • Demonstrates a general understanding of technology used by the company; communicates basic technological concepts and terminology; applies standard technology in daily work
  • Displays strong written, oral, and visual communication skills
  • Microsoft Office (Excel, PowerPoint, Access, OneNote) 
  • SQL Server, Oracle and/or SQL database experience - Preferred

UPS is an equal opportunity employer. UPS does not discriminate on the basis of race/color/religion/sex/national origin/veteran/disability/age/sexual orientation/gender identity or any other characteristic protected by law