Data Analyst
Role details
Job location
Tech stack
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.