Data Analyst

Sedgwick
Salt Lake City, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 80K

Job location

Salt Lake City, United States of America

Tech stack

Data analysis
Data Integrity
Data Transformation
Python
Microsoft Office
Performance Tuning
Power BI
SQL Databases
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Snowflake
Custom Reports

Job description

The Data Analyst will support business and operational decision-making by transforming complex data into actionable insights. This role will partner closely with business stakeholders, IT, and analytics leadership to deliver high-quality reporting, dashboards, and advanced analysis across the Casualty and Managed Care business unit. The ideal candidate has strong hands-on experience with Snowflake, SQL, Python, Hex, and Power BI, and is comfortable working in a modern cloud analytics environment.

ARE YOU AN IDEAL CANDIDATE? We are looking for enthusiastic candidates who thrive in a collaborative environment, who are driven to deliver great work.

ESSENTIAL FUNCTIONS and RESPONSIBILITIES ?

  • Design, develop, and maintain analytical datasets in Snowflake , ensuring data accuracy, performance, and usability for reporting and analysis.
  • Write complex SQL queries and develop Python scripts for data transformation, validation, automation, and advanced analysis.
  • Build and maintain interactive dashboards and reports using Power BI , delivering insights aligned to business and operational goals.
  • Use Hex for exploratory analysis, reproducible analytics workflows, and collaboration across analytics and business teams.
  • Partner with business stakeholders to understand reporting needs, translate requirements into technical solutions, and clearly communicate findings.
  • Ensures data integrity; develops and produces reports utilized in measuring data accuracy.
  • May assist in the completion of appropriate client set-up and maintenance (parameter) forms.
  • Supports internal and external users including reports, installation, screen, etc.
  • Creates exception reports to identify fields of incorrect data.
  • Generates custom reports for internal and external client.

ADDITIONAL FUNCTIONS and RESPONSIBILITIES

  • Performs other duties as assigned.
  • Supports the organization's quality program(s).

Requirements

Strong hands-on experience with:

  • Snowflake (data modeling, performance tuning, and analytics use cases)
  • SQL (advanced querying and transformations)
  • Python (data analysis, automation, and scripting)
  • Power BI (dashboard development and data modeling)
  • Hex (or similar modern analytics/notebook platforms)

Education & Licensing

Bachelor's degree from an accredited college or university preferred.

Experience

Five (5) years of related experience or equivalent combination of education and experience required. Two (2) years of query and report writing experience strongly preferred.

Skills & Knowledge

  • Strong knowledge of query and report writing
  • Excellent oral and written communication, including presentation skills
  • PC literate, including Microsoft Office products
  • Analytical and interpretive skills
  • Strong organizational skills
  • Excellent interpersonal skills
  • Excellent negotiation skills
  • Ability to meet or exceed Performance Competencies

Benefits & conditions

TAKING CARE OF YOU BY

  • We offer a diverse and comprehensive benefits package including:
  • Three Medical, and two dental plans to choose from.
  • Tuition reimbursement eligible.
  • 401K plan that matches 50% on every $ you put in up to the first 6% you save.
  • 4 weeks PTO your first full year., As required by law, Sedgwick provides a reasonable range of compensation for roles that may be hired in jurisdictions requiring pay transparency in job postings. Actual compensation is influenced by a wide range of factors including but not limited to skill set, level of experience, and cost of specific location. For the jurisdiction noted in this job posting only, the range of starting pay for this role is $60,000 - $80,000. A comprehensive benefits package is offered including but not limited to, medical, dental, vision, 401k and matching, PTO, disability and life insurance, employee assistance, flexible spending or health savings account, and other additional voluntary benefits.

About the company

By joining Sedgwick, you'll be part of something truly meaningful. It's what our 33,000 colleagues do every day for people around the world who are facing the unexpected. We invite you to grow your career with us, experience our caring culture, and enjoy work-life balance. Here, there's no limit to what you can achieve. Newsweek Recognizes Sedgwick as America's Greatest Workplaces National Top Companies Certified as a Great Place to Work Fortune Best Workplaces in Financial Services & Insurance, Sedgwick is the world's leading risk and claims administration partner, which helps clients thrive by navigating the unexpected. The company's expertise, combined with the most advanced AI-enabled technology available, sets the standard for solutions in claims administration, loss adjusting, benefits administration, and product recall. With over 33,000 colleagues and 10,000 clients across 80 countries, Sedgwick provides unmatched perspective, caring that counts, and solutions for the rapidly changing and complex risk landscape. For more, see sedgwick.com

Apply for this position