Bright Futures Program Support Coordinator

Job Title:  Program Support Coordinator

Reports to:  Director of Bright Futures

FLSA Classification: Exempt

Employment Type: Full-time

About The Weld Trust (“TWT”)

The Weld Trust’s (TWT) mission is, “To promote excellence in health and education in Weld County.” It is a health conversion foundation whose beginnings came from the sale of North Colorado Medical Center in Greeley, Colorado in October 2019. TWT exists as a Supporting Organization to the Weld Legacy Foundation (WLF). The two organizations have mirrored Missions and Boards. WLF also does fundraising and funds capacity-building services that benefit health and education causes in Weld County, Colorado. WLF also serves as the fiscal agent for Bright Futures, a workforce development program, initiated by the Weld County Board of County Commissioners to provide financial support to students in Weld County.

About the Position:

The Bright Futures Program Administrator provides high-level administrative support, performing a variety of duties and skilled tasks that include frontline customer service for students, parents, and post-secondary institutions; managing the student award payment process; maintaining donor records; updating various databases; preparing reports; and collecting data. The Program Administrative position will require confidentiality and exercise independent judgment.  Reports directly to the Director of Bright Futures.

Supervisory Responsibilities:  None

Essential Functions:

• Field calls and emails from students, parents, schools, donors and others, asking about the program, an application or payment status, portal issues and other inquiries.

• Process batched award payment requests for fall, spring and summer awards, pulling reports to confirm students’ eligibility, preparing accounts payable requests and transmittals to summarize batch information, and posting payments to student accounts.
• Work with financial aid departments at post-secondary institutions on a variety of student details, such as award payments and other program requirements.
• Assist with reviewing and approving student applications and follow-up forms.
• Configure and run reports in support of award payments, and to capture student eligibility lists and other student statistics as requested by leadership.

• Process updates to the student database, which consists of multiple processes and follow-up forms and employs branched programming.
• Maintain donor records pertaining to donations received via the Weld County property tax credit program; cooperate with the treasurer’s office to receive donor information; provide donor statistics or information as requested by leadership.
• Provide COSI grant support by compiling student data for the annual report and making necessary modifications.

• Prepare report of donation and student award statistics, and other reports as requested, for the quarterly advisory board meetings.
• Prepare, print and mail thank you letters to Bright Futures donors.

• Support staff with event coordination and implementation as needed.
• Coordinate printing and mailing requests with the county print shop.
• Perform other duties as directed by supervisor.
• Exhibits integrity and demonstrates ethical behavior in everyday business conduct.
• Hours will be 40 hours a week.

Education and Experience:

• Three to five years of experience in a related role required, which must include working in Excel at an intermediate or advanced level with a working knowledge of pivot tables, mail mergers and various data functions.
• High school diploma or equivalent is required; associate degree or higher is preferred. Experience may be substituted for the educational requirement.

Required Knowledge, Skills and Abilities:

• Detail-oriented, analytical and professional.
• Exceptional customer service mindset and skills.
• Exceptional communication skills.
• Extremely proficient with Microsoft Office Suite.
• Ability to exercise initiative and considerable amount of independent judgment to interpret current policies and procedures and in developing new processes that anticipate future outcomes.
• Comfortable in learning new software applications and database programs.
• Basic understanding of office equipment.
• Ability to work independently and with a team.
• Ability to organize and prioritize tasks including delegation of tasks when appropriate.
• Knowledge of, or ability to quickly acquire, familiarity with the roles and function of the assigned department, and any specifically applicable laws or guidelines.
• Thorough knowledge of spelling, punctuation, and grammar; modern office practices and procedures; and of legal terminology as required by the position.
• Ability to read and comprehend instructions, correspondence, and department policies and procedures.
• Ability to clearly articulate concepts, directives and goals to employees and professionals.

Position Type/Expected Hours of Work

This is a full-time position.  Days and hours of work are Monday-Friday, 8:00 a.m. to 5:00 p.m.

Physical Requirements 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

• Prolonged periods sitting at a desk and working on a computer.
• Frequently required to stand, walk, sit, and reach with hands and arms.
• Frequently required to hear on phone calls and video meetings.
• Occasionally lift and/or move upwards of 15 pounds.
• Occasionally required to stoop, kneel, or crouch.

Travel Requirements

No travel is required for this position.

Work Environment  

This position requires employee to work in an office environment daily.

What We Offer

• Pay range of $48,000-$70,000
• Paid holidays (9 days)
• Paid Time Off: 3 weeks’ vacation  
• Cigna OAP and HDHP Medical Insurance
• Cigna Dental and Vison Insurance
• 100% Company paid life insurance
• 100% Company paid Short-Term Disability and Long-Term Disability Insurance
• Telehealth plan
• Voluntary legal & ID theft protection benefits
• FSA and HSA savings account options
• Voluntary supplemental life insurance, accident, hospital, and critical illness insurance
• 401(k) plan: 8% company matching contribution 

We are an equal opportunity employer and prohibit discrimination/harassment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Interested applicants should send a cover letter and resume to Lisa Taylor at lisa.taylor@weldtrust.org.