Business Intelligence Analyst

Socket.dev

Fresno (CA)

On-site

USD 70,000 - 110,000

Full time

11 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

401(k)

401(k) matching

Dental insurance

Health insurance

Paid holidays

Paid sick time

Job summary

Affinity Truck Center is seeking a Business Intelligence Analyst to transform data into decisions, automate manual processes, and help shape analytics and AI across the dealership. You will 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 to deliver data-driven

Qualifications

5+ years of BI, data analytics, reporting, or related role.
Strong SQL experience including queries, joins, views, stored procedures, data validation, and troubleshooting.
Experience building Power BI dashboards and executive scorecards.
Experience with Crystal Reports or similar tools.

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.

Skills

SQL queries

Power BI

Data analysis

Communication

Project management

Education

Degree in Business Analytics/IS/CS/Data Analytics/Finance

Tools

Crystal Reports

ERP systems

DMS

CRM

Job description

Description

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, 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 & 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 Affinity's 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 Center’s 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 @ www.Affinitytruck.com or email the HR department @ HR@affinitytruck.com.

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: