IT Systems Analyst

ITW; Hatfield Township (PA); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Life insurance

Disability insurance

401K

Vacation & time off

Education reimbursement

FSA

Job summary

Brooks Instrument in Hatfield, PA, seeks an IT Systems Analyst to maintain and enhance enterprise applications across operations, sales, and engineering. You will administer core systems, support integrations, and drive continuous improvement for platforms such as a SQL-based app, Infor CPQ, and Teamcenter.

The role partners with IT peers and vendors, handling configuration tasks, troubleshooting, data flows, and user enablement.

Qualifications

• Bachelor’s degree in information technology, Computer Science, Information Systems, Engineering Technology, or related field – OR – Comparable enterprise systems experience.
• 3–5+ years’ experience with SQL and stored procedures.
• 3–5+ years’ experience supporting enterprise business applications.

Responsibilities

• Administer and maintain core business applications and databases, ensuring performance and reliability.
• Configure settings, roles, permissions, metadata, and workflow elements.
• Support system upgrades, patching, enhancements, and feature rollouts.

Skills

SQL

Stored Procedures

System Administration

Data Integration

API / ETL

SQL Databases

Documentation

Analytical Skills

Education

Bachelor’s degree in IT/CS/IS/Engineering

Tools

Teamcenter

Therefore Cloud

Infor CPQ

Power Automate

SharePoint

Windchill

SQL Server

Oracle

PostgreSQL

Job description

Job Description:

Brooks Instrument ( www.brooksinstrument.com ), an industry leader in flow and pressure instrumentation for critical applications, is seeking candidates for a IT Systems Analyst position that will be based at the company headquarters in Hatfield, Pennsylvania (suburban Philadelphia). The company has manufacturing locations in Pennsylvania, Hungary, Malaysia and Korea, and also maintains sales and service offices throughout the world. Our high-tech products are used in laboratory and process applications in end markets such as: oil & gas, petrochemical, medical devices, waste water, life sciences, and analytical instruments.

Brooks is a division of ITW (Illinois Tool Works), a fortune 200 company. ITW is one of the world’s leading diversified manufacturers of specialized industrial equipment, consumables, and related service businesses. The company has operations in 56 countries and employs over 50,000 employees. These talented employees, many of whom have specialized engineering or scientific expertise, contribute to ITW’s global leadership in innovation. The company is proud of its broad portfolio of nearly 10,000 active patents, and is focused on fully leveraging its highly differentiated business model to deliver solid growth with consistent best‑in‑class margins and return on capital.

Basic Function

The IT Systems Analyst is a mid‑level technical role responsible for supporting, maintaining, and enhancing key enterprise business applications and databases across the organization. The role focuses on system administration, integration support, troubleshooting, and continuous improvement for critical platforms such as custom-developed SQL application, Infor CPQ, Siemens Teamcenter, Therefore Cloud, and related business systems that support operations, sales and engineering functions.

The IT Systems Analyst works independently on support issues, configuration tasks, and enhancement projects, while also collaborating with business stakeholders, IT peers, and software vendors. This position plays a key part in ensuring stable system performance, reliable data flows, and effective user adoption throughout the organization.

Key Responsibilities

Application Administration & Configuration

• Administer and maintain core business applications and databases, ensuring performance, reliability, and alignment with business processes.
• Configure application settings, roles, permissions, metadata, and workflow elements.
• Support system upgrades, patching, enhancements, and feature rollouts.

Support & Troubleshooting

• Provide user support for custom-developed SQL applications, Infor CPQ, Therefore Cloud, Teamcenter, and other business systems.
• Lead the investigation and resolution of complex application issues, working across technical teams as needed.
• Maintain documentation, knowledge base articles, FAQs, and job aids.

Integration & Data Support

• Monitor and support integrations between systems (e.g., CPQ ERP, CPQ CRM, PLM ERP, DMS PLM).
• Analyze SQL databases, validate data mappings, and assist with data transfer between databases.
• Work with developers or integration partners on API‑based workflows, ETL processes, SQL import/extract, and automated data exchanges.

User Enablement & Training

• Provide guidance, training sessions, and onboarding for end users and power users.
• Partner with business teams to ensure workflows and processes are standardized and well understood.
• Communicate system changes, outages, and new features to the organization.

Projects & Continuous Improvement

• Participate in and sometimes lead smaller application enhancement projects.
• Perform system testing, QA, UAT coordination, and post‑release validation.
• Contribute to long‑term application roadmaps and architectural discussions as needed.

Required Qualifications

Education

• Bachelor’s degree in information technology, Computer Science, Information Systems, Engineering Technology, or a related field – OR – Comparable experience in enterprise systems.

Experience

• 3–5+ years’ experience working with SQL and stored procedures
• 3–5+ years of hands‑on experience supporting enterprise business applications
• Practical experience administering or supporting systems such as:
• Databases (e.g. MS SQL, Oracle, Postgre etc..)
• PLM Systems (e.g. Teamcenter, Windchill, etc…)
• CPQ (e.g. Infor, Salesforce, etc..)
• Document Management or Workflow applications (e.g., Power Automate, Therefore Cloud, Workato, SharePoint, etc…)
• Experience supporting integrations, data flow troubleshooting, or API‑driven systems.

Technical Skills

• Strong understanding of SQL (queries, views, stored procedures, functions, jobs)
• Familiar with system administration concepts (roles, permissions, metadata, workflows).
• Intermediate understanding of system integrations, APIs, ETL flows, or middleware.
• Familiarity with JSON/XML, REST APIs, CSV import/export, and related data formats.
• Comfortable working with logs, monitoring tools, and admin consoles.
• Knowledge of IT change management (ITIL) practices.

Soft Skills

• Strong analytical and problem‑solving abilities.
• Clear communication skills for working with end users and technical teams.
• Ability to manage multiple priorities and work independently.
• Solid documentation skills and a disciplined approach to process.
• Business‑facing mindset with the ability to translate requirements into system actions

Benefits

Our employees enjoy competitive, merit‑based salary plus excellent benefits including:

• Health and dental insurance
• Company Paid Life Insurance
• Short and Long Term Disability
• 401K plan with generous company match
• Vacation, personal days and holidays
• Continuing education reimbursement program
• Flexible spending accounts

The opportunity to join a well established (80 years in business) yet dynamically changing organization that works together as a team to meet the challenges of satisfying customers’ needs and managing rapid growth to better compete in a global marketplace.

ITW is an equal opportunity employer. We value our colleagues’ unique perspectives, experiences and ideas and create workplaces where everyone can develop their careers and perform to their full potential.

As an equal employment opportunity employer, ITW is committed to equal employment opportunity and fair treatment for employees, beginning with the hiring process and continuing through all aspects of the employment relationship.

All qualified applicants will receive consideration for employment without regard to race, color, sex, gender identity, sexual orientation, religion, national origin, age, disability, protected Veteran status or any other characteristic protected by applicable federal, state, or local laws.