Contract Excel Jobs in Chicago, IL (NOW HIRING)

POSITION SUMMARY

The Contract Analyst contributes to the overall development and implementation of Resident Services contracts and supports the Contract Manager to conduct pre-award and post-award contract and grant administration activities, including procurement of goods and services, Board of Commissioners approval requests, monitoring and closeout. The Contract Analyst provides support for multiple contract types including Professional Service Agreements, Intergovernmental Agreements, Commensurate Benefit Agreements, Memorandums of Understanding and Grant Agreements. The Contract Analyst conducts overall monitoring of Resident Services programs, contractors and partners, which includes contractor/program performance outcome analysis. The Contract Analyst conducts on-site and off-site monitoring reviews to ensure contractors, vendors and partners are effectively implementing programs and services in accordance with terms, conditions, specifications and guidelines of contracts/agreements. 

DUTIES AND RESPONSIBILITIES

• Assists in all phases of pre and post award contract administration for Resident Services (e.g. new procurements, Board of Commissioners approval requests, internal requests for contract amendments, contract exhibits, cost analysis and cost estimates, purchase requisition and payment, grant and contract close-out and termination/corrective action memos). 

• Completes market research related to anticipated goods and services to be procured.

• Completes analysis of projected costs and historical costs related to goods and services.

• Assists with reconciliation of expenditures, revenue and contract and grant closeout. 

• Assists with organizing and reviewing documents for financial and performance audits.

• Process vendor payments and prepare monthly expense accruals as necessary.

• Analyze operating budgets and budget variances by reviewing various financial reports, such as a trial balance, to identify trends and proper expense allocation. 

• Analyze purchase order balances by keeping track of expenditures.

• Ensures data entry is completed in the designated repository.

• Ensures contracts and related documents (e.g. performance reports, budgets, amendment requests, etc.) are received, saved, and well organized.

• Maintains full understanding of contract requirements, program procedures and intended outcomes.

• Collects and analyzes data related to contractor/partner performance, expenditures, and leveraged resources and other contract requirements.

• Tracks contractor/partner corrective action plan progress; conducts follow up internal meetings and monitoring site visits, as needed to provide contractor/partner technical assistance to ensure implementation of the corrective action. Local travel to off-site locations is required.

• Other tasks as assigned by Manager or Resident Services senior management.

• Collaborates with other departments and responds effectively to internal and external requests.

• Manages and prioritizes multiple projects simultaneously and responds to change in a professional manner.

• This position may be asked to handle tasks outside of job description to meet broader goals of CHA and Resident Services.

• This position occasionally requires working hours outside of CHA's established hours of 8:30am - 5:00pm Monday-Friday

• This position may be eligible for telework up to two days per week following successful probationary period.

QUALIFICATIONS

A Bachelor's Degree in Business Administration, Finance or a related discipline is required. This position also requires a minimum of two (2) years of contract management, audit, analyst, or finance experience. A combination of education and related work experience will be considered. Effective communication skills (written and verbal) and the ability to work with a diverse staff of professional employees to coordinate the completion of assignments and effectively communicate project deliverables is required. Proficiency in Microsoft Office with strong Excel and Word skills is required; an exercise in both Excel and Word will be required during the interview process. This position requires the ability to choose the right mathematical methods or formulas to analyze financial and performance data. Strong analytical and organizational skills are needed. This position requires the ability to apply general rules/procedures to specific problems to produce logical answers and well-organized project deliverables using Microsoft Excel and Word. Knowledge of HUD or other regulations related to procurement development, contract administration and grant administration is helpful.

BENEFITS AT-A-GLANCE

• Vacation, Sick and Personal, competitive PTO package

• Medical (HMO, PPO, and No employee cost High-Deductible PPO) Dental, Vision, and Life Insurance

• Short-Term and Long-Term Disability Insurance

• Long-Term Care Insurance

• Pet Insurance

• Parking Transit

• Prepaid Legal Services

• Brightstar 529 College Savings Plan

• Identity Theft Protection

• Hospital Indemnity Insurance

• Voluntary Critical Illness Insurance

• Deferred Compensation Plan: Empower 457/401(a) with a 3% employer match

• Pension Plan: CHA makes contributions on behalf of the employee, along with the employee's 3% contribution; 100% vesting occurs after 6 years of continuous employment or opt-out of CHA's Retirement Plan and continues to participate in the Municipal Employees Annuity and Benefit Fund of Chicago

• Hybrid work schedule (position specific) This position may be eligible for remote work following a successful completion of a 90-day probationary period according to CHA's established policies and procedures.

Salary Range: $70,000 - $75,000

Grade: S6

FLSA: Exempt

Union: None

"Applications will be accepted for 30 days from the date of posting. However, the position may be closed at any point if a sufficient number of qualified applications are received."