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.

In this role youll 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.

Youll work across the entire dealership partnering with Accounting Sales Service Parts Lease & Rental Mobile Fleet Services and Operations teams:

Business Intelligence & Analytics

• 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

Systems & Data Management

• 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

Automation & AI

• 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

Strategic Technology Projects

• 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 Affinitys future data and AI roadmap

Requirements

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

Work Schedule and Travel:

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 Centers travel policy.

Physical Requirements:

The physical requirements for this position include the following:

• Lifting and carrying: Frequently lift and carry items weighing up to 20 pounds
• Bending 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 more
• Walking: 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.

Mental Requirements:

The mental requirements for this position include the following:

• Ability to learn new tasks effectively
• Service Dept. Personnel ability to learn new skills effectively such as negotiating and de-escalation skills
• Ability to take direction from others in a leadership and/or similar role
• Must have the capacity to follow and remember processes and procedures
• Must maintain focus on assigned tasks
• Ability to complete tasks independently without supervision
• Ability to communicate effectively with visitors customers and colleagues
• Ability to multi-task
• Ability to prioritize
• Ability to work alone
• Ability to work in groups
• Ability to assist customers in a friendly manner
• Ability to communicate with others in a professional and respectful manner
• Ability to problem solve
• Ability to analyze and resolve issues
• Ability to exercise discretion & confidentiality
• Ability to engage in ethical conduct and decision making
• Ability to adhere to all company guidelines policies and procedures
• Ability to take criticism in a constructive manner
• Ability to maintain focus over long periods while driving
• Capacity for quick decision-making in response to changing traffic conditions or emergencies

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

Privacy Data Notice: Affinity Truck Center collects information that is shared with third parties to build profiles and personalize your experience throughout your employment. To view the categories of personal information we collect and the purposes for which the information is used to exercise your rights under the California Consumer Privacy Act (CCPA) or to access Affinity Truck Center Privacy Policy disclosures at any time visit the company website @ or email the HR department @

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) matching
• Dental insurance
• Dependent health insurance coverage
• Disability insurance
• Flexible spending account
• Health insurance
• Life insurance
• Paid holidays
• Paid sick time
• Vision insurance