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
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)