Data Analyst Intern

Title: Data Analyst Intern 

Location: Hybrid/Farmington Hills, MI, US

Summary

This position is responsible for designing, developing and maintaining business data and statistical models that allow for insights into customer data. Candidate would be expected to help develop analytic reports and dashboards for existing business and new opportunities.

ESSENTIAL DUTIES AND RESPONSIBILITIES 

• Develop insightful KPI reporting dashboards to drive decision-making and performance tracking
• Develop reports and dashboards via data mining analytics and reporting tools
• Prepare analytics reports in presentation form
• Assist in developing sound data ETL practices and processes
• Conduct research and analyze special studies when needed
• Create and update documentation of process flows and business rules
• Maintain current reports up to date and process large amounts of data as needed

MINIMUM QUALIFICATIONS

• Bachelor’s Degree in computer science, statistics, mathematics or relevant discipline
• 1-3 years automotive operations experience, or similar business (quick-paced environment)
• Experience with data visualization tools (Tableau, PowerBI, Qlik Sense, etc.)
• SQL skills for querying relational databases
• Experience with complex data analysis
• Performing data manipulation and statistical analysis
• Strong analytical skills with ability to understand and communicate the meaning of the data being presented
• Excellent Mathematical/Statistical and Logic skills
• Excellent Reasoning skills

PREFERRED QUALIFICATIONS

• Multi-dimensional reporting, data correlation, data analytics and data mining
• Previous external client facing experience
• Experience with ETL tools (SSIS, Alteryx, KNIME, etc.)

OTHER COMPETENCIES & CHARACTERISTICS

• Knowledge Retention - In order to provide the highest quality of work, analysts must be able to learn and memorize a large amount of information.
• Detail Oriented – Analysts must be able to focus on the details in order to identify and isolate issues.
• Organizational Skills – Analysts must be organized and able to keep track of multiple projects at once.
• Flexibility - Analysts must be able to handle multiple tasks at once and follow changes in priority level.
• Speed - Must be able to work quickly and efficiently without sacrificing the quality of their work.
• Solutions Oriented - Must be able to find workable solutions for any problems they might face.

LANGUAGE SKILLS 

• Full Professional Proficiency in English is required

MATHEMATICAL SKILLS 

• Able to complete advanced statistical analysis is required

REASONING ABILITY 

• Job requires analyzing information and using logic to address work-related issues and problems

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to:

• Call, video, email, message and communicate with dealers and co-workers

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

WORK ENVIRONMENT

• Remote / Office environment
• The noise level in the work environment is usually moderate.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.