Data Analyst II

Posted 2 Days Ago
Lake Forest, IL
In-Office
63K-91K Annually
Junior
Insurance
The Role
The Data Analyst II will analyze data to support decision making, develop reports, and communicate findings, requiring SQL and Excel proficiency.
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

This role requires strong SQL skills and intermediate to advanced Excel proficiency to extract, validate, and interpret data from multiple sources. The ideal candidate will bring familiarity with Python, R, SAS, or similar tools to support deeper analytical work, as well as beginner to intermediate experience with Power BI or Tableau. Other valuable skills for Trustmark’s technology stack include Databricks, Microsoft Azure, and VS Code.

Responsible for using data to answer business questions, and quantify business problems and opportunities. Identifies and profiles good sources of data and leverages them to produce high quality, easy to digest analysis.

Key Accountabilities

  • Analyze data across a variety of business domains to answer questions, support decision making, and provide operational and analytical reporting.

  • Learn, navigate, and profile multiple data sources, including raw administrative systems, and data lakes.

  • Validate query logic and troubleshoot issues such as duplicate records, missing records, incorrect joins, and unexpected aggregation results.

  • Develop ad hoc reports and analyses based on requirements that may need clarification, iteration, and feedback from stakeholders.

  • Communicate analytical findings clearly to business stakeholders, adjusting terminology and detail level as needed to ensure comprehension. ​

Minimum Requirements

  • Bachelor’s Degree and/or 2 - 4 years of related experience OR High School Diploma or GED with 4-6 years of related experience.

The compensation range for this role is (based on the corporate location in Lake Forest, Illinois):

$62,947.30 - $90,923.65 per year

The final salary offer will be determined based on factors such as location, qualifications, experience, skill set, and other relevant factors. This position may also be eligible for bonus. We understand that compensation is an important factor when considering a new opportunity, and we strive to provide a competitive salary within the market.

Brand: Trustmark

In addition to compensation, we offer a comprehensive benefits package that includes: 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.  For questions about compensation and benefits, please speak to the Recruiter if you decide to apply and are selected for an interview.

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.

Top Skills

Databricks
Excel
Azure
Power BI
Python
R
SAS
SQL
Tableau
Vs Code
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

MongoDB Logo MongoDB

Senior Data Analyst

Big Data • Cloud • Software • Database
Easy Apply
Remote or Hybrid
United States
5550 Employees
97K-189K Annually

Outrider Logo Outrider

Data Analyst

Logistics • Robotics • Software
Easy Apply
Remote or Hybrid
USA
190 Employees

Capital One Logo Capital One

Senior Data Analyst

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
3 Locations
55000 Employees
101K-127K Annually
In-Office
3 Locations
6000 Employees
114K-156K Annually

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
1657 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana
Granted Thumbnail
Mobile • Insurance • Healthtech • Financial Services • Artificial Intelligence
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