Database Analyst

United States of America
New York
Niskayuna
Fasteners
E-One
Information Technology
Full Time

  


783

With more than 120 operations and about 20,000 employees worldwide, Precision Castparts Corp. is the market leader in manufacturing large, complex structural investment castings, airfoil castings, forged components, aerostructures and highly engineered, critical fasteners for aerospace applications. In addition, we are the leading producer of airfoil castings for the industrial gas turbine market. We also manufacture extruded seamless pipe, fittings, forgings, and clad products for power generation and oil & gas applications; commercial and military airframe aerostructures; and metal alloys and other materials for the casting and forging industries. With such critical applications, we insist on quality and dependability – not just in the materials and products we make, but in the people we recruit.

Headquartered in Portland, Oregon, this over 10 billion dollar company employs more than 20,000 people worldwide.  PCC has over 120 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 being 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. Buffett, acquired Precision Castparts Corp.

PCC Fasteners and Engineered Products, 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.

Environment One Corporation (E/One) has corporate headquarters in New York and regional offices and distribution throughout the industrialized world. E/One is a manufacturer and provider of products and services for the disposal of residential sanitary waste and Utility Systems for the protection and performance optimization of electric utility assets.

 Sewer Systems

 Low-pressure, gravity-independent, contour-following sewage collection systems were pioneered by Environment One. E/One Sewer® systems have proven to be an economical and effective method of sewering otherwise difficult land areas, such as flat, wet, rocky and hilly terrain.

 

At the heart of an E/One Sewer® is the grinder pump, developed by Environment One. These units accept household sanitary waste, grind it into a fine slurry, and pressurize it to permit transport through small-diameter pipes. E/One Sewer Systems serve over 1 million end-users daily.

 

E/One's Sewer Systems business is ISO 9001:2015 certified.

 Hydrogen Systems

 Environment One’s expertise in the detection and measurement of submicron particles has led to the development of a line of critical monitoring instruments for electric utilities. The Generator Condition Monitor was designed to warn of potential failures in electric power generators by detecting the submicron particles emitted in the generator’s cooling gas during early phases of overheating or arcing.

 E/One's Hydrogen Systems business is ISO 9001:2015 certified.

To plan, organize, design, implement and maintain automated data resource management systems and insure the security and integrity of data resources.   Work with various resources to implement / automate SOX program requirements. Creative input for business systems improvements and access to data.  
•Roles: ERP systems data modeling, data administration, application architect, business analyst, developer/programmer, expert/consultant, facilitator, technical designer, mentor
•Maintain/create reports for decision making, progress/performance monitoring and financial results for all departments
•Establishes & maintains data models and data dictionaries
•Establishes & maintains physical data base environments: production, development, QA, etc.
•Active design participant in all business software enhancement and development projects
•Works to eliminate duplicated or inefficient data base structures
•Assists programmers and business analysts with program specifications and technical questions
•Stays current and knowledgeable with technical tools, methodologies, third-party business software and techniques

•College degree preferred, industry experience can be substituted – Courses of study should encompass any of the following: Computer science / technology, business administration, mathematics, science or engineering
•Technical knowledge of applications development and proficient in computer languages and third-party software – Prefer – iSeries (AS400) CL (Command Language) and DB2, MS/SQL, SSRS, MS Visual Studio and MS Power BI

•Demonstrated experience with structured data modeling and relational data base design

•Excellent analytical and problem solving skills
•Excellent oral and written communication skills
•Knowledge of MS SQL Server administration including backup/restore, indexing, recovery etc.
•Web Development experience using various tools CSS, Java, knowledge of HTML and HTML5
•Knowledge of AS400 / iSeries Command Language Operations, Administration, Objects and Libraries
•Experience in Portable Computing projects / application development for iOS
•Agile Project Management

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

This requisition is closed to applications.