Production Control Data Analyst (Lafayette, IN, US, 47905)

<p style="text-align:center;background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><span style="font-size:18.0pt;color:black">Production Control Data Analyst</span></strong></p> <p style="text-align:center;background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><em><span style="font-size:14.0pt;color:black">Production Control Department</span></em></strong><span style="font-size:12.0pt;font-family:Verdana, sans-serif;color:black"> </span></p> <p style="text-align:center;background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"> </p> <p style="text-align:center;background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="font-size:12.0pt;font-family:Verdana, sans-serif;color:black"> </span></p> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><u><span style="color:black">Position Summary:</span></u></strong></p> <p style="margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black;background-color:white">The Production 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. </span></p> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="font-size:12.0pt;font-family:Verdana, sans-serif;color:black"> </span></p> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><u><span style="color:black">Outline of Duties:</span></u></strong></p> <ul> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Analyze various scenarios for line speed, overtime, weekend production and capacity increases. </span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Develop systems, processes, and databases to capture and visualize constraints and production projections.  Report out using information as required.</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Use data modeling tools to translate requirements into functioning, accurate data analysis solutions, including writing custom code in SQL and other languages as needed</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Develop efficient, robust ETL processes to extract data from transactional systems and other sources; follow organizational change management procedures</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">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</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Design and build reports and data visualizations, including dashboards</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Deliver ad hoc reports and data extracts as needed</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">All other duties as assigned</span></li> </ul> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="font-size:12.0pt;font-family:Verdana, sans-serif;color:black"> </span></p> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><u><span style="color:black">Minimum Qualifications:</span></u></strong></p> <ul> <li style="font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Bachelor’s degree in Information Technology, Data Analytics, related field, or equivalent years of experience</span></li> <li style="font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Strong software skills in Excel, Access, SQL, and Visual Basic</span></li> </ul> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"> </p> <p style="background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><u><span style="color:black">Desired Qualifications:</span></u></strong></p> <ul> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Bachelor’s degree in Information Technology, Data Analytics, related field, plus 3-5 years of experience</span></li> <li style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"><span style="color:black">Experience in automated Manufacturing industry</span></li> </ul> <p style="background-color:white;font-size:11.0pt;font-family:Calibri, sans-serif"> </p> <p style="text-align:center;background-color:white;margin:0.0in;font-size:11.0pt;font-family:Calibri, sans-serif"><strong><em><span style="color:black">Subaru of Indiana Automotive, Inc. is an equal opportunity employer committed to employing a diverse workforce.</span></em></strong></p>