Business Intelligence Analyst

Business Intelligence AnalystAffinity Truck Center is looking for a Business Intelligence Analyst who can transform data into decisions, automate manual processes, and help shape how analytics and AI are used across our organization.In this role, you'll work directly with executive leadership and departments across the dealership to build dashboards, connect systems, improve reporting, and develop solutions that support profitability and operational performance.You'll work across the entire dealership, partnering with Accounting, Sales, Service, Parts, Lease & Rental, Mobile Fleet Services, and Operations teams:Business Intelligence & AnalyticsDevelop Power BI dashboards and executive scorecardsBuild and maintain SQL-based reporting solutionsCreate KPIs and performance metrics that drive decision-makingAnalyze dealership data to identify trends, opportunities, and risksSupport financial forecasting and operational planningHelp create a "single source of truth" for business reportingSystems & Data ManagementManage and optimize SQL databases and reporting environmentsDevelop and maintain Crystal ReportsSupport Excede, Dealer Retriever, Arcadium, and other business systemsImprove data quality, integrity, and reporting reliabilityAssist with software integrations and API connectivityAutomation & AIImplement workflow automation using Microsoft technologiesSupport Microsoft Copilot, Copilot Studio, and Power Automate initiativesDevelop AI-assisted tools and business process improvementsIdentify opportunities to eliminate manual work and increase efficiencyHelp establish best practices for responsible AI adoptionStrategic Technology ProjectsParticipate in software implementations and upgradesAct as a liaison between business users and technology vendorsEvaluate new reporting, analytics, and automation opportunitiesHelp shape Affinity's future data and AI roadmapRequirementsDegree preferred in Business Analytics, Information Systems, Computer Science, Data Analytics, Accounting Information Systems, Finance, or related field.5+ years of experience in business intelligence, data analytics, reporting, systems analysis, or related role.Strong SQL experience, including queries, joins, views, stored procedures, data validation, and troubleshooting.Experience developing reports and dashboards using Power BI.Experience with Crystal Reports or similar reporting tools preferred.Experience working with ERP, DMS, CRM, or other business systems.Practical experience with AI tools, automation platforms, or workflow automation required.Experience with Microsoft Copilot, Copilot Studio, Power Automate, Microsoft Fabric, Azure AI, or similar tools preferred.Ability to translate business requirements into reports, dashboards, automations, and system solutions.Experience leveraging AI technologies to automate workflows, improve reporting, or enhance business processes.Strong understanding of data integrity, security, confidentiality, and access controls.Strong analytical, problem-solving, communication, and project management skills.Ability to work with both technical and non-technical users.Dealership, automotive, commercial truck, or equipment industry experience preferred but not required.Due to the nature of our business, and the duties of the position in particular, the actual schedule you will be required to work will vary based upon many factors, including, but not limited to, the business needs of our Company, the schedules of our customers, the season of the year, etc. You may also need to travel out of State for meetings, training, conventions, etc. You will be reimbursed for travel expenses in accordance with Affinity Truck Center's travel policy.The physical requirements for this position include the following:Lifting and carrying: Frequently lift and carry items weighing up to 20 poundsBending, twisting, stooping, reaching: Must be capable of frequent twisting and bending down to pick up items from lower shelves, and reaching up for items stored at higher levels.Vision: Must have at least 20/40 acuity in each eye with or without correction.Hearing: Ability to perceive a "forced whisper" at a distance of 5 feet or less, with or without hearing aids.Mobility: Ability to enter and exit the vehicle safely and efficiently.Service Dept. Personnel Mobility: Capability to climb into and out of trucks, which may involve using steps or ladders.Dexterity in operating controls such as steering wheels, pedals, and gear shifts.Standing: Must be able to remain in a stationary position for a certain percentage of the workday, such as 50% or moreWalking: Regularly moving about on foot within the work area, which may involve navigating through tight spaces or uneven surfaces.Hand Dexterity: Frequent use of hands and arms for grasping, fine manipulation, pushing and pulling, reaching, typing, etc.Sitting: Frequent sitting while using a computer, sitting at a desk, attending meetings, trainings, seminars, etc.The mental requirements for this position include the following:Ability to learn new tasks effectivelyService Dept. Personnel ability to learn new skills effectively such as negotiating and de-escalation skillsAbility to take direction from others in a leadership and/or similar roleMust have the capacity to follow and remember processes and proceduresMust maintain focus on assigned tasksAbility to complete tasks independently without supervisionAbility to communicate effectively with visitors, customers, and colleaguesAbility to multi-taskAbility to prioritizeAbility to work aloneAbility to work in groupsAbility to assist customers in a friendly mannerAbility to communicate with others in a professional and respectful mannerAbility to problem solveAbility to analyze and resolve issuesAbility to exercise discretion & confidentialityAbility to engage in ethical conduct and decision makingAbility to adhere to all company guidelines, policies, and proceduresAbility to take criticism in a constructive mannerAbility to maintain focus over long periods while drivingCapacity for quick decision-making in response to changing traffic conditions or emergenciesIn addition to base pay, actual total compensation may vary based on hours worked, performance, skillset, eligibility for overtime, performance-based bonuses or commissions, and employer-paid benefits.We are an equal opportunity employer and prohibit discrimination/harassment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.Benefits:401(k)401(k) matchingDental insuranceDependent health insurance coverageDisability insuranceFlexible spending accountHealth insuranceLife insurancePaid holidaysPaid sick timeVision insurance