Data Analyst - Paid Summer Internship

Description:

The Data Analyst (Entry Level) is responsible for analyzing data, managing data processes, developing dashboards and visualizations, and project managing related efforts. Duties include modeling data, analyzing reports, as well as strategizing ideas to improve business operations. Strong communication skills are required, as data must be translated, communicated, and visualized clearly for staff and customers. The Business Analyst reports to the Finance Director and works alongside other key stakeholders to implement high-quality data driven decisions.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Develop BI reports for internal and customer use that highlight KPIs, advanced analytics and identify potential significant patterns related to products and services Develop financial reporting and analyze financials Support business partners to evaluate and implement new projects and processes that support the company strategy while continuing to improve the functionality, performance, and reliability of BI deliverables Clearly communicate to the status of BI deliverables to project owners and train end users when necessary Work with key stakeholders to develop and model financial and other data for internal and external use Help define metrics and quantitative information to proactively engage in process improvements. Project manage and provide project updates identifying risks, opportunities and timelines Define business test cases and manage the user acceptance testing process Provide timely decision support to key stakeholders, managers, and executive leaders by creating on-going and ad-hoc reports. Analyze and define projects that will enhance and deliver new features and functionality without compromising quality Design and implement new or enhanced operational processes to meet key business objectives Perform, evaluate, troubleshoot, and communicate to ensure quality at every stage of development Handles other duties and special projects as assigned

Requirements:

The individual in this position should be responsible, proactive, personable, a problem solver, reliable, a team player, ethical, intelligent, a leader, and able to adapt to the forces around him/her—customers, suppliers, department employees, co-workers, and manufacturer's employees.

Education/Training/Experience:

College Degree in Information Technology, Computer Science, Finance, Mathematics. Minimum of 1 years of experience in data analysis, reporting, and Power BI development. Experience with dashboard and reporting software (Power BI) and ERP systems (Microsoft Dynamics) Proficiency in data modeling and extensive experience with DAX. Demonstrated ability to translate complex datasets into clear and compelling visualizations. 1+ years' experience and intermediate/advanced knowledge of SQL (preferred) ERP and systems implementation experience (preferred) Experience with data visualization, user testing, project management, and technical writing Advanced Microsoft Office Suite skills required with strength in

Excel Skills Knowledge and Abilities:

Excellent interpersonal and customer/employee relations skills Great communication skills (written and verbal) Strong knowledge of the computer systems in use in the dealership environment Willingness to learn new technology Highly motivated Knowledgeable about the industry, our equipment, and the market