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

*We are unable to provide sponsorship for this role*

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

Qualifications

• Bachelor s degree
• 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.

Bonus Points

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

Responsibilities

• 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.