Senior Systems Analyst

Oracle Transportation Management, Otm

Confirmed live in the last 24 hours

Locations

Normal, IL, USA

Experience Level

Entry

Junior

Mid

Senior

Expert

Requirements

Bachelor's degree in supply chain, engineering, Information Technology, or related field
3+ years of experience with using, setting up and maintaining a Transportation Management System, preferably Oracle TM for finished vehicle shipment
Thorough understanding of IT processes and procedures relative to system launch, drafting system level requirements and UAT, and roll out of enhancements
Expert user in MS Excel - ability to create pivot table and sophisticated charts, i.e., multiple axis and data series, use of short cuts, and VLOOKUP functionality
Advanced SQL knowledge is a must
Basic knowledge of Tableau, MS Access and Alteryx is a must. Advanced skills are a plus
Ability to travel up to 5% of the time

Responsibilities

Detail oriented and Act as Subject Matter Expert to handle the master data setup and maintenance of Outbound vehicle logistics transportation management system (Oracle)
Lead the efforts to define the business needs and assist integration supporting systems such as Yard Management System (YMS), SAP and others
Act as a primary point of contact from the business between the product management team and end users, coordinate system issue resolution, and identify and drive enhancements
Own and maintain the master data (including but not limited to location, region, network leg, rates, accessorial, service provider, service time, distance, equipment group, calendars etc.)
Establish a master data check logic and implement routine checks to keep OTM updated
Monitor the orders flowing to the system and order planning to ensure the cars are routed right. Act as primary contact from the business with the order management system and product management teams to handle the issues if any
Configure and update the system to suit the business needs and fix the anomalies discovered by the team during daily operations
Identify, document and drive improvements in methods of using systems within Outbound, including processes and desk procedures
Support TMS launch activities including User Acceptance Testing (UAT)
Own the development and maintenance of operational dashboards and KPIs
Mine the data from Oracle server using SQL to assist the team with data analysis and schedule daily reports using BI publisher to assist the team with daily metrics that need to be monitored
Support AdHoc data mining requests and critical system related issues over a weekend OR holiday if needed
Act as back up and support for other roles within the Outbound Logistics team

Rivian is on a mission to keep the world adventurous forever. This goes for the emissions-free Electric Adventure Vehicles we build, and the curious, courageous souls we seek to attract.

As a company, we constantly challenge what’s possible, never simply accepting what has always been done. We reframe old problems, seek new solutions and operate comfortably in areas that are unknown. Our backgrounds are diverse, but our team shares a love of the outdoors and a desire to protect it for future generations.

Role Summary

Senior systems analyst will own the master data configuration and maintenance of Oracle Transportation Management system. It is a key function supporting the Outbound Logistics at Rivian and acts as a SME driving process enhancements, establishing and guiding the user team about good practices, leading the efforts to discuss and evaluate the business needs, brainstorm with the product management team, and finally implement the update along with sharing the desk procedures.

The ideal candidate possesses in depth knowledge of OTM and can handle updates related to network and master data and issues with minimum guidance. The ideal candidate can mine the data from Oracle server, find the root cause of any gaps and communicate a plan to stop such issues from reoccurring. Also, can communicate complex issues and ideas to a variety of audiences, brainstorm as a team and confidently present a proposal to the leadership across the organization. We are looking for an organized, detail-oriented candidate with an analytical mindset and hands on experience with finished vehicle OTM system. Having a positive attitude will benefit this position greatly as the role requires flexing into other roles as needed. The ideal candidate must be willing to roll-up sleeves and dive into the weeds.

Responsibilities

Detail oriented and Act as Subject Matter Expert to handle the master data setup and maintenance of Outbound vehicle logistics transportation management system (Oracle)
Lead the efforts to define the business needs and assist integration supporting systems such as Yard Management System (YMS), SAP and others
Act as a primary point of contact from the business between the product management team and end users, coordinate system issue resolution, and identify and drive enhancements.
Own and maintain the master data (including but not limited to location, region, network leg, rates, accessorial, service provider, service time, distance, equipment group, calendars etc.)
Establish a master data check logic and implement routine checks to keep OTM updated
Monitor the orders flowing to the system and order planning to ensure the cars are routed right. Act as primary contact from the business with the order management system and product management teams to handle the issues if any
Configure and update the system to suit the business needs and fix the anomalies discovered by the team during daily operations
Identify, document and drive improvements in methods of using systems within Outbound, including processes and desk procedures
Support TMS launch activities including User Acceptance Testing (UAT)
Own the development and maintenance of operational dashboards and KPIs
Mine the data from Oracle server using SQL to assist the team with data analysis and schedule daily reports using BI publisher to assist the team with daily metrics that need to be monitored
Support AdHoc data mining requests and critical system related issues over a weekend OR holiday if needed
Act as back up and support for other roles within the Outbound Logistics team

