PRT Operations - Data Analyst, PRT
Job Description
ESSENTIAL FUNCTIONS:
Client Onboarding
Support client onboarding activities that involve leading calls with plan sponsors/brokers/TPA; confirm onboarding data questions; review test confirm reports from payment payroll; execution of User Acceptance Testing and production data validation; review of welcome kits test cases and web portal test cases; and peer review of onboarding files by other team member(s)
Monthly Payroll
Support payroll activities through variance analysis and reconciliation of monthly payroll reports and preparation of reconciliation reports for pension plan sponsors / administrators, reinsurers and other insurers
Annuity Administration
Assist with ongoing annuity administration such as investigation and resolution of claims related queries from plan sponsors, administrators, reinsurers and/or other insurers, validation of monthly reports, delivery of ad-hoc requests for member data and/or reports and support of ongoing data related initiatives, i.e., life audits, review of tax slips etc.
ADDITIONAL RESPONSIBILITIES:
Collaborate with other functions and departments, including actuarial, investments, risk, finance, and compliance on each winning bid
Collaborate with management and/or cross functional teams on data related projects to help maintain or develop new reporting solutions that will help enable business decisions and/or support operational efficiencies
Apply appropriate data engineering techniques and processes to optimize data flows and consumption
Maintain monthly and year over year dashboards to assist with reporting to senior management
Utilize data visualization tools and techniques for more impactful reporting
Apply data quality methodology, i.e., completeness and accuracy to drive an exceptional onboarding experience for our clients
Operate within defined data governance framework
Effectively communicate complex data findings in a clear & concise manner to multi-disciplined teams
Assist with the maintenance of the Operations team’s playbook for ease of training and knowledge transfer to team members
Assist with training new team members as required
REQUIRED QUALIFICATIONS:
Bachelor's degree.
Two to four years of experience with data analysis and interfacing with clients.
Additional Qualifications:
Experience using MS Office (Word, PowerPoint, and Outlook) and advanced knowledge of Excel in particular
Project planning and project management skills are ideal
Experience with data visualization tools
Strong oral and written communication skills
Ability to multi-task and perform well under pressure
Strong attention to detail and accuracy
Quick to learn new skills and applications
Flexible and willing to take on a variety of tasks
Strong team player that is motivated and resourceful to work as part of a small and dedicated team
PREFERRED QUALIFICATIONS:
Degree in Business Administration, Actuarial Science, Statistics, Mathematics, Finance, Data Science or equivalent preferred
Knowledge of group annuities/pensions is highly desirable
Prior experience working with retirement plans and/or defined contribution plans.
Experience with business intelligence software (e.g., Power BI), and/or PowerApps a plus
Career Band: P3A
Additional Information
Job titles may span multiple career levels. Base pay is determined by a variety of factors, including training, transferable skills, relevant experience, business needs, and market conditions. Compensation is subject to change and may be modified in the future.
This job posting outlines the general nature and level of work for this role and is not intended to be a comprehensive list of duties, responsibilities, or qualifications. We are committed to building a diverse and inclusive workplace, and we encourage candidates to apply even if their experience does not perfectly align with every qualification- you may be a strong fit for this role or other opportunities at American National.
American National offers a comprehensive benefits package supporting employees’ health, financial security, and well being, including multiple medical plan options, dental and vision coverage, basic life insurance, and health savings accounts. Employees are automatically enrolled in a company funded 401(k) plan, receive paid time off and holidays, and work in an inclusive, people first culture that values flexibility, work life balance, professional growth, and a casual dress environment.
American National is a financially strong and stable insurance organization with a legacy of trust and impact dating back to 1905. We’re committed to supporting our employees as they build meaningful careers while helping protect what matters most to our customers and communities.
