Reports & Analysis Analyst

We are looking for a detail-oriented and analytical Reports & Analysis Analyst with Python programming knowledge and an interest in data extraction, automation, and automotive information.

In this role, you will support data collection, processing, cleaning, standardization, and validation activities related to automotive products and vehicle applications. You will work with web-based data sources, analyze HTML structures, and help maintain accurate and reliable datasets.

You will receive guidance and mentorship while progressively developing your technical and analytical skills.

Key Responsibilities:

• Support Python-based web data gathering and automated data extraction.

• Analyze HTML codes and website structures to identify relevant information.

• Collect, clean, standardize, validate, and cross-reference automotive product and vehicle application data.

• Identify missing, duplicate, inconsistent, or unexpected data.

• Maintain accurate and reliable datasets.

• Process assigned tasks accurately and meet established deadlines and quality standards.

• Use Microsoft Excel to analyze, organize, and validate information.

• Prepare basic progress reports and communicate relevant findings to the Manager.

• Document processes and recommend improvements within established procedures.

• Escalate significant data discrepancies, access restrictions, or scope changes when necessary.

Qualifications & Requirements:

Education

Bachelor's degree in any of the following fields or a related discipline:

• Automotive or Mechanical Engineering

• Computer Science

• Software Engineering

• Data Analytics

• Information Systems

• Mathematics or Statistics

Technical Skills

• Python programming knowledge, including variables, data types, loops, functions, lists, dictionaries, and error handling.

• Familiarity with web scraping and data extraction tools such as Requests, BeautifulSoup, Selenium, Playwright, etc.

• Understanding of HTML/CSS and web data structures.

• Microsoft Excel skills, including formulas, lookup functions, filters, pivot tables, data cleaning, and validation.

• Basic CSV file handling and data manipulation.

• English reading comprehension for technical documentation and international data sources.

Desirable Skills (Not Required)

• SQL knowledge.

• Familiarity with APIs and Git.

• Power BI knowledge and basic data visualization skills.

• Experience with Pandas or other Python data analytics libraries.

Additional Knowledge & Competencies:

• Strong analytical and problem-solving skills.

• High attention to detail and accuracy.

• Ability to organize tasks and meet deadlines.

• Interest in automated information extraction and data management.

• Willingness to learn and develop technical skills.

• Ability to work independently while following established procedures.

Automotive Industry Knowledge

An interest in learning about the automotive aftermarket industry is desirable. The role will involve developing working knowledge of:

• Automotive replacement parts.

• Original Equipment (OE) and aftermarket part references.

• Vehicle applications and compatibility.

• ACES/PIES data standards and concepts.

• Automotive product information management.

What We Are Looking For

We are looking for someone eager to learn, with a strong analytical mindset, Python knowledge, and an interest in working with data and technology.

If you enjoy solving problems, organizing information, and developing automation skills, this could be a great opportunity to grow your career in data analytics and the automotive industry.