Business Intelligence Data Analyst

Advanced Innovative Technology Corp

Redlands, California

JOB DETAILS
SKILLS
Analysis Skills, Automotive Industry, Background Investigation, Business Intelligence, Business Processes, Communication Skills, Data Analysis, Data Quality, Data Sets, Data Visualization Tools, Database Administration, Detail Oriented, Distribution Channel, Documentation, Due Diligence, Federal Laws and Regulations, Genetics, International Operations, Leadership, Legal, Lift/Move 50 Pounds, Mandarin Chinese Language, Microsoft Excel, Military, Mining Laws/Regulations, Needs Assessment, Organizational Skills, Physical Demands, Power BI, Presentation/Verbal Skills, Procedure Development, Process Flow, Reporting Dashboards, Requirements Management, Retail, SQL (Structured Query Language), Sales, Spanish Language, Statistics, Supply Chain, Tableau, Team Player, Writing Skills
LOCATION
Redlands, California
POSTED
Today
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: $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 & Accommodations 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).

About the Company

A

Advanced Innovative Technology Corp