Business Intelligence Analyst Jobs

About The Position

Requirements

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

Nice To Haves

• Dealership, automotive, commercial truck, or equipment industry experience preferred but not required.

Responsibilities

• 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

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Dependent health insurance coverage
• Disability insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid holidays
• Paid sick time
• Vision insurance