Analyst II, Treasury Tax and Debt

Lone Star College; Shenandoah (TX); On-site; USD 59,000 - 67,000; Full time

Job summary

Lone Star College is seeking an Analyst II, Treasury - Tax and Debt to support financial planning by collecting, validating, and analyzing property tax data and ensuring accurate revenue estimates. The role also monitors debt obligations, including bond balances and debt service payments, and contributes to regulatory reporting.

You will collaborate with external entities and internal departments to meet team objectives and ensure compliance with controls and audit requirements.

Qualifications

• Bachelor's degree and at least 3 years of related experience.
• Strong data entry and validation skills.
• Proficiency with Excel, Word, Outlook.
• Ability to manage multiple tasks and meet deadlines.

Responsibilities

• Performs data collection, validation, and analysis of property tax data; maintains data integrity and reconciles datasets.
• Maintains and updates analytical spreadsheets and supporting documentation for tax revenue forecasting.
• Consolidates and analyzes property tax data to support revenue forecasts and projections; prepares analytical schedules.
• Prepares, reviews, and processes debt service payments; validates transactions and maintains supporting documentation.
• Executes monthly bond-related accruals and performs reconciliations during month-end closing; investigates variances.

Skills

Data entry

Data validation

Analytical skills

Organization

Multi-tasking

Office software

Procedural compliance

Team collaboration

Education

Bachelor's degree

3+ years experience

Tools

Excel

Word

Outlook

Job description

Commitment to Mission

This job carries with it the obligation to uphold the Mission ofLone Star College (LSC) in carrying out the duties of the position.A commitment to positive interpersonal behaviors, professionalcommunication, integrity, leadership, stewardship, respect andaccountability to LSC students and employees is essential.

Cultural Beliefs

• One LSC
• Student Focused
• Own It
• Foster Belonging
• Cultivate Community
• Choose Learning

The Chronicle of Higher Education's "Great Colleges to Work For" isdesigned to recognize colleges that have been successful increating great workplaces and to further research and understandingof the factors, dynamics and influences that have the most impacton organizational culture at higher education institutions.

Lone Star College has been recognized in multiplecategories.

Campus Marketing Statement

Lone Star College-System Office

Lone Star College offers high-quality, low-cost academic transferand career training education to 80,000+ students each semester.LSC has been named a 2023 Great Colleges to Work For institution bythe Chronicle of Higher Education.

LSC consists of eight colleges, seven centers, eight WorkforceCenters of Excellence and Lone Star Corporate College.

Lone Star College-System Office employees are based at one of twoSystem Office locations; The Woodlands and University Park. Bothare the site for multiple administrative departments andsystem-wide training programs.

Location address is 5000 Research Forest Drive, The Woodlands, TX77381.

Job Description

PURPOSE AND SCOPE:

The Analyst II, Treasury - Tax and Debt supports financial planningby collecting, validating, and analyzing property tax data toensure accurate and supportable revenue estimates. The Analystcontributes to the development of property tax revenue projectionsby compiling data, maintaining analytical models and spreadsheets,and assisting in variance analysis.

The role also monitors outstanding debt obligations, includingtracking bond balances and verification of scheduled debt servicepayments. The Analyst supports financial analysis, compliance, andreporting requirements by compiling detailed and accuratedocumentation and assisting with required financial reports andschedules.

ESSENTIAL JOB FUNCTIONS:

1. Performs data collection, entry, validation, analysis, andongoing maintenance of property tax datasets sourced from countytax offices, appraisal districts, and related entities; ensuresdata integrity, accuracy, completeness, and integrity throughsystematic review and reconciliation processes
2. Maintains and updates analytical spreadsheets and supportingdocumentation used in tax revenue forecasting and modeling;supports the preparation and compilation of Truth-in-Taxation (TNT)materials and related reporting deliverables, ensuring dataaccuracy and documentation integrity in coordination with seniorstaff
3. Consolidates and analyzes property tax data from county taxoffices and appraisal districts to support the preparation ofrevenue forecasts and projections; prepares and maintainsanalytical schedules used in the financial analysis and budgetingand performs data validation
4. Compiles, standardizes, and analyzes property tax data fromcounty tax offices and appraisal districts to support thedevelopment of revenue estimates and projections; assists inpreparing analytical schedules and supporting documentation forfinancial analysis and budget development
5. Prepares, reviews, and processes debt service paymenttransactions within the Deal Management module (PeopleSoft);performs detailed validation and reconciliations to confirmaccuracy and completeness; maintains comprehensive supportingdocumentation to ensure compliance with internal controls
6. Executes and analyzes monthly bond-related accruals as part ofthe month-end closing process; validates accuracy and completenessthrough detailed reconciliations to supporting schedules andgeneral ledger balances, and investigates variances to ensurefinancial integrity and compliance
7. Provides cross-functional analytical support within thedepartment and regularly communicates with a variety of externalentities (such as Financial Advisors, Appraisal District, ArbitrageConsultants, State Comptroller, Tax Assessors/Collectors, etc.) toexecute deliverables to meet team objectives
8. Supports regulatory compliance and financial reportingrequirements by aggregating, validating, and analyzing data;contributes to the preparation of annual audit schedules and theAnnual Comprehensive Financial Report (ACFR) including datareconciliation, and documentation to ensure accuracy andcompleteness with reporting standards
9. Processes and monitors appraisal district quarterly assessmentpayments, property tax remittances, paying agent fees, and otherrelated disbursements; verifies accuracy, ensures timely execution,and maintains supporting documentation for reconciliation and auditpurposes
10. Responsible for other reasonable, related duties asassigned

KNOWLEDGE, SKILLS, AND ABILITIES:

• Accurate data entry and data validation skills with strongattention to detail
• Ability to organize and reconcile financial data
• Strong analytical and problem-solving skills
• Ability to manage multiple concurrent tasks and meetdeadlines
• Proficiency with standard office software (Excel, Word,Outlook, etc.)
• Ability to follow detailed instructions and standardizedprocedures
• Ability to work collaboratively with the team, internaldepartments, and external agencies

PHYSICAL ABILITIES:

The work is sedentary. Typically, the employee sits comfortably todo the work. However, there may be some walking; standing; bending;carrying of light items, such as papers, books, or small parts; ordriving an automobile. No special physical demands are required toperform the work.

WORK SCHEDULE AND CONDITIONS:

• Equipment used includes, PC workstation running on a LAN in aMicrosoft Windows environment, calculator, phone, and other generaloffice equipment
• Interface with internal and external contacts as needed tocarry out the functions of the position
• Work is performed in a climate-controlled office with minimalexposure to safety hazards

REQUIRED QUALIFICATIONS:

• Bachelor's degree and at least 3 years of experience, or anequivalent combination of education and experience

Salary

Hiring salary range is: $58,625 - $67,419

Lone Star College provides a hiring salary range for all postedfull-time non-faculty positions. Where your salary offer would fallin that range is determined by your related experience andeducation. Should you receive an offer of employment from Lone StarCollege, the resume submitted in the application process will beutilized to calculate your salary offer. The information outlinedbelow will provide the Office of Human Resources everything neededto determine an accurate starting salary.

Your resume should provide a complete picture of your workexperience. The resume should include the following information foreach position listed:

1. Length of time (specific months and years) of employment
2. If the position was full time or part time
3. If the position was paid or unpaid
4. Level of degree completed including date earned.
5. Unofficial transcript for highest earned degree

Additionally, any certifications listed as required or preferred inthe Lone Star College job description should be included in the resume submitted.

Benefits Marketing Statement

By joining our top-notch institution, you will enjoy being a partof an organization that offers a supportive, collegial workenvironment and excellent work/life balance. This includes a fullcomprehensive and competitive benefits package, a generous numberof paid holidays and vacation days, wellness programs, tuitionwaiver, professional development opportunities and more.

Lone Star College participates in the E-Verify program, under whichLone Star College provides the federal government with informationfrom each new employee's Form I-9 to confirm that the employee isauthorized to work in the United States.

Lone Star College is an EEO Employer. All positions aresubject to a criminal background check.