Data Analyst

Junior Contracts Data Analyst

Client: Sherwin‑Williams

Location: Cleveland, Ohio (Onsite – 5 days/week)

Structure: 1‑month contract with strong extension potential (2–4 months)

Pay: $24–28/hr (pay dependent on experience)

About the Client

Sherwin‑Williams is a global leader in paints, coatings, and related products, serving professional, industrial, commercial, and retail customers worldwide. Headquartered in Cleveland, Ohio, Sherwin‑Williams is a Fortune 500 company known for its strong culture, long‑term career opportunities, and investment in people, technology, and operational excellence.

About the Role

The Junior Contract Data Analyst will support a short‑term but high‑impact initiative focused on improving visibility into enterprise contract spend. This role is responsible for entering, validating, and organizing historical contract data within ServiceNow to enable accurate annualized spend reporting for leadership and budgeting teams.

This is a data‑focused, detail‑oriented role with light investigative work and strong collaboration across procurement and contracts teams. The role offers excellent exposure to enterprise systems, contract workflows, and internal stakeholders, with clear potential for extension based on performance and project needs.

Job Description – Duties & Responsibilities

Data Entry & Contract Analysis

• Enter and organize contract data within ServiceNow, including building annualized expense lines by year
• Convert total contract values into accurate annual spend figures
• Ensure data integrity by validating totals and identifying discrepancies
• Review historical purchasing data in Coupa to capture additional spend tied to contracts
• Flag missing or unclear information and work with internal stakeholders to resolve questions

Deal Summary Support (Nice‑to‑Have / Extension Work)

• Create 1‑page contract deal summaries using a standardized Excel template
• Capture key deal attributes such as contract duration, negotiated pricing, savings, and payment terms
• Review existing notes and contracts to extract relevant details
• Communicate with contract owners when information is incomplete or unavailable
• Use tools such as Microsoft Copilot (approved internally) to accelerate summarization where applicable

Collaboration & Communication

• Work closely with contracts, procurement, and operations teams in a highly collaborative environment
• Ask questions proactively to avoid delays and ensure accuracy
• Maintain a strong sense of urgency to meet short project timelines

Basic Requirements

• Strong attention to detail and comfort with data entry‑focused work
• Proficiency with Microsoft Excel (sorting, organizing data, basic formulas)
• Ability to analyze numbers and recognize when values do not align
• Clear communication skills and willingness to ask questions
• Ability to work onsite in Cleveland, OH, five days per week

Preferred Qualifications

• Experience with ServiceNow, Coupa, or similar procurement/ERP platforms
• Exposure to contracts, purchasing, finance, or operations data
• Familiarity with reviewing contractual terms (not required)
• Early‑career candidates or recent graduates encouraged to apply

Skills

• High level of accuracy and organization
• Critical thinking and problem‑solving abilities
• Strong time management and sense of urgency
• Comfort working in a fast‑paced, team‑based environment
• Willingness to take ownership of assigned tasks

About Us:

At Brooksource, relationships are the foundation of everything we do. Since 2000, we’ve built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program. Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company’s unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.

We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.

EEO Statement:

Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.

Benefits & Perks:

Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Pay Disclaimer:

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.