IT Systems Analyst

Brooks Instrument; Hatfield Township (PA); On-site; USD 75,000 - 105,000; Full time

Benefits offered by this job

Health and dental insurance

Company Paid Life Insurance

Disability insurance (short/long term)

401K with company match

Paid vacation & holidays

Continuing education reimbursement

Flexible spending accounts

Job summary

Brooks Instrument, based at the headquarters in Hatfield, PA, is seeking an IT Systems Analyst to support and enhance enterprise applications and databases. You will focus on system administration, integration, troubleshooting, and ongoing improvements for platforms such as SQL-based apps, CPQ, Teamcenter, and related business systems.

The role collaborates with stakeholders, IT peers, and vendors to ensure stable performance, reliable data flows, and effective user adoption across the

Qualifications

• Bachelor’s degree in information technology, computer science, information systems, engineering technology, or related field or comparable 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 for performance and reliability.
• Configure settings, roles, permissions, metadata, and workflows.
• Support upgrades, patches, enhancements, and feature rollouts.

Skills

SQL

System Administration

APIs & ETL

Teamcenter

Power Automate

Education

Bachelor’s degree in IT/CS/IS

Tools

MS SQL

Oracle

Therefore Cloud

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

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.