Taking care of people is at the heart of everything we do, and we start by taking care of you, our valued colleague. A career at Sedgwick means experiencing our culture of caring. It means having flexibility and time for all the things that are important to you. It’s an opportunity to do something meaningful, each and every day. It’s having support for your mental, physical, financial and professional needs. It means sharpening your skills and growing your career. And it means working in an environment that celebrates diversity and is fair and inclusive.

　　A career at Sedgwick is where passion meets purpose to make a positive impact on the world through the people and organizations we serve. If you are someone who is driven to make a difference, who enjoys a challenge and above all, if you’re someone who cares, there’s a place for you here. Join us and contribute to Sedgwick being a great place to work.

　　Great Place to Work®

　　Most Loved Workplace®

　　Forbes Best-in-State Employer

　　Data Analyst

　　PRIMARY PURPOSE To collect, analyze and report data; to be responsible for the data integrity; and to generate reports verifying and ensuring data integrity and accuracy.

　　ESSENTIAL FUNCTIONS and RESPONSIBILITIES

　　Month end financial data extracted, integration sheet & reports created, data validated, reports formatted, & submitted to finance

　　Month end invoices created and validated against integration sheet

　　Client AR reconciliations, identifying bills not paid, generating reports to be sent to client for a response

　　Processing bills not paid responses and bill delete reports; applying these credits to bills system

　　Researching data and cash application questions from finance

　　Applying monthly client payments to bills system and generating affiliate AP data sheet and reports

　　Preparing, creating, & submitting monthly affiliate AP data sheet and PDF Summary reports to AP for payment

　　Emailing monthly PDF summary and Excel detail reports to each affiliate

　　Researching and processing affiliate requests related to payments

　　Compiles data; prepares and distributes reports; and analyzes results.

　　ADDITIONAL FUNCTIONS and RESPONSIBILITIES

　　Performs other duties as assigned.

　　Supports the organization's quality program(s).

　　QUALIFICATIONS

　　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.

　　Skills & Knowledge

　　Excellent oral and written communication, including presentation skills

　　PC literate, proficient in Microsoft Office products (Excel critical)

　　Analytical and interpretive skills

　　Strong organizational skills

　　Excellent interpersonal skills

　　Ability to meet or exceed Performance Competencies

　　WORK ENVIRONMENT

　　When applicable and appropriate, consideration will be given to reasonable accommodations.

　　Mental : Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion; ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines

　　Physical : Computer keyboarding, travel as required

　　Auditory/Visual : Hearing, vision and talking

　　NOTE : Credit security clearance, confirmed via a background credit check, is required for this position.

　　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 $40,000- $56,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.

　　If you're excited about this role but your experience doesn't align perfectly with every qualification in the job description, consider applying for it anyway! Sedgwick is building a diverse, equitable, and inclusive workplace and recognizes that each person possesses a unique combination of skills, knowledge, and experience. You may be just the right candidate for this or other roles.

　　Taking care of people is at the heart of everything we do. Caring counts

　　Sedgwick is a leading global provider of technology-enabled risk, benefits and integrated business solutions. Every day, in every time zone, the most well-known and respected organizations place their trust in us to help their employees regain health and productivity, guide their consumers through the claims process, protect their brand and minimize business interruptions. Our more than 30,000 colleagues across 80 countries embrace our shared purpose and values as they demonstrate what it means to work for an organization committed to doing the right thing – one where caring counts. Watch this video to learn more about us. (https://www.youtube.com/watch?v=ywxedjBGSfA)