IT Systems Analyst

Illinois Tool Works; Hatfield (AR); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health and dental insurance

Company Paid Life Insurance

Short and Long Term Disability

401K plan with company match

Vacation, personal days and holidays

Continuing education reimbursement

Flexible spending accounts

Job summary

Illinois Tool Works seeks an IT Systems Analyst at its Hatfield, PA headquarters. The role concentrates on administering key enterprise applications, ensuring data integrity, and enabling efficient workflows across IT, sales, and engineering teams.

The position emphasizes SQL proficiency, system administration, and collaboration with vendors on API-based integrations. A mid-level professional with 3–5+ years of relevant experience is preferred.

Qualifications

• Bachelor's degree in information technology, computer science, information systems, or related field, or equivalent experience.
• 3–5+ years with SQL and stored procedures in enterprise settings.
• Hands-on experience with databases and PLM/CPQ systems.
• Experience administering or supporting Teamcenter, Windchill, or similar PLM tools.
• Experience with API-based integrations and data flow troubleshooting.

Responsibilities

• Administer and maintain core business applications and databases for reliability.
• Configure settings, roles, permissions, metadata, and workflow elements.
• Support upgrades, patches, and feature Rollouts.
• Provide user support for SQL apps, Infor CPQ, Therefore Cloud, Teamcenter, and related systems.
• Lead issue resolution across technical teams; document knowledge base.

Skills

SQL & stored procedures

Enterprise applications

System administration

APIs & ETL

Data flow troubleshooting

Documentation

User enablement

Education

Bachelor’s degree in IT/CS/IS

Tools

MS SQL

Oracle

PostgreSQL

Infor CPQ

Teamcenter

Therefore Cloud

SharePoint

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.

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.