IT Application AnalystAleris

Job Details

Description

Commonwealth Rolled Products is a leading manufacturer of Aluminum rolled products for the Automotive, Commercial, and Industrial markets. The Company operates its production facility in Lewisport, KY with the support of an Automotive Innovation Center for R&D and Field Service in Madison Heights (DET), MI and Inside Sales in the Cleveland, OH area.

Our Company is seeking to add a IT Application Analyst to its IT team. This role is responsible for developing and maintaining standards, daily performance reports and metrics, improving quality, productivity, delivery performance, reducing cost, and providing historical, predictive and proactive management tools for operations and technical groups within the plant.

Responsibilities Include:

• Actively participate in maintaining a zero-incident safety culture.
• Live and champion the Commonwealth Rolled Products core values: Safety, Integrity, Customer Focus, Ownership, Excellence, and Teamwork.
• Identify opportunities, evaluate benefits, develop recommendations, and with Manager's approval, initiate action plans to improve the production processes, practices, tactical and strategic planning and systems associated with the Industrial Engineering team and Plant Operations.
• Analize user Change Requests using both technical and ROI input
• Manage support vendors to maintain healthy server environments
• Design, create, and implement SQL views and queries that pull from a variety of data sources as needed to establish new reports or alerts.
• Operate and maintain various virtual machines that perform ETL jobs, alerts, monitoring, and file management.
• Manage contractor resources to resolve issues, create data flow processes and support reporting requests.
• Design, build, and maintain ETL processes from a variety of data sources including but not limited to – Oracle, MVS, MES, IBA, CSV Flat Files, Excel Files, and Emailed Files.
• Support identified CAR projects.
• Support shop floor legacy systems and new system implementations analysis for operator data collection supporting quality improvement.
• Develop and maintain a climate within Commonwealth that enhances mutual respect, team identity, effective working relationships, employee involvement, innovation and generation of new ideas.
• Power BI Development & Support for all users and ensure data integrity.

Required Qualifications:

• Four-year degree or equivalent experience in lieu of education
• 5+ years of systems development or programming experience in an industrial environment
• Must possess excellent written and oral communication skills, interpersonal skills, and organizational skills.
• Technological skills required are Microsoft Office Suite including Microsoft Access, Microsoft SQL Server and Report Services, Visual Basic, Power BI Developer.

EEO Statement

Commonwealth Rolled Products is an equal opportunity employer. Qualified applications will receive consideration for employment without regard to their race, religion, color, sex, pregnancy or pregnancy-related conditions, sexual orientation, gender identity or expression, age (forty and over), national origin, disability (as defined by applicable law), veteran’s status, genetic information, marital status, or any other status or characteristic protected by applicable law. Our HR team will reach out to the applicants who met the qualifications and most closely aligned with requirements of the positions.