Applications Developer - REMOTE - Jenkintown, PA

Company Profile:

Precision Castparts Corp. (PCC) is a leading worldwide, diversified manufacturer of complex metal components and products. It serves the aerospace, power, and general industrial markets. PCC is the market leader in manufacturing large, complex structural investment castings, airfoil castings, and forged components used in jet aircraft engines and industrial gas turbines. The Company is also a leading producer of highly engineered, critical fasteners for aerospace and other general industrial markets, manufactures extruded seamless pipe, fittings, forgings, and clad products for power generation and oil & gas applications, and supplies metal alloys and other materials to the casting and forging industries.  PCC is a high-quality business with dominant positions in most segments of the markets in which it serves.

Headquartered in Portland, Oregon, this over 10-billion-dollar company employs more than 29,500 people worldwide.  PCC has over 160 plants and has a presence in twenty-six states in the US and in over a dozen countries.  PCC is relentless in its dedication to be a high-quality, low-cost and on-time producer; delivering the highest value to its customers and shareholders while continually pursuing strategic, profitable growth.

Effective early February 2016, Berkshire Hathaway, led by chairman and CEO Warren E. Buffet, acquired Precision Castparts Corp. Mr. Buffet stated, “I’ve admired PCC’s operation for a long time. For good reasons, it is the supplier of choice for the world’s aerospace industry, one of the largest sources of American exports. Berkshire’s Board of Directors is proud that PCC has joined Berkshire.”

Business Profile:

PCC Fasteners and Engineered Products, which include the PCC Industrial & Distribution Group, consist of specialized manufacturing businesses that produce fasteners, precision components, systems, tooling, and engineered system solutions for a diverse group of end customers in the automotive, aerospace & defense, industrial machinery, and other performance-driven markets.

PCC Fasteners and Engineered Products' manufacturing operations are spread over four continents, forming a network of industry-leading companies, which enables our customers to utilize our experience and deep product knowledge wherever they need it. Embedded in a culture of continuous improvement, our assets and industry leadership insure that we will consistently deliver our customers the best value in the markets we serve.

Location Profile:

Founded in Jenkintown, PA in 1903 as Standard Pressed Steel Company, SPS Technologies continues to operate from the original 560,000 square foot facility.

SPS Technologies has been developing and manufacturing critical fasteners since the early days of aviation, working closely with its customers to meet the needs of an ever-changing industry.

Many of the materials, designs, and manufacturing practices that have become industry standards were pioneered by SPS Technologies. SPS Technologies continues to advance the materials, designs, and manufacturing practices of aerospace fasteners today to meet the unique needs of next generation vehicles and assembly techniques.

Position Summary:

Responsible for the design, development, testing, and maintenance of Syteline ERP applications, forms, modules, interfaces, and reporting solutions. This position will work closely with staff in Information Technology, Operations, Sales, Purchasing, Quality, Finance, and other groups to help deliver timely and exceptional technical ERP-related solutions to business needs. They will also heavily participate in ERP implementation and migration projects throughout the company.

Primary Duties/Responsibilities:

• Design, develop, test, and maintain Syteline ERP applications and modules with system and data interfaces.
  • This includes, but is not limited to: form design and behaviors, component class/string/validator manipulation, IDO development and modification, data views and workbench customizations.
  • This also encompasses backend database development within the Syteline database schema and related systems/modules. The position requires a solid knowledge of stored procedure/function development and debugging, and the ability to analyze the path of data through these and any other SQL objects (triggers, tables, temporary tables, table variables, etc)
• Design, develop, test, and maintain Syteline ERP reporting utilizing SQL Server Reporting Services and Microsoft PowerBi.
  • Syteline reports could potentially include any or all of the following: various graphing and visualizations, drill-down data, grouping, aggregation, conditional formatting and others in an array of report types.
• Work face to face and remotely with end-users and I.T. staff to define technical/user requirements documentation and testing plans. This is not a typical “head-down” coding position. The candidate must be comfortable frequently collaborating on proposed solutions and then working quickly and independently to deliver them.
• Rigorously test and review code produced for defects, quality, and efficiency improvements.
• Troubleshoot general ERP database problems, data issues, and performance tuning issues. The candidate must demonstrate an ability to analyze large amounts of SQL Server data in the Syteline database schema to quickly locate issues with failing jobs, stored procedures and other objects and processes.
• Participate in daily staff meetings and provide clear, concise updates on progress, issues, and commitment dates.
• Follow PCC Fastener and industry standards and best practices for coding design and testing methodologies and contribute to improving existing processes when able.
• Keep up to date on emerging technologies and trends relevant to development in the Microsoft stack as appropriate to ERP development (SQL, SSRS, SSIS, etc) and make recommendations when they see opportunities for improvement.
• Function as a member of a team of subject matter experts on Syteline-related development and process.
• Follow appropriate IT Sarbanes-Oxley compliance policies relating to code management, versioning, documentation, and deployment.
• Available for off-hour issue resolution or major deployments when necessary.
• Perform other duties as necessary or appropriate to position.

Experience and Education

• Bachelor’s degree in Computer Science or related field.
• At least 5 years’ experience developing, testing and deploying ERP solutions on the Syteline and Mongoose platform. Repeatable/re-useable objects and code should be a focus whenever possible.
• At least 5 years’ experience with back-end T-SQL development in SQL Server. Must excel at efficient/complex T-SQL coding (joins, objects, etc.), understand how to read and react to execution plans, and at least a conversational understanding of how different indexing works. Performance and efficiency is crucial in all of our development projects.
• At least 2 years’ experience developing reporting solutions in SQL Server Reporting Services, particularly referencing Syteline ERP data schemas. PowerBi experience is preferred as well.
• Proficiency in MS Office products. Any VBA experience in Excel is a plus.
• Familiarity with different SDLC methodologies and a personal focus on quality deliverables and unit testing.
• Excellent communication, organization, and technical documentation skills.
• Ability to work in a fast-paced and agile team environment with multiple high priority initiatives.
• Self-starter who is driven to learn and take ownership of issues. Willing to perform “deep dives” in search of root causes and solutions.
• Aptitude for assessing new business logic and process quickly and translating that to effective technical and data-driven solutions.
• A positive attitude and eager to take on unfamiliar or difficult issues, logic, and business needs. Candidate should be excited about coding and delivering difficult solutions and take pride in their work.
• Candidates with previous manufacturing IT experience will receive first consideration.

Required Skills

Must have the knowledge, skill, and ability to meet expectations for required competencies in position, which includes: 1) safety, health, and environmental awareness, 2) business ethics and compliance, 3) technical/professional competence and quality & time management, 4) interpersonal relations and communication skills, 5) initiative, flexibility, innovation, and adaptability, 6) continuous improvement and problem solving, and 7) planning and organizing.

ITAR Requirements:

Our organization has a responsibility to comply with all applicable requirements set forth by International Traffic Arms Regulations (“ITAR”, 22 CFR 120-130). As such, this position may have access to ITAR controlled information and must meet eligibility requirements to work in the United States.

Precision Castparts Corp. is an equal opportunity employer committed to recruit, hire, train, and promote in all job categories without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or other status protected by applicable law.