Data Analyst
Sedgwick Claims Management Services
IT, Data Science
Washington, DC, USA
USD 60k-80k / year
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
Data AnalystPRIMARY PURPOSE:
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).
QUALIFICATIONS
- 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
WORK ENVIRONMENT
When applicable and appropriate, consideration will be given to reasonable accommodations.
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.
NEXT STEPS
If your application is selected to advance to the next round, a recruiter will be in touch.
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.
The statements contained in this document are intended to describe the general nature and level of work being performed by a colleague assigned to this description. They are not intended to constitute a comprehensive list of functions, duties, or local variances. Management retains the discretion to add or to change the duties of the position at any time.
Sedgwick is an Equal Opportunity Employer and a Drug-Free Workplace.