Live chat
United Air Lines, Inc. (UAL)

Strategic Analyst - Technical Operations Inventory Master Data Analysis and Automation

United Air Lines, Inc. (UAL) - Chicago, IL

Technical Operations

Technical Operations is the maintenance, repair and overhaul division of United. The department includes aircraft maintenance technicians, engineers, planners, ground equipment and facilities teams, supply chain teams and more.

Job overview and responsibilities

The Master Data Team is responsible for maintaining the integrity of part CRUD (Create, Read, Update, and Delete) by controlling the interchangeability of aircraft parts at the SKU level and all of the related attributes associated with aircraft parts. Specifically, the team translates OEM and Engineering documents into parameters that United’s TechOps Inventory Control System (ICS) can effectively use.

The team is also responsible for the coordination of tasks to bring the supply chain into compliance with all part changes. All this is done cross-functionally with the Inventory Management, Procurement, Engineering, Distribution, Dangerous Goods, Aircraft Records, Warranty, Maintenance, Quality, Surplus Disposition, Inventory Analysis, Inventory Accounting, and Vendor Management teams.

The Strategic Analyst – Tech Ops Master Data is responsible for the same tasks and duties, but also supports the team through data analysis, task monitoring, performance reporting, and automation of certain transactional activities.

Material Compliance

Work Material Engineering Change Request Authorization (ECRA) dispositions and report progress for the team

Creation, maintenance, and deletion of spare aircraft parts and consumable SKUs in United's ICS, in compliance with Engineering Authorized Documents (IPCs, CMMs, ECRAs)

Partner cross-functionally to determine attributes such as ESDS, material type, resource code, shelf life, hazardous material designation, UN/ID, and unit of issue

Ensure that SKU interchangeability is set up in compliance with Engineering documents, interpreting the intent for proper separation in the warehouses

Monitor all parts setups by other teams for SKU integrity

Partner with Engineering and dangerous goods professionals to ensure SKUs are have the proper hazardous material configuration in the MMS, as well as the setup of chemicals, from the Chemical Database, and maintenance of shelf lives

Task Management and Coordination

Communicate with Distribution to have parts purges and bin checks executed timely, monitoring completion status for the team

Obtain posted Engineering Authorization Recommended Spare Parts Lists (EA RSPLs), collect missing data, and communicate to Inventory Management, driving and reporting completion

Coordinate the decision process and criteria analysis for SKU resource code reclassification and drive the process, monitoring the completion of activities by other departments

Execute and monitor the completion of unit of issue changes, SKU number changes, and SKU combines

Analysis

Query and analyze data for the Master Data Team to create reports and support actions

Conduct research regarding historical setups of SKUs

Provide supplemental analytical support to the Inventory Planning and Inventory Analysis departments as needed

Automation and Process Improvement

Continue current automation techniques and design new macros for batch updates to the MMS

Required

BS/BA degree in business, supply chain, engineering, and/or computer science

Intermediate SQL knowledge

Intermediate computer programming or macro scripting knowledge

Advanced Excel skills (pivot tables a must) and an Office suite power user

Strong leadership and ability to communicate cross functions

Detail oriented

Able to read and understand engineering documents

Internal customer service focused

Comfortable working with large data sets and relational databases

Self-motivated

A minimum 3 years experience in any combination of the following fields: supply chain/logistics, engineering, and/or computer science

Education in lieu of experience will be considered

Up to 50% travel possible

Must be legally authorized to work in the United States for any employer without sponsorship

Successful completion of interview required to meet job qualification

Reliable, punctual attendance is an essential function of the position

Preferred

MS or MBA a plus A&P certification

Six sigma green belt

Experience with SQL server

VBA and/or CASL script programming

Knowledge of Tableau, Spotfire or data visualization tools

SCEPTRE knowledge

Project management

Filemaker Pro experience

Experience in the airline industry

Equal Opportunity Employer – Minorities/Women/Veterans/Disabled/LGBT

Division:

66 Technical Operations/Maintenance

Function:

Tech Ops / Maintenance - Management & Administrative

Equal Opportunity Employer – Minorities/Women/Veterans/Disabled

5 days 19 hours ago

United Air Lines, Inc. (UAL)

apply

Strategic Analyst - Technical Operations Inventory Master Data Analysis and Automation United Air Lines, Inc. (UAL) - Chicago, IL, United States

   

Location: Chicago, IL

Company Profile:
United Airlines, Inc. is an American major airline headquartered in Chicago, Illinois. United is a wholly owned subsidiary of United Continental Holdings following a $3 billion merger in 2010. The airline was previously owned, at one point in its history, by The Boeing Company, one of the world's largest aircraft manufacturers. Since its merger with Continental Airlines, the company boasts more revenue passenger miles than any airline in the world.United operates out of 10 airline hubs in the continental United States, Guam, and Japan. George Bush Intercontinental Airport in Houston is United's largest passenger carrying hub handling 16.6 million passengers annually with an average of 45,413 passengers daily. The company employs over 88,500 people while maintaining its headquarters in Chicago's Willis Tower (formerly known as Sears Tower). Through the airline's parent company, United Continental Holdings, it is publicly traded under NYSE: UAL with a market capitalization of over $10.5 billion as of October, 2013.