Production Control Data Analyst

Subaru of Indiana Automotive, Inc; Lafayette (IN); On-site; USD 70,000 - 100,000; Full time

Job summary

Subaru of Indiana Automotive, Inc. is seeking a Production Control Data Analyst to collect and analyze data to support production scheduling and resource planning for short, mid, and long-term horizons.

You will build systems to capture and visualize constraints, develop ETL processes, and deliver dashboards and ad hoc reports. Strong SQL and Visual Basic skills with experience in data modeling are preferred.

Qualifications

• Bachelor’s degree in IT, Data Analytics or related field.
• Strong skills in Excel, Access, SQL, and Visual Basic.
• Experience with data modeling and ETL processes is preferred.

Responsibilities

• Collect and analyze data to support production scheduling and resource planning.
• Develop systems and databases to capture and visualize constraints and projections.
• Create reports, dashboards, and ad hoc data extracts.
• Write SQL and other code to translate requirements into data solutions.
• Support continuous improvement and provide recommended metrics.

Skills

Data analysis

Analytical thinking

Education

Bachelor's degree in Information Technology, Data Analytics, related field

Tools

Excel

Access

SQL

Visual Basic

Job description

TheProduction Control Data Analyst is responsible for data collection and analysis used to develop production and resource strategies for the short, mid, and long term. This role will improve the efficiency of data collection and develop tools to analyze and use data to support production scheduling.

Outline of Duties:

• Analyze various scenarios for line speed, overtime, weekend production and capacity increases.
• Develop systems, processes, and databases to capture and visualize constraints and production projections. Report out using information as required.
• Use data modeling tools to translate requirements into functioning, accurate data analysis solutions, including writing custom code in SQL and other languages as needed
• Develop efficient, robust ETL processes to extract data from transactional systems and other sources; follow organizational change management procedures
• Lead and/or support continuous improvement activities to improve analysis capability and performance; advise the business on possible and recommended metrics based on experience and industry best practice
• Design and build reports and data visualizations, including dashboards
• Deliver ad hoc reports and data extracts as needed
• All other duties as assigned

Minimum Qualifications:

• Bachelor’s degree in Information Technology, Data Analytics, related field, or equivalent years of experience
• Strong software skills in Excel, Access, SQL, and Visual Basic

Desired Qualifications:

• Bachelor’s degree in Information Technology, Data Analytics, related field, plus 3-5 years of experience
• Experience in automated Manufacturing industry

Subaru of Indiana Automotive, Inc. is an equal opportunity employer committed to employing a diverse workforce.