UPS Reporting Specialist in Atlanta, Georgia

The Reporting Specialist is responsible for retrieving, analyzing, and converting shipment and revenue performance data into useful information for the customer (i.e., Sales, Pricing, Revenue Management, and Marketing groups). He/She creates and presents requested reports that assess business results and influence senior management decision making. This positions manages and maintains multiple reporting databases and reporting dashboards.

The Reporting Specialist manages project lifecycles, including project scope, resources, schedule, initiation, start-up/design, building, and deployment to see projects from beginning-to-end. He/She documents changes, updates, and formulas during the process to ensure a complete record of the request is created. This position requires knowledge of statistical modeling and analysis, forecasting, planning, critical thinking skills to design problem resolution and implementation of solutions. The Reporting Specialist documents changes, updates, and formulas during the process to ensure a complete record of the request is created. He/She develops a process flow diagram to provide a visual representation of the steps used to produce the deliverables.

Responsibilities and Duties

  • Reviews data requests to correctly identify and understand the information needed

  • Develops data retrieval plan (e.g., how the query is completed, fastest way to retrieve data, etc.) to pull the data efficiently from mainframe data sources

  • Verifies data output to spot inconsistencies and errors

  • Provides data implications of analyses and serves as a subject matter expert for the customer (e.g., Sales, Marketing groups, etc.) to ensure understanding of findings and gain commitment

  • Develops project plans (i.e., detailed plan, milestones, and work breakdown structures) and assigns tasks to resources to ensure that the project will be completed on time and according to specifications

  • Designs and implements communication plans to ensure those affected by projects are informed and updated

  • Prepares and presents analyses results with key insights clearly and precisely to support senior management decision making

  • Administers competitive contract tools to evaluate competitor intelligence, product/service offerings and strategies

  • Supports customer contract administration tools to display contract performance and identify underperforming customers and evaluates expiring customers ‘contracts to determine automatic renewal eligibility

Knowledge and Skills

  • Applies Information Analysis & Solution Generation Knowledge: Familiar with primary information sources relevant to assigned area; utilizes computer-based analytical and information management tools in order to perform routine analysis; documents approach and findings; reviews results with others as appropriate

  • Applies Problem Definition & Structuring Knowledge: Identifies key factors behind basic problems and establish a path to solve them; proposes approaches to solve more complicated problems; investigates and diagnoses anomalies in routine business results

  • Project Planning: Demonstrates an understanding of basic project planning processes, including planning action items and resources

  • Bachelor’s Degree (or internationally comparable degree) in Industrial Engineering, Economics, Mathematics, Marketing or Information Management - Preferred

  • Master’s Degree (or internationally comparable degree) in Business Administration or Information Management - Preferred

  • Experience demonstrating advanced Microsoft Access skills (coding in SQL, data optimization, macros, creating single and multiple-criteria parameter queries and forms, etc.) - Preferred

  • Experience demonstrating advanced Microsoft Excel functionalities (IF statements, pivot tables, V Lookup, etc.) - Preferred

  • Experience using Microsoft SQL Server (coding in SQL) - Preferred

  • Experience using Tableau software - Preferred

  • Experience with Data Warehouse Systems - 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

Company: UNITED PARCEL SERVICE

Category: Mechanics and Engineering, Marketing and Communication, Full-Time

Requisition Number: 172386

Location: Atlanta,Georgia