OTM Lead Technical Analyst

The Sherwin-Williams Company; Cleveland (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

The Sherwin-Williams Company is seeking a Lead Technical Analyst for Cleveland headquarters to drive SaaS and enterprise-wide application support, ensuring data accuracy and efficient system performance. Role includes configuring apps, guiding data governance, and building strategic reports.

The incumbent will mentor the analytics team, collaborate with cross-functional groups and external vendors, and provide insights for management decisions. 18+ and work-authorized in the U.S. required.

Qualifications

• 6+ years of enterprise-wide software support experience.
• Extensive Oracle applications knowledge.
• Experience managing SaaS and enterprise-wide systems.
• Configure and set up Oracle apps.
• Apply security designs to tech solutions.
• Lead teams and manage databases.
• Develop and review complex custom queries.
• Data management best practices and QC processes.
• Strong analytical and problem-solving skills.
• Excellent communication and cross-functional collaboration.
• Bachelor's degree in CS/IT or 9+ years in lieu.
• Must be 18+ and eligible to work in the U.S.

Responsibilities

• Lead SaaS and enterprise application support and configuration guidance.
• Drive data quality for internal planning.
• Manage configuration, setup and updates of apps.
• Oversee data loading into tables and databases.
• Review governance for data input, structures, storage.
• Lead reporting and provide strategic insights.
• Mentor users and manage access training.
• Collaborate with cross-functional teams and vendors.
• Recommend changes in application development and standards.
• Coordinate enterprise-wide system integration and interoperability.
• Liaise with client stakeholders and external vendors.

Skills

Enterprise support

Oracle apps

SaaS systems

Data analysis

SDLC

Security design

Team leadership

Analytical thinking

Communication

Cross-functional collaboration

Education

Bachelor's degree in Computer Science or Information Technology

Tools

OTM

Oracle Cloud

ETL tools

Job description

The Lead Technical Analyst role is responsible for leading the support for software-as-a-service(SaaS) and enterprise-wide applications necessary for the collection, retrieval, accessibility and usage of data forinternal department planning and activities. The incumbent will lead the partnership with technical teams toensure software systems are running efficiently with minimal downtime. The incumbent will be responsible formaraging configuration, set up, and updates to the applications, validating that their team has entered data intoestablished tables, fields, and system databases with the highest level of accuracy. The incumbent is an expert indeveloping custom queries and building reports utilizing query and flexible reporting tools to facilitate businessmanagement decisions. The role will provide strategic advice to management concerning changes in applicationsdevelopment, maintenance and system standards to optimize performance and mitigate potential risk with theability to analyze various metrics to monitor performance and provide insights to management. The incumbent willlead and mentor the team responsible for training users on the applications and setting up user access. They willsupervise the collaboration between cross-functional teams and client stakeholders to provide sufficient supportfor the enterprise-wide applications.

WHAT THE ROLE WILL DO:

• Lead the support for software-as-a-service (SaaS) and enterprise-wide applications by providing guidance on developing and identifying design considerations and business impacts needed for configuration

• Drive quality of data for internal department planning and activities

• Lead configuration, setup, and updating of applications, and provide guidance as needed

• Manage data loading process into established tables, fields, and system databases

• Review and approve governance standards and processes for data input, structures, and storage mechanisms

• Lead the team in building reports and provide strategic insights and recommendations related to businessmanagement and staff decisions

• Lead and mentor the team responsible for training users on the applications and setting up user access

• Provide strategic recommendations for changes in applications development, maintenance, and systemstandards

• Establish and share Enterprise-wide Applications perspective when collaborating with cross-functional technicalteams within the organization, to ensure the integration and interoperability of enterprise-wide systems

• Lead and liaise with client stakeholders and external vendors to ensure support for enterprise-wide applications

• This position is not hybrid/remote and will be located at our Cleveland Headquarters office.

• This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H1-B visa.

• Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company's staff, employees, and business relationships.

• Must be eighteen years or older

Required Qualifications:

• 6+ years of experience in enterprise-wide software support with in-depth knowledge of software development methodologies

• Extensive knowledge of enterprise-wide Oracle applications and software platforms

• Experience managing software-as-a-service (SaaS) and enterprise-wide systems

• Expertise in configuring and setting up various Oracle enterprise-wide applications

• Experience applying security designs and principles to technology-based business solutions

• Experience leading teams and overseeing database management and maintenance

• Ability to develop and review complex custom queries using query and reporting tools

• Extensive knowledge of data management best practices and quality control processes

• Excellent analytical and problem-solving skills

• Excellent communication and interpersonal skills and experience collaborating with cross-functional teams and external vendors

• Bachelor's degree in Computer Science or Information Technology. In lieu of a degree, at least 9 years of experience in enterprise-wide software support

• Must be (18) eighteen years of age

• Must be legally authorized to work in the country of employmentwithout now or in the future requiring sponsorship for employment visa status (e.g., OPT, CPT, H1B, EB-1, etc.)

Preferred Qualifications:

• Experience leading or supporting multiple Oracle Transportation Management (OTM) implementations across diverse transportation networks, including domestic, international, parcel, LTL, truckload, and intermodal operations.

• Advanced knowledge of transportation management best practices, freight optimization strategies, carrier management processes, and supply chain execution within complex distribution environments.

• Experience designing and supporting integrations between OTM and enterprise applications such as ERP, Warehouse Management Systems (WMS), EDI platforms, carrier networks, and cloud integration solutions including Oracle Integration Cloud (OIC).

• Demonstrated expertise translating complex transportation requirements into OTM configurations and automated workflows, including functional design, configuration, documentation, testing, implementation, and production deployment of transportation solutions.

• Certifications in ITIL, Microsoft, and/or Oracle

Technical Skills:

• System Configuration

• Software Development Lifecyle (SDLC) Methodology

• Cloud Technologies & Platforms

• Data Analysis

• Data Modeling

• Data Warehousing & ETL Processes

• Reporting Tools

• Systems Security & Access Control