Data Analyst - Paid Summer Internship at Bailey in Nashville,TN

Summary: Bailey is seeking a Data Analyst for a paid summer internship. The role involves analyzing data, developing dashboards, and managing data processes to support business operations and decision-making. 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 Required Qualifications: - 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 - Advanced Microsoft Office Suite skills required with strength in Excel - 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 Preferred Qualifications: - 1+ years' experience and intermediate/advanced knowledge of SQL - ERP and systems implementation experience - Experience with data visualization, user testing, project management, and technical writing Required Skills: Data Analysis, Power BI, DAX, SQL, Data Modeling, Financial Reporting, Dashboard Development, ERP Systems, Microsoft Dynamics, User Acceptance Testing, Microsoft Excel, Project Management