Business Intelligence Data Analyst

Advanced Innovative Technology Corp; Redlands (CA); On-site; USD 70,600 - 93,800; Full time

Job summary

Advanced Innovative Technology Corp seeks a Business Intelligence Data Analyst in Redlands, California. The ideal candidate will transform vast data landscapes into actionable insights, designing visual narratives that guide leadership decisions.

The role involves creating and maintaining dashboards, collaborating with various departments, and ensuring data integrity. A background in data analytics and proficiency in tools like SQL and Power BI are essential. The pay ranges from $70,600 to $93,800.

Qualifications

• 2+ years of experience in retail, business intelligence, data analytics, or statistical analysis.
• Strong attention to detail and excellent organization skills.
• Excellent written and oral communication skills.

Responsibilities

• Design and maintain interactive dashboards and reports.
• Collect, clean, and transform large datasets.
• Collaborate with business units for data needs.

Skills

Data visualization

SQL

Tableau

Power BI

Microsoft Excel

Data analytics

Job description

The Role

TrakMotive is seeking a Business Intelligence Data Analyst to transform our vast data landscape into actionable insights. In this role you will act as a vital bridge between complex data systems and our strategic business units. You aren't just building reports; you are designing the visual narratives that allow our leadership to see the "why" behind the numbers.

From architecting interactive dashboards to performing deep‑dive data validation, your work ensures that every department—from Supply Chain to Sales—operates with a single version of the truth. This is an ideal role for a data professional who enjoys the detective work of cleaning and transforming datasets and thrives in a collaborative environment where their analytical solutions directly influence global operational efficiency.

What You’ll Do

• Design, gather requirements, create and maintain interactive dashboards and reports for various organization departments
• Collect, clean, and transform large datasets from various sources (internal systems, third‑party tools, customer portals, etc.)
• Collaborate with business units to understand data needs and translate them into clear analytical solutions
• Develop documentation of procedures and process flows for key reports, data flows and business processes performed by the department
• Support the maintenance of internal company databases and files
• Conduct due diligence analysis and validation of various internal and external data‑related exercises

Qualifications

Must Haves

• 2+ years of experience in retail, business intelligence, data analytics, statistical analysis or other analytics related fields
• Experience with data visualization and analytics tools including SQL, Tableau, Power BI
• Experience with compiling, analyzing, summarizing, and presenting large complex data sets
• Advanced skills in Microsoft Excel
• Strong attention to detail and excellent organization skills
• Excellent written and oral communication skills

Nice to Haves

• Preferred: familiarity with automotive aftermarket industry, vehicle parts and parts data documentation knowledge
• Fluency in Mandarin and/or Spanish

Pay Band

$70,600 – $93,800

Physical Demands & Requirements

Occasional to frequent lifting and carrying of up to 50 lbs. The position involves a combination of stationary work and frequent movement throughout the facility and across multiple levels. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Legal

Must be 18+ years of age and legally authorized to work in the United States.

Pre‑employment

Ability to pass a post‑offer background check and drug screen.

Equal Opportunity Employer

AIT Corporation DBA TrakMotive is an equal opportunity employer and is committed to an inclusive and diverse workplace. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), gender identity or expression, sexual orientation, national origin, ancestry, citizenship, age, physical or mental disability, legally protected medical condition, family care status, military or veteran status, marital status, domestic partner status, genetic information, or any other basis protected by local, state, or federal laws.

Fair Chance & Accommodation

We will consider qualified applicants with arrest and conviction records for employment pursuant to the California Fair Chance Act. We also provide reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act (ADA) and the California Fair Employment and Housing Act (FEHA).