Business Intelligence Analyst

Job Overview

Affinity 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.

Affinity 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

• Develop Power BI dashboards and executive scorecards
• Build and maintain SQL-based reporting solutions
• Create KPIs and performance metrics that drive decision-making
• Analyze dealership data to identify trends, opportunities, and risks
• Support financial forecasting and operational planning
• Help create a "single source of truth" for business reporting

• Manage and optimize SQL databases and reporting environments
• Develop and maintain Crystal Reports
• Support Excede, Dealer Retriever, Arcadium, and other business systems
• Improve data quality, integrity, and reporting reliability
• Assist with software integrations and API connectivity

• Implement workflow automation using Microsoft technologies
• Support Microsoft Copilot, Copilot Studio, and Power Automate initiatives
• Develop AI-assisted tools and business process improvements
• Identify opportunities to eliminate manual work and increase efficiency
• Help establish best practices for responsible AI adoption

• Participate in software implementations and upgrades
• Act as a liaison between business users and technology vendors
• Evaluate new reporting, analytics, and automation opportunities
• Help shape Affinity's future data and AI roadmap

• Degree preferred in Business Analytics, Information Systems, Computer Science, Data Analytics, Accounting Information Systems, Finance, or related field.
• Degree 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.

• Lifting and carrying:
  Frequently lift and carry items…