Sql data analyst Jobs in Killeen, TX

Treasury Analyst

Assists the Director of Financial Services (Controller) in monitoring and maintaining bank accounts, investment pools, securities, and recording financial transactions to the general ledger. Assists the Treasury Specialist with accounts receivable, procurement and security of district funds in accordance with state and federal guidelines and district policies.

Essential duties and responsibilities include the following:

• Monitor bank balance and collateral requirements daily.
• Coordinate with the Controller for funding needs and cash availability.
• Prepare and report cash and investment pool balances daily to the Controller and Director of Financial Reporting.
• Monitor Texas Education Agency (TEA) and the Texas State Comptroller for deposit notifications, move received funds to appropriate accounts according to budget code fund, and record journal entries to the general ledger.
• Process all deposits & direct deposits received in investment pools and assigned bank accounts.
• Coordinate with other departments to collect supporting documentation and budget code fund needed to record journal entries to the general ledger.
• Compile vendor funding reports for vendor payments.
• Prepare withdrawal request forms to fund payments from investment pool accounts.
• Initiate bank transfers from the depository accounts to the vendor clearing account once funding is received.
• Maintain record of voided vendor payments and payroll checks.
• Initiate wires and ACH requests, and complete transfers for district payrolls, liabilities, benefits payments, and risk management invoices once reconciled and approved by accounting.
• Prepare withdrawal request forms to fund payments and initiate bank transfers to the payroll clearing account once funding is complete.
• Complete bank transfers as requested for the Controller, Accounting, Payroll, and Treasury departments.
• Assist the Controller and CFO with settling investment purchases, coordinate with financial institutions and confirm trade confirmations.
• Maintain investment purchases, maturities, interest payments, fees, and dividends in the Treasury Desktop database and investment spreadsheet according to monthly statements, investment activity, and trade tickets.
• Assist with reviewing quarterly investment reports to ensure reporting accuracy to the Board of Trustees.
• Review the investment spreadsheet at the end of each fiscal year and prepare end-of-year journal entries.
• Complete monthly financial reporting requirements including monthly cash balance, recording interest and other assigned banking transactions for bank accounts and investment pools in journal entries on the general ledger, collect and file bank statements, investment pool statements, and fiduciary fund statements, and reconcile voided checks with the accounting department.
• Assist in preparing and completing annual audit requests for Financial Services & Treasury Services.
• Fund scholarship payments annually according to board-approved scholarship awards.
• Update and maintain pool authorizations and depository information according to changes in district personnel and banking institutions.
• Assist Treasury Specialist with coordinating Varsity Football season to include but not limited to: ticket orders, staffing, scheduling couriers, event manager/supervisor.
• Track and reconcile ticket sales and prepare weekly reports for sporting event ticket sales.
• Reconcile General Ledger receivable accounts monthly; to include research and journal entries, if required.
• Research discrepancies within the scope of the department to include invoicing, credit card receipts, tickets sales and inventory.
• Prepare and processes monthly sales tax reports from campus reports to state comptroller.
• Performs other such tasks that may be assigned by the Director of Financial Services.

This job has no supervisory responsibilities.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Education and/or Experience:

• Must have intermediate knowledge of excel to include pivot tables.
• Bachelor's degree in a business field; two or more years of working in a business office processing payments or reconciling accounts preferred OR two or more years' experience working in a Texas Public School District Business Services Department along with TASBO certification (Accounting/Finance Specialization required for CTSBS or CTSBO) may substitute for Bachelor's degree OR two or more years' experience working in a Texas Public School District Business Services Department along with 60 semester hours of college credit

Language Skills:

• Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
• Ability to write reports, business correspondence, and procedure manuals.
• Ability to effectively present information and respond to questions from members of the board of trustees, administrators, staff, auditors, and the general public.

Mathematical Skills:

• Ability to work with mathematical concepts such as probability and statistical inference.
• Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.

Other Skills and Abilities:

• Must be able to operate an IBM-compatible computer.
• Must be familiar with word processing, spreadsheets, e-mail, and the internet.

Reasoning Ability:

• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.

Physical Demands:

• While performing the duties of this job, the employee is frequently required to stand, kneel, squat, bend, stoop, push, pull, and twist.
• The employee must occasionally lift or carry (less than 15 pounds).
• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.
• Requires considerable close up work with computer video displays.

Work Environment:

• Occasional district-wide travel to multiple campuses as assigned.
• The noise level in the work environment is usually quiet/moderate.

Prepared By: Sheila Ham, Director of Financial Services Prepared Date: June 11, 2024 The foregoing statements describe the general purpose and responsibilities assigned to this job. and are not an exhaustive list of all responsibilities, duties and skills that may be required.