Qualifications

Bachelor’s degree in supply chain, engineering, Information Technology, or related field
3+ years of experience with using, setting up and maintaining a Transportation Management System, preferably Oracle TM for finished vehicle shipment
Thorough understanding of IT processes and procedures relative to system launch, drafting system level requirements and UAT, and roll out of enhancements
Expert user in MS Excel – ability to create pivot table and sophisticated charts, i.e., multiple axis and data series, use of short cuts, and VLOOKUP functionality
Advanced SQL knowledge is a must
Basic knowledge of Tableau, MS Access and Alteryx is a must. Advanced skills are a plus.
Ability to travel up to 5% of the time

Equal Opportunity

Rivian is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices laws. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender, gender expression, gender identity, genetic information or characteristics, physical or mental disability, marital/domestic partner status, age, military/veteran status, medical condition, or any other characteristic protected by law.

Rivian is committed to ensuring that our hiring process is accessible for persons with disabilities. If you have a disability or limitation, such as those covered by the Americans with Disabilities Act, that requires accommodations to assist you in the search and application process, please email us at [email protected].

Candidate Data Privacy

Rivian may collect, use and disclose your personal information or personal data (within the meaning of the applicable data protection laws) when you apply for employment and/or participate in our recruitment processes (“Candidate Personal Data”). This data includes contact, demographic, communications, educational, professional, employment, social media/website, network/device, recruiting system usage/interaction, security and preference information. Rivian may use your Candidate Personal Data for the purposes of (i) tracking interactions with our recruiting system; (ii) carrying out, analyzing and improving our application and recruitment process, including assessing you and your application and conducting employment, background and reference checks; (iii) establishing an employment relationship or entering into an employment contract with you; (iv) complying with our legal, regulatory and corporate governance obligations; (v) recordkeeping; (vi) ensuring network and information security and preventing fraud; and (vii) as otherwise required or permitted by applicable law.

Rivian may share your Candidate Personal Data with (i) internal personnel who have a need to know such information in order to perform their duties, including individuals on our People Team, Finance, Legal, and the team(s) with the position(s) for which you are applying; (ii) Rivian affiliates; and (iii) Rivian’s service providers, including providers of background checks, staffing services, and cloud services.

Rivian may transfer or store internationally your Candidate Personal Data, including to or in the United States, Canada, the United Kingdom, and the European Union and in the cloud, and this data may be subject to the laws and accessible to the courts, law enforcement and national security authorities of such jurisdictions.

Please note that we are currently not accepting applications from third party application services.

10,001+ employees

Website

Electric vehicles manufacturer

Automotive

Company Overview

Rivian is on a mission to keep the world adventurous forever. The company believes there is a more responsible way to explore the world and is determined to make the transition to sustainable transportation an exciting one. Rivian designed their emissions-free Electric Adventure Vehicles to challenge what's possible.

Benefits

Ownership for All: We offer every employee the opportunity to own Rivian stock through equity programs, supporting their financial wellness.
Mental and Emotional Wellness: We provide employees and their families access to mental wellness platforms and our Employees Assistance Program
Fertility and Family Planning: We support diverse family-building journeys, providing employees with benefits such as paid parental leave and financial support for adoption, fertility treatments or surrogacy.
Competitive Compensation: We offer competitive compensation packages driven by mutual investment in our long-term growth and success.
Career Development: We enable all employees to own their development. Continuous learning opportunities and tuition reimbursement help drive performance, boost engagement and develop future leaders.
Transgender Benefits: In alignment with WPATH guidelines, our 2022 plans provide coverage toward medical, pharmacy and cosmetic needs.

Company Core Values

A diverse workforce
Embracing active allyship
Purpose-driven partnerships
Supporting our team