Intermediate Data Repository Analyst I

UPS Mahwah , NJ 07430

Posted 2 months ago

UPS is seeking an experienced and dynamic Intermediate Data Repository Analyst to join our team. Does this sound like your ideal opportunity? If so, we want to hear from you!

The Intermediate Data Repository Analyst implements business requirements and monitors reporting functionality and enhancements. He/She acts as a liaison between business users (e.g., Operations, Marketing, etc.), the Diad Information Repository (DIR) or Data Warehouse Repository (DWH) application team, and technical groups (e.g., business analysts, systems programmers, etc.) to define data requirements and meet business needs. This position provides end user support and executes data strategies, writes technical documents, and implements requirements. He/She may supervise specialists, administrative assistants or contractors within the department.

The Intermediate Data Repository Analyst works with various business functions to understand the business needs for analysis and reporting relative to UPS data. He/She works with the source application to understand data structure, definition, use, and meaning, using that information to develop and document repository requirements. This position works with source application representatives to create code and decode tables for data integrity. This position works closely with the IT Analysts, Data Modelers, Metadata Developers and programmers to implement integrated datasets into the repository enabling Business Intelligence, Reporting and Analysis. This position also will evaluate extract requests from other systems, provide recommendations on how to best accomplish those interfaces and work with the repository application team on implementation.

Responsibilities and Duties

  • Presents business requirements to the appropriate I.S. team

  • Analyzes Business Intelligence application performance to provide direction and understanding for future data integration

  • Participates in functional design ensuring the proposed solution meets the goals and objectives of the requirements

  • Contribute to the integrated data vision of the repository and help achieve those goals through requirements and other enhancements

  • Provides virtual element names and table/folder descriptions for ease of use to end users

  • Updates existing documentation to communicate changes in repository structures, presentation, and source system data

  • Creates train-the-trainer documentation to explain data, procedures, structures, and related queries

  • Answers general and advanced questions to assist users with Business Intelligence

  • Contributes to or creates data extracts for select UPS-wide data

  • Assist in data pulls for litigation defense or legal subpoena

Skills and Knowledge

  • Demonstrates some advanced knowledge of database design principles; works with users to define requirements with minimal oversight from others; defines user rights; describes security measures, such as passwords, firewalls, and access rights based on user requirements; describes information organization, such as classes, links, records, and fields

  • Uses the research problem to guide relevant data gathering and benchmarking; develops a working knowledge of literature related to the research problem; minimizes personal biases that may impact the research process or outcomes; gathers data that represent all sides of the business case

  • Describes basic categories of data; with supervision, locates and generates reports of existing data naming and structuring standards with supervision; recognizes the need for consistent data terminology and format

  • Identifies basic measurement requirements and possible indicators for individual, group, department, and business unit results; demonstrates a general ability to use multiple measurement methods for measuring performance; sets meaningful goals and objectives

  • Makes minor adjustments to test plans; recognizes the importance of quality assurance to the business; identifies conditions that impede that quality assurance process

  • Demonstrates a working knowledge of techniques for soliciting and gathering information; identifies appropriate sources of information

  • Uses the appropriate style, level of detail, grammar, and organization of thought in technical writing; drafts standard specialized or technical documents using templates and job aids; considers the end-user's perspective when creating technical documents

  • Recognizes the basic impact of technology on UPS business, services, and processes; identifies technological barriers in achieving desired objectives; maintains appropriate breadth and depth of technological knowledge for current work assignment

  • Identifies internal customers' needs and vendors to meet those needs; determines costs and benefits to UPS for vendors' products, commodities, or services; creates bid proposals for vendor solicitation; analyzes vendor responses and develops recommendations for award

  • Experience using Microsoft Office products or similar software Preferred

  • Experience with SQL Server, Oracle, DB2, or similar database applications Preferred

  • Experience with data warehouse systems Preferred

  • Bachelor's Degree (or internationally comparable degree) Business/Economics, Computer Science, Engineering, Marketing, MIS, Mathematics, or related discipline 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

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Sales Analyst


