As a key member of the Financial Services team, this position reports to the Investment and Treasury Manager. The Investment and Treasury Analyst is a resource for investment tracking, banking, debt service, special projects, accounting, research, data analysis, financial reporting, and other professional duties. Essential Functions/ Knowledge, Skills, & Abilities ESSENTIAL DUTIES AND RESPONSIBILITIES Provides analytical and professional support in various areas of the Financial Services Divisions. Assists with the Investment Reports and Annual Comprehensive Financial Report (ACFR). Inputs investment transactions and market values into portfolio tracking software, reconciles portfolio values with general ledger and prepares required portfolio reports. Maintains a cash flow and liquidity spreadsheet for the City investment portfolio and analyzes expected revenues and expenditures to ensure liquidity and funding capacity. Ensures investment reporting is in compliance with legal requirements, financial transparency standards and City policies. Reconciles all bank accounts and investment pool accounts to the general ledger. Serves as the banking liaison providing assistance on financial transactions. Serves as the liaison for credit card merchant services vendor and track departmental credit card sales data. Performs complex analysis of financial and investment data and generate corresponding reports. Participates actively in annual audit, and ACFR preparations and reporting. Assists with Investment Policy updates and prepare investment related agenda items. Establishes and maintains credibility by providing timely and accurate analysis, reports, and visual presentations. Prepares monthly journals for investments, interest and other financial activities. Reviews proposals for completeness, accuracy, and conformance with established procedures. Reviews preliminary official statements and other debt related documents to ensure completeness and accuracy. Maintains debt service schedules and ensures debt service payments are accurate and timely. Performs special projects at the request of management, to include research, analysis, and recommendations. Assists with coordination of daily work activities, inspect completed work, suggest problem resolutions, and provide training. Complies with City policies and procedures to include work schedule and attendance policies. KNOWLEDGE, SKILLS, ABILITIES, AND BEHAVIORS - Ability to embrace and embody the City’s core values of Respect, Integrity, Service, and Excellence (R. I. S. E.). Ability to communicate effectively with peers, supervisors, and people to whom service is provided Ability to produce desired work outcomes, including quality, quantity, and timeliness. Ability to plan and organize work, time, and resources, and if applicable, that of subordinates. Experience with investment reporting, controls, and legal requirements and practices. Knowledge of Generally Accepted Accounting Principles and financial reporting. Knowledge and experience working with financial and bond markets. Ability to compute premium, discount, interest, gain and loss Ability to utilize a variety of data sources to include general ledger systems, ACF - Rs, monthly financial reports, City policies, or other sources as needed. Analyze and interpret data and information while recognizing interactive effects and relationships. Ability to reconcile accounts and develop approaches/techniques to problem resolution. Intermediate Microsoft Excel skills including the ability to calculate and tabulate data. Mathematical skills that produce reliable calculations Intermediate Microsoft Office including Word and PowerPoint. High level of integrity and dependability with a strong sense of urgency and results-orientation. Ability to speak and deal tactfully with others and exhibit a willingness to share information Ability to exercise sound judgment, decisiveness, and creativity in various situations. Ability to identify and implement process improvements Strong negotiating skills and ability to assess proposals and contracts. Demonstrate a collaborative and flexible style, especially during times of change. Effective communicator with strong oral and written skills. Ability to work under time pressures and problem solve. Skill in the operation of standard office equipment. Required Qualifications MINIMUM QUALIFICATIONS - Bachelor’s Degree in Accounting, Finance, Business or Public Administration, or closely related field. Successful candidates should possess three (3) years of responsible experience in investment, treasury, financial or accounting administration. Must be able to pass a background check and drug screen. Any work related experience resulting in acceptable proficiency levels in the above Minimum Qualifications may be an acceptable substitute for the above specified education and experience requirements. PREFERRED QUALIFICATIONS - Local government experience preferred. CONDITIONS OF EMPLOYMENT - Must pass a drug screen and background check. Must have a valid Texas Driver’s License. Physical Demands/ Supplemental PHYSICAL DEMANDS - Tasks involve the ability to exert light physical effort in sedentary to light work, but which may involve some lifting, carrying, pushing and/or pulling of objects and materials of light weight (5-10 pounds). Tasks may involve extended periods of time at a keyboard or work station. Some tasks require visual and sound perception and discrimination and oral communications ability. WORK ENVIRONMENT - There is limited exposure to environmental conditions.