Senior Business Analyst

Contract to Hire – Senior Business Analyst

Rate: open

End Salary: $100k-$125k + bonus

Location:

Lake Forest, IL

Hybrid: onsite 2 days/week

Duration: 6 months – Contract to Hire

This role is not available to third-party firms or recruiters

• 3-5 years of related experience
• 1-5 years’ experience with reporting and collaboration tools SharePoint and Excel
• 1-5 years’ experience with reporting tools such as Smartsheet, Power BI or Tableau
• Experience/familiarity with SAP
• Experience in building PowerPoint presentations for stakeholders and C-Suite executives
• Smartsheet experience or willingness and ability to obtain advanced Smartsheet training
• Strong time management skills with the ability to prioritize and execute tasks in a deadline-driven environment.
• Strong analytical and organizational skills with a structured, data-driven approach to task management.
• Proficiency in managing recurring reporting cycles and synthesizing input from multiple stakeholders.
• Excellent written and verbal communication skills, with the ability to interact and align across teams and management levels.

• Project Management Professional (PMP) Certification
• Tableau, PowerBI
• Commercial or Sales organization background
• Manufacturing or Supply Chain industry

• Coordinate the compilation and distribution of Steering Committee and All Hands presentation materials (investor and senior leadership presentations), bi-weekly enterprise commercial pipeline reporting, and various ad hoc reports, ensuring timely updates based on pre-established weekly cadence.
• Manage the collection and integration of initiative updates and status pages from project managers across functions.
• Track and follow up on action items from integration meetings, ensuring accountability and timely resolution.
• Coordinate logistics for recurring meetings, including room reservations, calendar invites, and screen sharing.
• Facilitate the incorporation of feedback into leadership meeting decks and ensure final versions are distributed to stakeholders.
• Maintain visibility into project tracking tools within MS Excel and ensure data accuracy for reporting purposes.
• Support the cadence and consistency of reporting across business units by managing templates and timelines.
• Serve as a point of contact for internal tools (e.g., MS Teams, SharePoint, Smartsheet), including user access, troubleshooting, and basic training.
• Provide cross-functional coordination support as needed to enable information sharing and alignment across teams.