Finance Automation Reporting Analyst

Collins Consulting, Inc

Mettawa, IL

Apply

JOB DETAILS

JOB TYPE

Full-time

LOCATION

Mettawa, IL

POSTED

10 days ago

This is a hybrid position - 3 days onsite Tues/Wed/Thurs The primary objective of this position is to support the transition of forecast ownership from external vendors to the internal Finance team. This role will focus on enhancing visibility into vendor-built forecasts, establishing robust financial models, and developing management reporting tools. The ideal candidate is a strong communicator, technically adept in Excel-based modeling, and experienced in business partnership. Responsibilities: Vendor Engagement & Assumption Management Act as Finance liaison with external forecasting vendors. Gather and document forecast assumptions, version history, and driver inputs. Ensure timely delivery of complete, accurate forecast data from vendors Model Ownership & Forecast Transition Build or adapt Excel-based financial models to reflect business assumptions and scenario planning. Shadow vendor-produced forecasts and create Finance-owned versions for comparison. Assist in the phased transition of partial model ownership to the internal team Management Reporting & Variance Analysis Design and produce clear, automated management reporting tools. Develop variance analysis frameworks tied to forecast assumptions. Partner with Finance and Business teams to surface key insights Team Enablement & Documentation Create templates, trackers, and process documentation to support long-term ownership by Finance. Identify and recommend opportunities to streamline forecasting and reporting processes. Qualifications: Requires 7-10 years progressive accounting or finance experience This position requires an individual with the ability and desire to proactively search out and evaluate business problems and opportunities Advanced Excel modeling skills required; experience with PowerPoint or Power BI a plus Strong analytical, communication, and project management skills Proven ability to work independently and drive results in a matrixed organization Comfortable engaging with both internal stakeholders and third-party vendors Top 3 5 Skills Needed: 1. Project Management 2. Financial Modeling Design 3. Financial Reporting Package Design Requires strong written communication skills, with the ability to produce clear, professional, and grammatically sound corporate-level English content for audiences at all levels, including stakeholders. The benefits that you are eligible for with Collins Consulting, Inc: 401(k) Medical, Dental and Vision Insurance Term Life Insurance Accidental Death and Dismemberment Long Term Disability

About the Company

Collins Consulting, Inc

Collins Consulting brings over two decades of total talent solutions experience to meet your on-demand consulting needs. We have an established history of serving clients nationwide in both the public and private industries. These clients range from Fortune 100 companies within the commercial arena to supporting contracts within federal agencies.

Collins Consulting is a certified Service-Disabled Veteran Owned Small Business and a SBA Small Business. We believe in servicing our country's veterans by supporting and nurturing opportunities to join their skillsets with clients who have the same principles. These certifications coupled with Top Secret facility clearance allow us to meet category and diversity goals.

Collins Consulting is agile, innovative, and an award winning advocate in providing total talent solutions to serve your business needs. Whether you are a professional who is looking for a new career or an organization in need of experienced talent, we have the resources to help you.

COMPANY SIZE

10 to 19 employees

INDUSTRY

Staffing/Employment Agencies

WEBSITE

http://www.colcon.com