Financial System Analyst (Hybrid)

Trustmark’s mission is to improve wellbeing – for everyone. It is a mission grounded in a belief in equality and born from our caring culture. It is a culture we can only realize by building trust. Trust established by ensuring associates feel respected, valued and heard. At Trustmark, you’ll work collaboratively to transform lives and help people, communities and businesses thrive. Flourish in a culture of diversity and inclusion where appreciation, mutual respect and trust are constants, not just for our customers but for ourselves. At Trustmark, we have a commitment to welcoming people, no matter their background, identity or experience, to a workplace where they feel safe being their whole, authentic selves. A workplace made up of diverse, empowered individuals that allows ideas to thrive and enables us to bring the best to our colleagues, clients and communities.

About the role

Seeking a dynamic Financial Systems Analyst to join our team at Trustmark.

Responsible for overseeing, from a financial perspective, the third-party administrator (TPA) processing of group benefits receipts and disbursements both on a timely and accurate basis. Performs the system reconciliation on a monthly, quarterly, and annual basis. Collaborates with processing team on manual money movement and journal entries. Assists Financial Reporting during quarterly and year end reporting. Drives and performs system/procedural enhancement testing (Workday).

Key Accountabilities:

Oversee CBS (Mequon) Suspense Account

• Analyze/research reconciling items and follow-up with Operations on open items.
• Significant interaction with the Operations, Bank Reconciliation and Cash Management teams to resolve new/outstanding issues.
• Track and resolve all suspense items with Operations team.
• Ensure required applicable money movement requests and journal entries are processed in a timely fashion.
• Perform data mining in the proprietary divisional data mart to identify processing issues.
• Identify related items and clear from the Total Reconciliation system (T-Recs).
• Prepare monthly reconciliation at an employer level.
• Provide financial guidance when required.
• Review and update ICFR documents on an annual basis.
• Identify areas of process improvements and recommend solutions – both at a system and procedural level.
• Update and/or create procedural documentation.

 Financial Reporting

• Statutory Reporting - Prepare quarterly and annual statutory filings. Accountable for schedules, exhibits and Notes. Responsible for requesting organizing, compiling, and tracking information from sources throughout the company for 3-4 legal entities.
• Audited Financial Statements – Prepare and review particular consolidating financial statements, notes and supplementary schedules. Ensure data is complete and accurate, detailed documents support reports, and support received from business units and Corporate is maintained in audit binders. Review non-reconcilable information for reasonableness.
• Variance Analyses – Prepare and ensure accuracy, completeness, and clarity of quarterly and annual financial statement line-by-line analyses for noninsurance legal entities which identify significant, unusual, or unreasonable variances. Critically review responses and work with responsible parties to obtain necessary subsequent information, clarification, or make corrections.
• Surveys – Prepare annual and quarterly AMBEST, ACLI and other industry associations’ information requests and data surveys for 3-4 insurance legal entities. Ensure data requested is received from multiple sources, compiled correctly, reviewed for comparability, and reconciled back to Annual Statement financial statements, exhibits and schedules. Resolve any inconsistency or comparability issues with source contacts.
• Noninsurance Third Party Administrator filings and Other –Assist in preparing 30-40 annual filings, and research and follow up on questions received on filings. Review Intangibles to ensure asset balances agree with valuation support, accurate amortization and accumulated amortization are recorded. Perform quarterly Other Comprehensive Income reviews for noninsurance entities.

Ledger Support – additional tasks which may be assigned

• Maintain close calendar on Workday Headquarters. Coordinate and communicate updates for Finance quarterly reporting calendar.
• Assist with year-end reporting tasks/requests
• Run monthly close meetings
• Participate in project testing for business related testing impacts to Workday
• Set up/assign Account Certifications for new account/spend categories
• Set up new bank accounts in ME00 screen, add to account posting rules and mapping in Workday
• Schedul