STATISTICAL ANALYST (Excel Report Builder)

United Actuarial Services Inc•Carmel, IN

58d•Onsite

About The Position

ABOUT UNITED ACTUARIAL SERVICES, INC. Since 1951, United Actuarial Services, Inc. (UAS) has been providing consulting and actuarial services to multiemployer funds. We are one of the few actuarial firms that focuses entirely on Taft-Hartley fringe benefit plans. We are proud of the long-term relationships we have with our clients; some have been with us for over 40 years. Our professional staff includes consultants, actuaries, research specialists & analysts, and attorneys who are experts in the employee benefits field and well acquainted with the special issues facing multiemployer benefit funds. We pride ourselves on the continuity and stability we are able to offer our clients. What We Are Looking For: Analyze now, advise next. We’re looking for an Analyst who can dig deep into data and, over time with mentorship, become a trusted client-facing expert—presenting insights, fielding questions, guiding decisions, and shaping strategy. Position Overview: We are looking for a Statistical Analyst to join our team. You will prepare a variety of actuarial health & welfare reports for clients. Assists in conducting special studies, research projects, and data analysis of clients’ financial health. This is an in-person position. Hybrid opportunities after 6-months of employment. Successful candidates generally have background in Mathematics, Statistical Analysis, Data Analysis, Benefit Reporting, Report Building, Advanced Data Entry.

Requirements

Education: Bachelor's Degree in a relatable business field preferred.
Experience: Strong mathematical background. 1-2 years work history within a mathematics, benefits, accounting, or data analysis field is preferred.
Computer Skills: Microsoft Office.
Excel proficiency is required.
Accuracy - Ability to perform work accurately and thoroughly.
Adaptability - Ability to adapt to changes in the work environment. Ability to manage competing demands and deal with frequent change, delays, or unexpected events.
Analytical Skills - Ability to use thinking and reasoning to solve a problem.
Communication, Oral & Written - Ability to communicate effectively with others in writing and using the spoken word.
Dependability - Ability to consistently be at work and on time, follow a variety of instructions. Ability to respond to management direction, takes responsibility for own actions and solicit feedback to improve performance.
Detail Oriented - Ability to pay attention to the minute details of a project or task.
Goal Oriented - Ability of the individual to act to ensure that they and others stay focused on the task objective and perform in accordance with clear expectations and goals.
Mathematical Skills - Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Possess the ability to compute ratios, percentages, and basic algebraic formulas.
Organized - Possessing the trait of being organized or following a systematic method of performing a task.
Problem Solving - Ability to identify and resolve practical problems in a timely manner. Ability to gather and analyze information skillfully.
Teamwork - Balances team and individual responsibilities; exhibits objectivity and openness to others’ views; gives and welcomes feedback; contributes to building a positive team spirit; puts success of team above own interests; possesses ability to build morale and group commitments to reach goals and objectives.
Time Management - Ability of the individual to effectively utilize available time for the completion of necessary job tasks.

Responsibilities

Collects financial, census, claims, and other related data from clients and enters it into various client specific spreadsheets; calculates plan reserve requirements and prepares flash, interim, and annual reports.
Helps prepare reports covering a wide range of topics such as benefit increases, plan design or restructure, financial flow data and comparisons.
Helps prepare requests for proposals for various plan vendors or services, and provide review support and analysis of such proposals.
Professionally communicate with clients regarding data requests. Assist clients and fund professionals with questions and problems within scope of training and experience.
Work with administrative staff to request necessary data and information of assigned projects. Ensure that the required data is usable, correct, and received in a timely fashion.
Maintain electronic files to assigned clients. Assure that files are complete, accurate, current, and well organized.
Utilize project management spreadsheets and software programs to ensure deadlines are meet.
Attend weekly team meetings and remain up to date on changes and procedures.
Perform other duties as assigned by management.