Investment & Treasury Accountant

City of McKinney•Tx 75069, TX

2d•Onsite

About The Position

Working for the City of McKinney is more than a job. It is an opportunity to make a meaningful difference in the lives of others. It is also an opportunity to have a hand in the development of one of the fastest growing communities in the nation. In 2014, our community was named “The #1 Best Place to Live in America.” Although proud of that honor, everyone on our team is committed to making McKinney an even better place to live, work and raise a family. That’s why we exist. City of McKinney employees work hard and at a very fast pace. However, we also look after and support one another. All of us are guided by four employee-inspired values – Respect, Integrity, Service, and Excellence (RISE). We are also supported by servant-based leaders who foster and support a healthy, family-oriented culture. All new employees are expected to embrace and live by our core values and commit to helping us sustain our exceptional work environment as a high performance organization (HPO). 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.

Requirements

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, ACFRs, 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.
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.

Nice To Haves

Local government experience preferred.

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.