Data Analyst

Who We Are : Founded in 1989, Automated Media, Inc. (AMI) is an innovative, award-winning information technology firm, based in Michigan and serving customers around the globe. AMI creates ingenious technology solutions, and develops and manages successful systems for Ford, Chrysler, GM, and other customers. These include tire programs, as well as other technology and project management programs, consulting, billing, and systems solutions.

Base Pay Range:

Title : Data Analyst, GM

Reports To: Senior Program Manager - MGR

FLSA Status: Exempt

Date Revised: /11/24

As a Data Analyst, your essential job functions will include the following:

Reporting & Analytics

• Conduct program and promotional and post-mortem analysis to ensure expected promotion ROI is met.
• Provide monthly assessment on achieving commodity level objectives, including tires and provide insights and actions on OEM and region trends.
• Contribute to business cases for marketing and promotional program enhancements through analysis of sales, financial, and market trends.
• Support the creation of the annual tire and dealer program marketing plans by providing insight and making recommendations through analysis of historical promotions.
• Acquire and manipulate data from multiple sources to analyze relevant dealer program information and run ad hoc analysis.
• Leverage access to OEM internal systems and request additional data where needed.
• Contribute to monthly OEM reporting and streamline where possible.
• Create/manage website metrics and field reports.
• Utilizes business intelligence software to extract, analyze, and interpret data in order to generate reports for data visualization.
• Work with OEM reporting system to discuss integrating data.
• Lead in developing fiscal year projections. Convert complex analysis into visual presentations that can be easily consumed by staff and executives.
• Provide data-driven insight—draw valid conclusions and make recommendations.
• Responsible for managing and analyzing a higher volume of data.
• Develop and implement additional tools, processes, or solutions to support increased data complexity.
• Continuously improve data handling, reporting, and efficiency as data demands evolve.
• Design and maintain automated reporting pipelines and dashboards using Power BI or other BI platform.

Project Management

• Iteratively, efficiently, and effectively identify and execute projects with the greatest return.
• Lead data analytics and ROI analysis for new project opportunities.
• Collaborate with subject matter experts and ensure efforts are in alignment with the goals of the organization.
• Serve as secondary point of contact for issue resolution. Work with appropriate groups within AMI and OEM to ensure that issues are resolved in timely manner.
• Identify opportunities to improve current OEM programs and work with internal departments to implement program enhancements.
• Guide technical design and structuring of software tools that are complex and require a high level of integration with existing systems and reporting.
• Ensure project sponsors are consistently kept up-to-date on project status.
• Independently interface with client technical teams and business owners as needed.
• Quantify impact of analyses and changes.

• Produce regular reporting and analysis—ensure reporting is timely and accurate.
• Participate in and develop appropriate documentation to track program quality, volume, and satisfaction metrics.
• Support the design and maintenance of data science tools and reporting related to data science product performance.
• Document, update, and analyze data science production processes, as assigned.  Ensure processes are updated routinely, are appropriately representative and drive action within the organization.

• Provide data-driven insight for internal partners—draw valid conclusions and make recommendations.
• Provide trustworthy guidance, fact-checking and advice for colleagues and project sponsors.
• Ensure knowledge and experience are accessible to team-members such that it is clear that colleagues see you as the "go-to" expert in your assigned areas of responsibility.

Other Duties as Assigned

Position Requirements

• BS/BA, preferably in Business, Marketing, Management, Mathematics or related field required.
• Analytical experience in sales, marketing, promotions, or operations strongly preferred.
• 5+ years' in a professional setting, automotive experience preferred.
• Highly analytical and proficient in statistics and mathematics. Demonstrated detail orientation and organizational skills required to ensure prompt follow-up with both external (OEM) and internal customers.
• Proven written/oral communication skills as well as presentation skills.
• Advanced Microsoft Office products skills required.
• Excel and Power BI is a preferred skill set.
• OEM national or regional experience preferred.

Competencies Required

• Strategic Thinking
• Project Management
• Teamwork
• Diagnostic Skills
• Critical Thinking
• Communication
• Results Orientation
• Initiative

Physical Job Requirements

• Continuous viewing from and inputting data to a computer screen.
• Sitting for long periods of time.
• Some travel required: