BI Analyst

Description Who We Are: From Georgia. For Georgia. Since 1914 Yancey Bros. Co. has proudly served as the authorized Caterpillar equipment dealer for Georgia, providing our customers with the highest quality sales, parts and service. From Caterpillar heavy and compact construction equipment to on-highway trucks, we remain committed to learning more about our customers, offering equipment and support to keep up with their changing needs. This all starts with our greatest asset…our employees. What You Will Be Doing: TheBIAnalyst role is designed for professionalswho showa strongfoundationin data & Excelwith several years of relevant experience who canleveragetheirexpertiseto drive construction equipment sales through advanced data and analytics. Drawing upon your background in analyzing market trends, customer behavior, and historical sales data, you will deliver actionable insights that contribute directly to revenue growth. Your experience will be essential in guiding strategic decisions,optimizingsales processes, and strengthening our competitive advantage within the industry. Furthermore, you willutilizeyour knowledge toidentifyand implement automation opportunities for manual tasks in Excel, employing tools like VBA macros or Python scripts to streamlineworkflowsand boost efficiency in response to business needs. This is an onsite position, based out of our Corporate office in Austell, GA. No relocation assistance or visa sponsorship is provided. Major Tasks, Responsibilities, and Key Accountabilities: Design and execute robust processes foridentifying, reviewing, and summarizing complex trends and patterns within large data sets,leveragingseveral years of advanced data analysis and Excelexpertiseto drive actionable recommendations. Utilize a deep understanding of market analytics and internal business data to proactively uncover strategic opportunities for business improvement, employing sophisticated Excel-based reporting, modeling techniques, and automation tools such as VBA macros and Python scripts. Architect andmaintainadvanced databases and dynamic spreadsheets supporting team projects and department operations, collaborating cross-functionally to ensure scalability, accuracy, and compliance with best practices. Lead the integration and organization of data from diverse internal and external sources, using advanced Excel functions, Power Query, and other analytics platforms to ensurehigh standardsof data accuracy and extraction efficiency. Develop and implement robust data collection methodologies and quality assurance protocols, ensuring reliability and consistency for ongoing reporting and analytics needs. Apply advanced statistical analysis and data visualization techniques to create compelling visual summaries such as interactive dashboards, charts, and graphs that support executive-level project reports and presentations. Automate recurring reports and dashboards,optimizingroutine data processes and workflows through scripting and advanced Excel functionalities to increase efficiency and reduce manual effort. Compile and synthesize weekly and monthly reports, including comprehensive sales summaries, lead generation insights, and advanced market intelligence, drawing on years of experience to deliver nuanced and actionable findings. Demonstrate mastery in working with complex internal and external data sources, translating multifaceted data into strategic insights and recommendations to support business growth and forecasting. Prepare impactful reports and executive presentations for Management, creating advanced charts, visual aids, and narratives to clearly communicate key findings and recommendations. Utilize in-depth knowledge of customer segmentation and business domains to deliver targeted data analysis that supports strategic planning, business growth, andaccurateforecasting. Identify, troubleshoot, and resolve complex data integrity issues within company systems, implementing best practices tomaintainhigh standardsof data accuracy and reliability. Lead efforts in gathering,validating, andmaintainingdata from a variety of sources, ensuring dataqualityand supporting strategic team projects and departmentalobjectives. Apply advanced Excel and analytics tools to organize, clean, and analyze large datasets,identifyingnuanced trends and patterns that inform strategic decisions. Leverage extensive experience in data analysis and advanced Excel skills to design and execute robust processes foridentifying, reviewing, and summarizing complex trends and patterns within large data sets, collaborating with team members to drive data-driven recommendations. Utilize in-depth knowledge of market analytics and internal business data to proactively uncover strategic opportunities for business improvement, employing sophisticated Excel-based reporting and modeling techniques developed over several years in the field. Participate in required safety program and work in a safe manner. Education/Experience: The knowledge, skills, and abilities typically acquired through the completion of a bachelor's degree (Business, Finance, or related) from a four-year college or university. 2+ years of experience in business analysis, with a focus on sales analytics. Proven track record of driving sales growth through data-drive insights. Required Qualifications/Skills: Strong understanding of sales processes and the construction equipment industry. Ability to translate complex data into actionable insights for sales teams. Familiarity with CRM systems (e.g.,Dynamics) and sales automation tools. Adept at presenting findings to both technical and non-technical stakeholders. Good project management and the ability to present work to a team. Must be able to comprehend, speak, and write the English language. Must possess good interpersonal and communication skills. Strong motivation and self-starting initiative is required. Ability to present complex information in an understandable and compelling manner. Strong analytical ability. Exposure to data mining techniques and procedures and knowing when their use is appropriate. Most of your time is spent sitting. Climate controlled environment.Work underflorescentlighting. Moderate noise levels.Possible noiseand vibrations carried over from the shop. Physical: Will require appropriate Personal Protection Equipment to be worn if in a shop environment. Travel: Limited overnight travel possible (in state). Who We Are Looking For: The ideal candidate is eager to learn new tools, expand their analytical skills, and build a successful career in Business Intelligence. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor. #J-18808-Ljbffr Yancey Bros Co.