Financial Analyst II

Position Overview

Assist the HBS Financial Administrator with underwriting and rate-setting analysis and activities for the Texas Association of Counties (TAC) Health and Employee Benefits Pool (Pool). Assist the Financial Administrator with reporting and analysis of the Pool’s health and benefit plans, the Pool’s annual renewal activities and administrative services only (ASO) group renewals. Assist HBS staff with financial analysis, renewal rate calculations, alternate rate calculations, wellness incentive cost impact analysis and benefit plan performance reviews. Assist with the production of responses to Requests for Proposals (RFPs) and Requests for Quotes (RFQs). Responsible for planning and developing other employee benefit program elements as directed by the department director and Financial Administrator. Some travel required. Residence in Texas is required.

Essential Job Functions

• Conduct underwriting functions such as rate modeling, risk assessment, claims evaluation, and renewal analysis.
• Assist the Financial Administrator with the development and maintenance of dynamic dashboards and reports for performance tracking.
• Independently coordinate with actuaries and underwriters on Pool strategy, cost projections, and budget impacts.
• Provide analytical insight to leadership including claim analyses, plan design evaluations, and changes in market trends.
• Develop and present complex financial materials to internal and external stakeholders.
• Compile and review data for responses to RFPs and RFQs.
• Monitor employee benefits markets and summarize identified trends.
• Perform other duties as assigned.

Non-essential Job Functions

Experience / Education Requirements

• Bachelor’s degree in finance, math, business administration, or related field required; emphasis in health insurance or a related field preferred but not required.
• Two or more years of experience performing financial analysis and financial reporting in a professional environment.
• Preferred experience in health insurance underwriting, actuarial services, or account management of a self insured group.
• Demonstrated ability to perform advanced analysis independently.
• Cannot have any form of employment corrective action within the last 12 months (Internal Applicants).

Knowledge, Skills and Abilities

• Must demonstrate strong analytical and quantitative skills, with the ability to interpret complex technical data and translate insights into actionable recommendations to various stakeholders.
• Position requires a high degree of professionalism in representing TAC and the Pool in significant contacts with elected officials, public employees, and members.
• Position requires a high degree of confidentiality and compliance with state and federal privacy laws and regulations.
• Must demonstrate knowledge of employee benefits programs, including underwriting, contract issuance, claims handling, and cost containment.
• Must be proficient in the use of personal computers and Microsoft Office products including Word and PowerPoint.
• Advanced proficiency in Excel, including deep knowledge of pivot tables, macros and complex formulas strongly preferred.
• Knowledge of additional data analytics tools such as Power BI preferred.
• Must function independently with minimal supervision.
• Excellent time management and record keeping required.
• Valid Texas driver’s license and good driving record required; must be able to drive.
• Residence in Texas required.

Supervisory Detail

• Supervision Exercised: No supervisory responsibility.
• Supervision Received: Supervision by procedures or by supervisor through periodic monitoring of progress and performance. Determines sequence of own work tasks to meet established objectives.

Working Conditions

• Location: Remote, TAC Building, Austin, TX
• Teleworking Agreement Available: Yes
• Required to work weekends, nights or be on call: Rarely
• Travel Requirement: Occasionally
• Keyboarding: Always; Right and Left
• Filing: Occasionally
• Operation of a computer mouse with their dominant hand: Always

Physical Requirements

1. Sitting Always

2. Standing Sometimes

3. Walking Never

4. Speaking Sometimes

5. Hearing Sometimes

6. Squatting Never

7. Bending Never

8. Reaching Occasionally

9. Twisting Never

10. Crawling Never

11. Climbing Never

12. Driving a motor vehicle Never

13. Walking on rough ground Never

14. Exposure to changes of temperature/humidity Never

15. Exposure to dust/fumes/gases/chemicals Never

16. Being near moving machinery Never

17. Working from heights Never

This position requires

Occasionally lifting and/or carrying 11-24 pounds

LIMITATIONS AND DISCLAIMER

*The above job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position.*