Posted 2 days ago

VIEW JOBS 11/12/2018 12:00:00 AM 2019-02-10T00:00 Company: FedEx Services Job Title: Senior Sales Analyst Job Requisition Number: RC109845 Category: Sales/Solutions Locations: Mahwah, New Jersey 07430 United States Job Description Provides strategic, analytical, process, implementation and project management support to Sales and aligned Customer. Leverages strong analytic skills, basic process improvement acumen, and proficient FedEx service and operational knowledge to create fact based analyses and recommendations. Analyses and reports may include aspects of performance metrics, trend results, solution enhancements, supply chain initiatives and service level improvements. * Provide customized reporting and scorecards. * Consolidate large data sets. * Applies general Quality Driven Management (QDM) principles to develop root cause analyses, corrective action plans, and continuous improvement SOPs. Coordinates the resolution of escalated customer service requests. * Single point of contact. * Liaison to direct customer resources. * Provides advanced project management skills for continuous improvement initiatives, monthly operational meetings and executive management updates. * Quantify contractual and network value. * Identify and assist in the implementation continuous improvement initiatives such as network optimization, mode optimization, packaging, pool distribution, etc. Core Competencies 1. In accordance with the strategic objectives of the Customer and FedEx, takes proactive initiative to assist sales team members with development, creation, and implementation of strategic solutions with focus on continuous improvement. As part of that, the individual must act as the provider of the right analytical and supply chain approach for various situations. 2. Be a strong user of Microsoft Office products along with basic SQL knowledge to conduct the required analysis as per the requirements of the team/customer/segment needs. Includes advanced knowledge on leveraging fact based analysis into information that drives favorable results. 3. Proven collaboration skills across customer and internal business partners. 4. Possess general knowledge of the industry and the customers. 5. Apply general QDM principles in the work. 6. Possess advanced project management skills. 7. Leverage experience and network to produce optimal solutions and results. 8. Possess strong attention to detail to ensure consistent accuracy of results Relocation assistance may be considered. Domicile: Franklin Lakes, NJ and surrounding metro areas. Pay Band: SK To apply for this position, please upload a current copy of your resume and complete the required screening questionnaire by close of business (5:00 PM CST) on November 19, 2018, in order to be considered. Minimum Qualifications: Bachelor's Degree/equivalent in business, finance, economics, computer science, engineering or related field. Two (2) years of work experience in measurement and analysis, quantitative business problem solving, operations analysis, sales or marketing analysis, and/or knowledge management. Strong ability to work on multiple assignments concurrently. Demonstrates strong skills with business software. Good interpersonal skills. Strong written and verbal communication skills. Want a career where you are empowered to make a difference? Want to work for a company that is environmentally responsible? Want to grow and develop on the job? If so, FedEx is the place for you! Every day FedEx delivers for its customers with transportation and business solutions. FedEx serves more than 220 countries and territories around the globe. We can serve this global network due to our outstanding team of FedEx employees. FedEx has over 400,000 talented employees who are tasked with making every FedEx experience outstanding. FedEx has been recognized on many different lists both for business success and for being a great employer. Here are some of the recognitions FedEx has received from the past couple of years: * FORTUNE "World's Most Admired Companies" – 2016 * Corporate Responsibility Magazine "100 Best Corporate Citizens" – 2016 * InformationWeek "Elite 100" – 2016 * Women's Business Enterprise National Council "America's Top Corporations for Women's Business Enterprises" - 2016 * Reputation Institute "World's Most Reputable Companies" – 2015 * Black Enterprise "40 Best Companies For Diversity" – 2015 When 400,000 employees around the globe are all working together it is amazing what we can achieve! FedEx connects people and ideas. If you would like to make a difference on a global scale while receiving top notch benefits, competitive pay, and plenty of opportunities to develop, click 'Apply' and tell us more about yourself. EEO Statement - FedEx is an equal opportunity/affirmative action employer (minorities/females/disability/veterans) that is committed to diversifying its workforce. Fedex Mahwah NJ

Intermediate Data Repository Analyst I