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. You 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

Founded on a $100 loan in 1907, 2 teenage boys opened up a messenger service in a 6 by 17 foot office located just below the sidewalk on Second Avenue and Main Street in Seattle, WA. Messengers ran errands, carried notes, hand baggage, and delivered trays of food for customers. They also delivered packages, traveling by streetcars and bicycles for longer trips, and later using motorcycles.