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.