Job Description

Sr Lead Programmer/Analyst
Department: All Openings, Information Technology

Job Title: Sr Lead Programmer/Analyst

Essential Job Functions
• Design systems to meet end user information needs from multiple application and database environments.
• Create & automate reports, iteratively build & prototype dashboards to provide insights at scale, solving for business priorities.
• Ensure data consistency and reuse by establishing and enforcing company-wide data standards.
• Ensure essential procedures are followed and help define operating standards and processes.
• Serve as advisor or coach to new or lower-level analysts.
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members. Interface with software vendors to obtain information and support for problems, coordinate systems repair as required.
• Research technical innovations and assist in planning for the future direction of the Company and department.
• Experience in a software development position including all aspects of the Software Development Life Cycle (SDLC); including requirements definition, technical designs, coding, testing and implementation.
• Experience articulating business questions and scripting to pull data from datasets, and adapt quantitative techniques to solve complex problems.
• Monitor and troubleshoot data flow issues, ensuring timely resolution. Optimize data flow processes to enhance efficiency and reliability.
• Analyze and map inbound data flows across multiple systems and tools to ensure the integrity and connectivity of the data.
• Strong background with Oracle database technology using SQL, and PL/SQL.
• Work with functional departments to continuously improve systems by identifying opportunities for improved functionality by redesigning system solutions and re-engineer business processes as needed to include fixing of bugs/issues.
• Support and help train staff in functionality and technical tools to support the company's suite of products.
• Perform project management duties as required to complete assigned projects
• Perform other related duties as required.

Minimum Position Qualifications

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education and Experience

Requires a Bachelors' Degree in Computer Science, a minimum of five years computer programming experience in a manufacturing environment, and two years Infor ERP LN computer system experience, or equivalent combination of education and experience.

Comprehensive knowledge of computer technology and computer languages, Infor ERP LN elements such as manufacturing, inventory control, distribution and finance systems, Infor ERP LN Tools skills in system design and development, and project management skills are required to perform the duties of this position.

Physical Demands
• Demonstrates physical and functional ability to perform and accomplish tasks. Ability to lift and carry up to 35 lbs.

Mental Demands

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed 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.

Required skills:

• Working knowledge of Oracle, SQL Server and HRIS systems
• Business intelligence reporting
• Linux
• Strong working experience in one or more of the following ERP modules:

• Finance
• Manufacturing
• Purchasing
• EDI
• Sales
• Planning
• Warehousing
• Quality

• Infor EAM
• Infor ION
• Infor Factory Track/Warehouse Mobility
• Strong technical skills with LN Tools

Working Conditions
• The work environment characteristics described here are representative of those the employee encounters while performing the functions of this job .
• While performing the duties of this job, the employee is frequently exposed to both office and plant environments. May be exposed to odors, chemical agents, dust, fumes, gases, sharp objects, hazardous or moving equipment, wet slippery floors, and extremes in temperature and humidity.
• Interacts regularly with various staff and employees, and occasionally with vendors, suppliers, community members and regulatory agency representatives.
• Travel and overtime are required when necessary.

Operational Excellence
• Supports all operational excellence initiatives ensuring full participation in all department services, continuous improvement efforts, and training programs.

Quality Assurance
• Maintains a safe, orderly working environment including FOD compliance.
• Ensures adherence to Piper Aircraft, Inc. corporate compliance policies.
• Adheres to organization and department policies and procedures.

Compliance
• Responsible for ensuring compliance with laws, rules and regulations appropriate to job function.
• Comply with all organizational policies and standards regarding ethical business practices.
• Work ethically and with integrity; upholds organizational values.
• Maintains compliance with company safety policies and procedures, OSHA, and EPA regulations including Personal Protective Equipment (PPE), behaviors, physical space and hazardous waste disposal procedures.

Communicates Effectively
• Effective communicator with strong interpersonal skills who understands how to develop and maintain external supplier and internal customer relations in both written and oral form.
• Maintain a high level of professionalism at all times during direct contact with employees, suppliers, and customers.

Decision Quality
• Makes good and timely decisions that keep the organization moving on-time with deliverables.

Optimizes Work Processes
• Knows and contributes the most effective and efficient processes to get things done, with a focus on continuous improvement.

Attention to Detail
• Takes responsibility for a thorough, accurate, and detailed method of completing work tasks.

Drives Results
• Overcomes adversity, consistently achieving quality results - even under demanding deadlines and unexpected operating circumstances.

Teamwork
• Interacts, partners, and collaborates effectively with others, positively contributing to overall department and organizational deliverables and results.

Please note - This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this position. Duties, responsibilities and activities may change at any time with or without notice. Work beyond 40 hours per week including mandatory overtime may be required.