Role: Statistical Modeler/Data Analyst
Location: Warren, MI (This position is hybrid 80/20% remote + on-site and requires some in office visits. Candidate must be local to Michigan or relocate day 1 of the assignment)
Duration: Long term
Rate: Market
Top 3 Skills
Very proficient in Excel (pivots, formulas, macros, etc)
Reporting software experience (i.e. Cognos, PowerBI, etc)
Data management techniques and concepts
The energy at our company is contagious. Were driven by our immense passion, as we constantly seek out challenges and identify new opportunities. We work hard to connect with our customers and earn their loyalty for life. Bring your talent to our company our opportunities for growth span the globe. We will give you the training and opportunities to unleash your ambition.
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 the company's 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 the company's global Regional and Market Operations on the collection and consolidation of the company and 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 positions current business processes and identify business process improvements.
Work with 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 availability.
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 - Required
Bachelors 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 a 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 Skills
Knowledge or previous experience with IBM Cognos tools (Workspace Advanced).
Previous sales reporting &
Location: Warren, MI
Posted: Sept. 18, 2024, 9:48 a.m.
Apply Now Company Website