Business Intelligence Data Analyst

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

Job summary

Advanced Innovative Technology Corp. TrakMotive is searching for a Business Intelligence Data Analyst in Redlands, California. The ideal candidate will transform complex data into actionable insights and collaborate with various departments to meet analytical needs. Candidates should have a Bachelor’s degree and 2+ years of relevant experience, alongside proficiency in data visualization tools like SQL and Power BI. The expected pay band ranges from $70,600 to $93,800, providing an opportunity to significantly impact the company's operations.

Qualifications

• 2+ years of experience in retail, business intelligence, data analytics, or related fields.
• Experience with compiling, analyzing, and presenting large complex data sets.
• Familiarity with automotive aftermarket industry is a plus.

Responsibilities

• Design, gather requirements, and maintain dashboards and reports.
• Collect, clean, and transform large datasets.
• Develop documentation of procedures and processes for data flows.

Skills

Data visualization skills

Analytical thinking

Attention to detail

Communication skills

SQL

Tableau

Power BI

Microsoft Excel

Education

Bachelor’s degree

Tools

SQL

Tableau

Power BI

Microsoft Excel

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

• Don’t let Desired Experience dissuade you from applying. If you’re passionate about this, prove to us why you’re the best. We’ll listen
• Bachelor’s degree
• 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

About TrakMotive

Since our founding in 1996, TrakMotive has operated as a global leader in the automotive aftermarket, specializing in the design, manufacture, and distribution of high-quality components. We are more than just a parts supplier; we are a full-service partner to the industry’s largest distributors and retailers, known for our 100% brand-new CV Axles, Drive Shafts, and Window Regulators.

Why Work with Us?

When you join us, you’re getting the best of both worlds: the stability of a company that’s been growing since 1996 and the excitement of a global team that’s still reaching for more. We take pride in the fact that many of our senior leaders are long-term employees who started their careers at TrakMotive. We aren’t just looking for someone to fill a seat—we’re looking for someone who wants to have real impact and grow their career alongside us.

Pay Band

Pay Band: $70,600 - $93,800

Physical Demands & Requirements

Physical Effort: Occasional to frequent lifting and carrying of up to 50 lbs. 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

Pursuant to the California Fair Chance Act, we will consider qualified applicants with arrest and conviction records for employment. 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).