Business Reporting Analyst

Reposted Yesterday
Lake Forest, IL, USA
In-Office
Junior
Insurance
The Role
Support national sales by producing and maintaining sales reporting and tracking tools. Gather and merge data from multiple sources to produce standard and custom reports, analyze sales trends and case participation, provide actionable findings to management, manage sales compensation and marketing invoices, and maintain lists of at-risk or terminated clients.
Summary Generated by Built In

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

Assists the National Sales staff in proposal fulfillment and general sales operation activities. Works closely with the sales, operations, and underwriting areas to gather client and company level information to help assess the effectiveness of our business. Primarily responsible for sales reporting, analysis, and updating sales management tracking tools.

Key Accountabilities

  • Responsible for updating proposal tracking system. As part of the duties for this role the individual will be responsible for reaching out to internal and external business partners to obtain and/or clarify information related to the case proposal.

  • Assist with Sales Reporting-Persistency Letters, Projected Premium Reports, and Producer Reports.

  • Produce standard and custom client and broker level reports, utilizing Salesforce, Microsoft Excel, Insights, and Word

  • Utilize various internal and external data sources to produce reports and perform custom data mining to identify information related to case participation, sales trends, and various financial information.

  • Formulate key findings and recommendations to management based on data analysis

  • Maintaining Sales Compensation contracts and special case agreements.

  • Managing RSX marketing expenses and invoices.

  • Maintaining list of at risk and terminated clients.

Minimum Requirements

  • Bachelor’s Degree, or two or more years of experience in reporting or data management.

  • Excellent analytical skills, including the ability to examine data for meaningful relationships.

  • Strong project management skills, including the ability to manage and prioritize multiple projects simultaneously while meeting deadlines.

  • Strong technical skills including the ability to merge data from various sources, summarize data, translate data into a user-friendly report, run statistical testing on the data to determine significance and relationships within the data, and data mine for necessary drill-down metrics.

  • Proficiency with Microsoft Office applications including advanced use of Microsoft Word and Excel.

  • Ability to effectively communicate in verbal and written formats, including strong presentation skills.

  • Strong interpersonal and collaboration skills.

  • Well organized to effectively plan and follow-through with any task assigned.

  • Sound judgment and ability make decisions based on knowledge and previous experience.

Preferred

  • Bachelor’s Degree or related experience.

  • Experience supporting a sales environment.

  • Experience administering CRM applications (Saleforce.com).

  • Voluntary/ Worksite and/or Group marketplace experience.

  • Tableau experience.

Brand: Trustmark

Come join a team at Trustmark that will not only utilize your current skills but will enhance them as well. Trustmark benefits include health/dental/vision, life insurance, FSA and HSA, 401(k) plan, Employee Assistant Program, Back-up Care for Children, Adults and Elders and many health and wellness initiatives. We also offer a Wellness program that enables employees to participate in health initiatives to reduce their insurance premiums.

Trustmark is committed to leveraging the talent of a diverse workforce to create great opportunities for our people and our business.  We are an equal opportunity employer, including disability and protected veteran status.

Skills Required

  • Bachelor's degree or two or more years of experience in reporting or data management
  • Excellent analytical skills, able to examine data for meaningful relationships
  • Strong project management skills; ability to manage and prioritize multiple projects and meet deadlines
  • Strong technical skills: merge data from various sources, summarize data, produce user-friendly reports, run statistical tests, and perform data mining
  • Proficiency with Microsoft Office applications, including advanced Microsoft Excel and Microsoft Word
  • Effective verbal and written communication skills, including presentation abilities
  • Strong interpersonal and collaboration skills
  • Well organized with strong follow-through and planning abilities
  • Sound judgment and ability to make decisions based on knowledge and experience
  • Experience supporting a sales environment
  • Experience administering CRM applications (Salesforce.com) and using Salesforce for reporting
  • Voluntary/Worksite and/or Group marketplace experience
  • Tableau experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Lake Forest, IL
1,457 Employees

What We Do

Trustmark is a national employee benefits company offering specialized expertise in voluntary benefits, self-funded health benefit plan design and administration, and employee health and fitness programs that drive results through human and virtual connection. Trustmark offers employers access to benefit options usually reserved for large companies, combined with the personal service you’d expect from a small company. Trustmark’s commitment to building long-term, trusted relationships helps people and businesses thrive. • Trustmark Voluntary Benefits provides valuable life, hospital, accident, disability and critical illness insurance designed to fit changing needs based on life stage or financial priorities. Trustmark helps educate employees and provides resources to help communicate the value of benefits and other important company initiatives. To learn more, visit TrustmarkVB.com. • Trustmark Health Benefits is a total benefits solution for mid-sized and large self-funded employers. As one of the nation’s largest independent benefits administrators, we help our clients manage costs without compromising care by offering innovative solutions, flexibility, and complete data transparency for our clients. To learn more, visit TrustmarkHB.com. • Trustmark Small Business Benefits® level-funded solutions allow small to mid-size employers to provide affordable health benefits to employees. Available to groups with five or more employees along with simplified underwriting for 51 or more enrolled employees, our comprehensive self-funded plan designs and services help empower clients to be smarter healthcare consumers. To learn more, visit TrustmarkSB.com. • HealthFitness is a comprehensive wellbeing provider that delivers wellness, fitness and injury prevention programs. To learn more, visit Healthfitness.com.

Similar Jobs

In-Office
Campus, IL, USA
16315 Employees
80K-93K Annually

TransUnion Logo TransUnion

Vice President, Commercial Operations

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
6 Locations
13000 Employees
194K-407K Annually

SailPoint Logo SailPoint

Manager, Adversary Intelligence

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
124K-209K Annually

Superhuman Logo Superhuman

Designer

Artificial Intelligence • Information Technology • Machine Learning • Natural Language Processing • Productivity • Software • Generative AI
Remote or Hybrid
2 Locations
1500 Employees
190K-286K Annually

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 Employees
MassMutual India Thumbnail
Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana
Granted Thumbnail
Artificial Intelligence • Healthtech • Insurance • Mobile • Financial Services
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account