24-87 - Debt & Portfolio Management Analyst (Financial Analyst IV)

Only applicants who apply with a State of Texas application via the CAPPS online application system will be considered for this position. First time applicants will need to create an account https://tinyurl.com/CAPPS-Login in the CAPPS online application system at https://tinyurl.com/CAPPS-Jobs. Please visit our job opportunities page at https://tinyurl.com/How-to-Apply-in-CAPPS for more information about the Texas Water Development Board and answers to frequently asked questions. To view this position in greater detail, visit the CAPPS online application system. 

Texas Water Development Board’s Mission 

     Leading the state’s efforts in ensuring a secure water future for Texas. 

The Texas Water Development Board (TWDB) endorses telecommuting and hybrid workplace plans, in addition to other flexible work alternatives. We offer competitive compensation and benefits package including medical, dental, vision, 401(k), flexible spending, and flexible work hours so you can have a work/life balance! For more information about our employee benefits and more, visit http://www.twdb.texas.gov/jobs/benefits.asp.

The Texas Water Development Board does not discriminate on basis of race, color, national origin, sex, religion, sexual orientation, age, or disability in employment or provision of services, programs, or activities. 

***Salary commensurate with experience and qualifications***

Job Description Summary

Performs highly advanced (senior-level) financial analysis and regulatory work. Work involves compiling, reviewing, analyzing and evaluating complex financial data. Preparing detailed reports and responding to inquiries made by municipal financial professionals and recommending appropriate action to resolve financial and regulatory problems. Provides financial analysis of the TWDB debt and loan portfolios including cash flows, capacity models, prepayment analysis, bond issuance, bond redemptions, lending rates and cash balances. Coordinates with external advisors on the sizing, timing, and scheduling of bond transactions. Assists in the preparation of board items for bond transactions, defeasance activities, and other debt-related matters. Assists in the preparation of annual continuing disclosure and other disclosure filings. May train others. Works under minimal supervision, with extensive latitude for the use of initiative and independent judgment. Reports to the Director of the Debt and Portfolio Management Division.

Essential Job Functions

• Serves in consulting role in the development and sale of general obligation and revenue bonds for various programs, providing project management and content development as needed for an issuance from pre-planning stages through closing. 
• Collects financial information from loan and cash investment portfolios and historical financial databases. 
• Aggregates reports and performs analysis related to all program modeling, including cash flow modeling, capacity modeling, municipal bond sizing, and long-term forecasting and projections. 
• Performs database research and forecasts financial impact to loan programs from potential federal and state legislation or other program changes. 
• Monitors the specific use of funds for each program according to bond resolutions, state or federal law, and/or any other appropriate rules and regulations, which may include analysis of tax impact of the use of bond proceeds and participation in team processes such as the End of Month transfers. 
• Assists in setting of lending rates for loan programs, which may include coordination and board approval of SWIFT or Development Fund program lending rates, and routine lending and market rate estimates for SRF and GO programs, among others. 
• Prepares periodic financial reports for municipal bond rating agencies, federal disclosure requirements, and other on-going reporting requirements. 
• May function as a consultant in the financial aspects of program planning, including writing detailed legislative bill analyses for proposed legislation. 
• Maintains confidential and sensitive information. 
• Ensures individual and team files (electronic and hard versions) are appropriately maintained and timely disposed of in accordance with the agency’s records retention procedures and schedule.
• Maintains required certifications and licenses and meets the continuing education needs and requirements of the position to include, attending mandatory training resources.
• Maybe require to operate a state or personal vehicle for business purposes.
• Performs other duties as assigned

Minimum Qualifications

• Graduation from an accredited four-year college or university with major coursework in Accounting, Business Administration, Finance, Economics, or related field. 
• Five years of experience in institutional investment research, accounting, financial analysis, statistical analysis or related experience. 
• Relevant experience and education may be substituted on a year-for-year basis.

Preferred Qualifications

• Postgraduate degree with a specialization in Accounting, Finance, Public Administration, Public Finance, Computer Science or Math. 
• Three years of experience as a financial, investment or other quantitative analyst. 
• Experience issuing and/or analyzing municipal bonds. 
• Experience with Excel, including querying from databases, crafting reports, and using complex nested formulas. 
• Experience with managing loan portfolios. 
• Experience writing detailed issue memos, reports, or business proposals. 
• Experience parsing and summarizing contracts, statutes or governmental rules.
• Professional certification(s) such as the CPA, CMA, CIA, CTP, CFA, FRM, or PRM.

Knowledge, Skills, and Abilities (KSAs)

• Knowledge of local, state, and federal laws and regulations relevant to the Debt and Portfolio Management Division.
• Knowledge of the principles and practices of public administration. 
• Knowledge of financial analysis and examination procedures for regulated entities, of financial and industry terminology and practices.
• Knowledge of statistical analysis, including analyzing bond transactions, associated costs, and debt service. 
• Skills in using Microsoft Office programs such as Word, Excel, and PowerBI. 
• Skills in use of internet, email, word processing, spreadsheet, presentation, and database software. 
• Skills in the use of a computer and applicable software and in data modeling. 
• Ability to adhere to work schedules, follow procedures with respect to leave and submit accurate timesheets by prescribed deadlines. 
• Ability to make mature, objective decisions and identify areas of potential problems.
• Ability to perform effectively and willingly when changes occur in scope and nature of the work and work environment. 
• Ability to perform routine and non-routine work assignments accurately and on-time with little or no supervision. 
• Ability to perform assigned duties and improve work habits and/or output. 
• Ability to complete assigned work, on time, neatly and with infrequent errors.
• Ability to interpret policies, procedures, and regulations. 
• Ability to provide prompt, courteous and accurate assistance and clear and concise communication to internal and external stakeholders both verbally and in writing. 
• Ability to work and cooperate with others in a team environment.
• Ability to manage multiple tasks. 
• Ability to stand/sit/move to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
• Ability and willingness to travel 5% of the time, primarily within the State of Texas. 
• Ability to operate a vehicle (state or personal) for state business and maintain a driver’s license and driving record that complies with state and agency requirements. 
• Ability to work days that may exceed 8 hours, including early mornings, nights, and weekends.
• Ability to train others.
• Ability to administer financial processes and systems. 
• Ability to perform and interpret numerical analyses. 
• Ability to interpret statutes. 
• Ability to analyze, evaluation, and summarize financial and management records for accuracy and conformance to procedures, rules and regulations.
• Ability to prepare reports and correspondence regarding findings.