Share this Job
Apply now »

Sales Forecasting System Analyst

Job Number:  46106
Group:  Magna Powertrain
Division:  GO Troy
Job Type:  Permanent/Regular




Job Number: 46106 
Group: Magna Powertrain  
Division: GO Troy 
Job Type: Permanent/Regular 
Location: TROY 


Group Introduction


Advancing mobility. Making automotive technology that is smarter, cleaner, and safer, while still fun to drive. And making it for everyone. That’s what we’re passionate about at Magna Powertrain. We do it by creating world-class powertrain solutions for conventional, hybrid, and pure electric vehicles. We’re making electrification more than a buzzword, we’re bringing it to the road. Innovation is what drives us and we drive innovation. Dream big and create the future of mobility at Magna Powertrain.


Mission of the Position


The Sales Forecast Database and Business Process is a key system for Magna Powertrain (MPT) to support them in monitoring and tracking sales and business development opportunities. The Sales Forecasting System Analyst will be responsible for managing the database and business processes used for planning, tracking, and preparing the MPT Sales Forecast.

Key Responsibilities


  • Act as ‘owner‘ of the database and business processes related to sales planning and forecasting, including the administration of the database and management of the data within it.
  • Lead and manage database user access, training, and sales reporting for MPT in direct support of Business Plan and Sales Forecasting activities.
  • Serve as a technical resource for day-to-day application support including routine maintenance, and investigation of interface issues, including coordination of scheduling, testing and implementation.
  • Support the process of identifying, diagnosing and solving existing process and system issues.
  • Analyze and assess business processes to identify improvements/enhancements in the Database.
  • Coordinate the Sales Forecasting activities with MPT Business Development, Sales, Finance, and Product/Portfolio Management teams, including MPT Product Group management.
  • Manage Powertrain market volume data, in coordination with market intelligence sources within MPT.
  • Coordinate MPT participation in Magna vehicle volume forecast process, and management of the market volume data, all to support the MPT Sales Forecasting process.
  • Administer third-party and Magna vehicle / powertrain forecast data, support creation of merged market forecast for use in MPT Sales Forecast activities.  Coordinate input to corrections and revisions in the data with MPT market intelligence, MPT sales, and Magna market forecasting teams.
  • Support the preparation and publishing of Sales Forecast, Sales Award summaries, and similar business reports.
  • Follow Magna’s Code of Conduct and Ethics and related compliance policies.
  • Additional duties and responsibilities as assigned.

Magna Standards


  • Practice and maintain integrity while following Magna’s Charter and Constitution.
  • Follow Magna’s Code of Conduct and Ethics and related compliance policies.
  • Supports and adheres to policies, procedures, and operational guidelines related to established quality 
  • management system (IATF 16949).
  • Drive the development of new technologies to improve quality, efficiency and reduce cost.
  • Comply with safety policies and procedures to ensure duties of self are performed in a safe manner.
  • Health & Safety responsibilities:
    •      Understand applicable Environmental, Health & Safety policies and procedures in the workplace.
    •      Report unsafe conditions immediately.
    •      Report injuries, accidents, illnesses, near misses, property damage immediately.
    •      Follow safety rules.
    •      Comply with requirements for the use or operation of machines or equipment.
    •      Comply with Personal Protective Equipment (PPE) requirements.
  • Create a positive work environment by demonstrating and sharing functional/technical knowledge.
  • Develop and maintain a responsive and cooperative working relationship with internal and external 
  • customers.
  • Treat everyone with dignity, trust and respect.
  • Complete additional duties and responsibilities as assigned.

The above is intended to describe the general content of and the requirements for the performance of this position. It is not to be construed as an exhaustive statement of duties, responsibilities, or requirements.

Customers and Business Interfaces


  • Sales 
  • Portfolio Management 
  • Product Management 
  • Finance 
  • OPEX 
  • MPT Product Group Management

Requirements and Qualifications


  • Bachelor’s degree in the field of Business Administration or equivalent.
  • 3 - 5 years of progressive experience in the sales analysis field with understanding of major OEM’s and product (vehicle) life cycles.
  • Understanding of business processes and systems and how a sales forecast is built.
  • Proficient in Excel, in particular pivot tables to analyze large quantities of data.
  • From time to time, work off-hours to support clients across different time zones and during periodically scheduled update/maintenance procedures.
  • Excellent analytical skills and the ability to work with customer oriented teams in a global environment.
  • Excellent communication, interpersonal, facilitation and organizational skills.
  • Creative problem solving abilities with attention to detail.
  • Flexible and independent while at the same time a team player in a demanding environment with changing priorities.
  • Knowledge of PowerBI would be a plus and SQL server.
  • Ability to quickly learn and adapt to changing needs.
  • Ability to work with people at varying levels of the organization.    

Work Environment


Office environment; 10% travel required. 


While working in this environment, the employee will be exposed to machinery, moving equipment and material, moderate noise, airborne particles, fumes and various levels of temperature created by manufacturing processes.


Awareness. Unity. Empowerment.


At Magna, we believe that a diverse workforce is critical to our success. That’s why we are proud to be an equal opportunity employer. We hire on the basis of experience and qualifications, and in consideration of job requirements, regardless of, in particular, color, ancestry, religion, gender, origin, sexual orientation, age, citizenship, marital status, disability or gender identity. Magna takes the privacy of your personal information seriously. We discourage you from sending applications via email to comply with GDPR requirements and your local Data Privacy Law.

Nearest Major Market: Troy
Nearest Secondary Market: Detroit

Apply now »