Analytics Solution Specialist I

Reposted 9 Days Ago
Be an Early Applicant
Lake Forest, IL
In-Office
72K-103K Annually
Mid level
Insurance
The Role
The role involves creating data solutions, developing dashboards in Power BI, analyzing data from Azure, and communicating findings to stakeholders.
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

The ideal candidate will have experience writing SQL queries within modern cloud‑based platforms or traditional databases such as Microsoft SQL Server. Candidates should be proficient in developing data visualization dashboards using tools including Tableau, Power BI, Looker, and Qlik. This role requires strong documentation skills to create data mapping documents, write clear calculation logic descriptions, and develop technical diagrams to support the development process. Valuable skills for Trustmark’s technology stack include experience with Microsoft Azure, Databricks, Python, and Power BI.

Responsible for understanding business needs to iteratively create solutions which can be used by a broad audience. Engages in best practice use and development for data visualizations and data stories. Uses data to drive process improvements and improve customer experience.

Key Accountabilities

  • Query and analyze data from Microsoft Azure cloud platform using Databricks.

  • Model tables to be consumed by Power BI dashboards using Star Schema architecture.

  • Develop dashboards in Power BI to support data-driven decision-making.

  • Communicate findings effectively to technical and non-technical stakeholders.

  • Maintain clear and thorough documentation of data models, code, and projects.

Minimum Requirements

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

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

$71,520.40 - $103,307.70 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
Azure
Power BI
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

Magna International Logo Magna International

Eng, Quality

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Nashville, IL, USA
171000 Employees
78K-85K Annually

MetLife Logo MetLife

Account Manager

Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Hybrid
Chicago, IL, USA
43000 Employees
85K-115K Annually
Hybrid
Chicago, IL, USA
1249 Employees
91K-143K Annually

Cox Enterprises Logo Cox Enterprises

Client Trainer II (Fixed Ops)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Hybrid
Chicago, IL, USA
50000 Employees
56K-83K Annually

Similar Companies Hiring

Globe Life Thumbnail
Insurance • Financial Services
McKinney, TX
3000 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