Global Sales Reporting Analyst

Perform data management activities, including data loading, system table maintenance, and data reconciliations, within the Global Sales Reporting & Analysis (GSRA) system.

This includes the following types of items:

• Use MS Excel tools to convert received file formats into the correct system recognized format for loading into the GSRA system.
• Modifying the GSRA system tables to make updates to such things as reporting geography, country aggregation rules and marketing group/marketing division relationships.
• Perform data reconciliations within the data loading activities which also includes researching any data anomalies.

* Creation and maintenance of monthly and quarterly global sales reports includes the following:

• Create monthly/quarterly reports through both automated and manual processes. This requires intermediate to advanced MS Excel skills as well as knowledge of Cognos and the underlying GSRA system tables.
• Maintain monthly and quarterly reporting schedules ensuring that reports are created on time and contain accurate data.
• Ensure monthly/quarterly reports are properly audited for accuracy and obtain necessary approval prior to distribution.
• Ensure global sales data and reports are maintained according to retention policies.

Note: Reporting activities require a knowledge of system processes and understanding of data management concepts. Users of the reports include: Executive Management, Finance (SEC Reporting), Public Relations, Business Planning, Forecasting, Global Regions/ Market Operations.

* Excellent communication and follow-up skills to interface with global Regional and Market Operations on the collection and consolidation of the competitive data in those markets. Requires flexibility in working hours for meetings with other global entities to support and/or resolve sales reporting issues.

* Develop and maintain documentation of the position's current business processes and identify business process improvements.

* Work with the IT Innovation and Technical Support teams to provide business requirements, priorities, assess alternatives and create test plans for system break/fixes and system enhancements.

• Perform requirements gathering and analysis for sales reporting system enhancements and development.
• Develop, maintain, and conduct User Acceptance Tests for sales reporting system enhancements and development projects.

* Develop and maintain training material for end users, data analysts and data suppliers.

* Conduct formal and informal training with users on the global sales data and adhoc reporting.

• Provide clear communications to the global user community regarding sales data and system availabilty.
• Facilitate meetings to resolve complex issues and promote consensus on process improvements and implementation plans.

* Assist other Sales Operations groups in performing data management and sales reporting tasks (e.g. Global Daily Reporting, U.S. Daily/Monthly Sales Reporting, etc.).

Critical Skills and Knowledge Requirements

Bachelor's Degree with systems and/or quantitative orientation.

Demonstrated analytical and problem solving abilities.

Intermediate to Advanced Microsoft Excel skills.

Ability to use IBM Cognos for extracting data.

Above average skills in Microsoft suite of tools (e.g. Word, PowerPoint, Outlook, SharePoint).

Excellent interpersonal skills.

Detail oriented, with strong follow through skills.

Understanding of Data Management techniques and concepts.

Ability to write user acceptance test cases and perform user acceptance testing for enhancements and development projects.

Ability to multi-task on different projects while maintaining daily operational tasks.

Excellent written and verbal communication skills (business and technical).

Ability to meet deadlines while managing multiple projects.

Ability to work in team-oriented environment.

Ability to identify creative solutions to complex business and system process issues.

Ability to work flexible hours, where required.

Automotive market knowledge.

Preferred

Knowledge or previous experience with IBM Cognos tools (Workspace Advanced).

Previous sales reporting & analysis experience.

Previous MS Excel VBA experience

This is an hybrid position in Warren, MI. All candidates must be local and elgible to work in the US without a sponsorship.

The target hiring compensation range for this role is $78-85K annually. Compensation is based on several factors including, but not limited to education, relevant work experience, relevant certifications, and location.

#LI-NP1

About Aquent Talent:

Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands.

Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits!

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We're about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.