DATA ANALYST - Howell
Ideal Setech LLC
- Experience
- 2+ yrs
- Location
- Howell, Michigan, United States
- Job type
- Full-time
Required skills
- Databricks
- SQL
- Power BI
- Excel
- Tableau
- SAP
- Maximo
- Oracle
- Infor
About the role
job Summary
- Data Analyst supports our Manufacturing Delivery Services team with a focus on new vehicle launch programs; supporting indirect MRO inventory, critical spare parts and various indirect materials projects. This role will focus on Data Extraction and Analysis; Pulling data from the Databricks data warehouse using complex SQL queries and analyze large datasets to identify trends, patterns, and insights
Essential Job Functions
- Collaborate directly with the Data Lead and customer leadership to design, build, and maintain interactive dashboards and reports using Databricks' native visualization tools, Power BI, or other business intelligence (BI) platforms.
- Develop and maintain dashboards and reports to track KPIs such as inventory turns, lead times, part usage rates, and critical spares availability.
- Partner with maintenance, engineering, and procurement teams to align BOMs with actual asset structures and maintenance strategies.
- Analyze and manage Indirect MRO inventory data to identify usage trends, optimize stock levels, and reduce obsolescence or overstock.
- Support digital transformation or system upgrades (e.g., SAP, Maximo, Infor) by preparing and validating MRO and BOM data.
- Assist with master data governance by ensuring part numbers, descriptions, units of measure, and classifications are consistent and accurate.
- Reconcile discrepancies between OEM documentation and actual plant usage or installed equipment.
- Identify opportunities for standardization and rationalization of parts across multiple sites or equipment platforms.
- Conduct root cause analysis on stockouts, equipment downtime related to part availability, or BOM inaccuracies.
- Provide insights to support sourcing strategies, vendor consolidation, and cost-reduction projects.
- Comfortable presenting data projects to our customers and internal leadership.
- Exhibit a strong commitment to continuous learning and adaptability, essential in the ever-evolving field of data analytics.
- Attend meetings as required.
- Maintain a safe work environment and a team culture of safety.
- Other tasks/duties as required.
Work Experience Requirements
- To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Skills
- Solid understanding of MRO materials, maintenance operations, and/or BOM structures.
- Proficient in Excel (advanced functions, pivot tables, lookups) and data visualization tools (e.g., Power BI, Tableau).
- Experience working with ERP/CMMS systems (e.g., SAP, Maximo, Oracle, Infor).
- Strong SQL skills for querying and manipulating data from relational databases.
- Attention to detail with strong problem-solving and data validation skills.
- Ability to communicate technical findings clearly to non-technical stakeholders.
Physical Requirements
- Ability to sit at a desk for extended durations
- Ability to view a computer screen for prolonged periods
Minimum Requirements
- Bachelor's or associate’s degree in data Analytics, Supply Chain, Engineering, Business, or a related field.
- 2+ years of experience in a data analysis role, preferably within manufacturing, maintenance, or supply chain environments.
- Ability to demonstrate strong interpersonal skills, oral or written.
- Ability to handle multiple priorities with meeting deadlines.
- Previous work with SAP
Benefit Information
- The position offers an attractive benefit package that includes medical insurance (Blue Cross Blue Shield PPO, HMO and Health Savings plan options available), dental coverage, vision coverage, life insurance, short-term disability, and long-term disability plans on the first of the month following the date of hire. Paid time off and 401K plan offered upon reaching eligibility.
EEOC Statement
- Ideal Setech, LLC is an equal opportunity employer and complies with all laws prohibiting discrimination on the basis of such factors as race, color, age, sex, national origin, religion, citizenship, handicap, height, weight and marital status. Under the State Persons with Disabilities Act and the Federal Americans with Disabilities Act, an employer has a legal obligation to accommodate an employee’s or job applicant’s disability unless the accommodation would impose an undue hardship on the employer. A person with a disability may allege a violation against an employer regarding a failure to accommodate his or her condition under Michigan law only if the person notifies the employer in writing of the need for accommodation within 182 days after the date the person knew or reasonably should have known that an accommodation was needed.
About Ideal Setech LLC
Manages critical spare parts and industrial inventory for manufacturers.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.