Senior IT Business Analyst
Allegion · Cincinnati, OH · 2 mo ago
Information TechnologyFull-time
About the role
The Business Applications Analyst will serve as a key techno-functional lead for the Hollow Metal Door Strategic Business Unit (SBU) at Allegion. This role is responsible for the overall health, optimization, and integration of core business applications across multiple manufacturing plants and distribution centers.
Responsibilities
- Interacting and partnering with key business partners to drive business initiatives and further optimize system usage and best practices within existing system functionality.
- Providing tier-2 & 3 techno-functional support for key ERP systems and related manufacturing applications across the Strategic Business Unit.
- Defining practical business system solutions driving standardization within the business work streams.
- Ensuring the "digital thread" from order entry to shop-floor completion is seamless.
- Driving IT deliverables in SBU long range initiatives.
- Developing and maintaining advanced reports and dashboards using Power BI, SQL.
- Translating complex manufacturing data into actionable insights for Plant Managers and SBU leadership.
- Identifying and implementing AI-driven use cases, such as predictive maintenance alerts, automated data validation, or intelligent demand forecasting, to improve SBU productivity.
- Assisting in scoping and executing large technology projects, including facility expansions, system upgrades, and M&A integrations.
- Owning functional tactical planning for upgrades and releases with the software vendors.
- Leading Unit Testing (UT) and User Acceptance Testing (UAT) for system changes.
- Creating and maintaining high-quality functional design documents (FDDs) and technical specifications.
- Playing an active role to support continuous improvements events providing a combined view of business and system processes.
- Providing application training and assisting with general troubleshooting support.
- Maintaining documentation of recommended business system configurations, process flows, and work instructions for key business processes.
- Partnering with matrixed IT and business teams on changes and general support and roll outs.
- Responsible to use supply chain principles and general manufacturing knowledge to drive SBU initiatives.
Requirements
- Bachelor’s degree in engineering, Business, Information Technology or related field.
- 5+ years of proven experience working within large manufacturing or distribution operations.
- 10+ years of experience working with, supporting, and/or implementing an Enterprise level ERP.
- Applicable Techno-functional knowledge of AS400 / iSeries platform is a big plus.
- Skilled in using query tools (Query/400, SQL/400) to pull reports and analyze data.
- In-depth knowledge of business functions, with heavy emphasis in Order Management, Manufacturing, Warehouse Management and Supply Chain-related business, processes and practices.
- Demonstrated experience with supporting major and minor ERP upgrades and/or implementations.
- Experience in Macpac / Infor XA (Mapics) is a plus.
- Experience with Dynamics 365 Finance and Operations ERP is a plus.
- Experience developing comprehensive business requirements, functional design documents, completing impact assessments, and contributing to business cases that identify value of the change.
- Ability to work independently as well as to collaborate effectively with others in person and remotely.
- Excellent communication skills at all levels.
- Proven ability to lead and communicate orally, in written documents, and in formal presentations is required.
- Team player, change agent, and customer-driven mentality.
- Analytical approach to problem-solving, solid conceptual skills and willingness to learn, sense of urgency and commitment for a job well done.
- Strong work ethic & results oriented.
- Demonstrated ability to successfully participate in multiple initiatives simultaneously.
- Solid understanding of data integrity and audit / SOX compliance procedures.
- Experience working with and building and training AI agents to improve business processes and productivity.
- Basic familiarity with relational databases (MS-SQL, DB2/400) and on prem and cloud concepts.
- Understanding of integrations (API’s, middleware platforms) used to connect different business systems.
- Experience and understanding of Cyber Security best practices in the Manufacturing Operations space.
- Comfortable using SQL, PowerBI and other tools to work with data for ad hoc analysis.
- Comfortable working with Project Management tools and Azure DevOps for planning and documentation.
- Experience and understanding of ERP product configurator processes is a plus.
- Experience in the Hollow Metal Door or Steel Fabrication industry, including knowledge of products and custom configurations is a plus.
Benefits
- Health, dental and vision insurance coverage.
- Unlimited Paid Time Off.
- A commitment to your future with a 401K plan, which currently offers a 6% company match and no vesting period.
- Health Savings Accounts – Tax-advantaged savings account used for healthcare expenses.
- Flexible Spending Accounts – Tax-advantaged spending accounts for healthcare and/or dependent daycare expenses.
- Disability Insurance – Short-Term and Long-Term coverage, paid for by Allegion, provides income replacement for illness or injury.
- Life Insurance – Term life coverage with the option to purchase supplemental coverage.
- Tuition Reimbursement.
- Voluntary Wellness Program – Simply complete wellness activities and earn up to $2,000 in rewards.
- Employee Discounts through Perks at Work.
- Community involvement and opportunities to give back.
- Opportunities to leverage your unique strengths through CliftonStrengths assessment & coaching.
Pay
Competitive compensation package based on experience and qualifications.
Schedule
Full-time position with flexible hours to accommodate the needs of the business and the individual.