Data Intake Consultant

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Location: We support US virtual working arrangements in the contiguous 48 states.

At Sun Life, we look for optimistic people who want to make life brighter for our Clients. We understand the value of diverse cultures, perspectives, and identities, and want you to bring your full and authentic self to work. Every day, you’ll be empowered and challenged by working with dynamic colleagues to find new and innovative ways to make Sun Life the best benefits company in America.

The opportunity:

The Data Intake Consultant is supporting Health and Risk Solutions within Claims Services. This position is responsible for developing and maintaining automated, sustainable solutions to accurately and efficiently process and track big data – related to both production data and reporting – in accordance with Claims Services processes.

The Claims Services Data Intake Consultant will analyze existing data solutions and utilize technical skills to provide additional automation, organize and display key performance metrics. The position will work closely with the Claims Services Associate Director and Senior Manager to ensure that these automated solutions are thoroughly tested and accurately account for all client scenarios; creating sustainability and implementing automated controls where available.

How you will contribute:

• Troubleshoot data issues while maintaining the integrity of the original data received
• Understands stop loss insurance and claims data received including both medical and RX feeds
• Possess expert Excel skills to develop sustainable resolutions to process Claims Services’ tasks accurately and efficiently
• Process confidential data and information according to guidelines
• Document and clearly communicate instructions for template use and revisions; following up on changes to ensure end results are in accordance with current practices
• Manage master data set
• Develop and maintain centralized reports derived from various existing sources
• Understand the current data environment and can proactively create solutions for business process changes
• Generate reports from single or multiple systems
• Provide technical expertise on data storage & data mining
• Create valid continuous improvement ideas and solutions, implementing solution after receiving management’s approval
• Automate team dashboards and other documents as necessary
• Present data solutions and train end users accordingly
• Clearly document instructions and revisions for all end users
• Meet with Associate Director regularly to communicate improvements, concerns & opportunities to develop additional efficiencies

• Ability to work with a diverse range of people
• Comfortable working in a fast-paced environment, managing deliverables within deadlines
• Results oriented and resourceful with strong analytical skills
• Understands the importance of accuracy when processing data received and uses technical skills to appropriately provide consistent handling by end users
• Incorporates a continuous improvement mindset in everyday work
• Proficient knowledge of medical claims data and claims processes
• Highly organized with ability to independently manage time
• A strong ability to communicate to various technical levels and present, both verbally and written
• Consistently presents positively during team discussions.
• Continuously looks to improve his/her skills by engaging in development opportunities.
• Ability to build partnerships and influence across the organization to achieve results

What you will bring with you:

• BS/BA degree in computer science/engineering or economy with experience preferred in programming
• ETL programming experience, Visual Basic .Net or C Sharp, R and/or Python programming experience a plus
• Manipulate data with complex Excel, SQL, SSIS (preferred) and Talend
• 3 years advanced experience with MS Excel, object-oriented programming and SQL scripting

Do you see yourself in this role even if you haven’t checked all the boxes above? We welcome all talented candidates and are committed to a culture that represents diversity in all forms. If you think you might thrive in this setting, we would love to hear from you.

Not ready to apply yet but want to stay in touch? Join our talent community to stay connected until the time is right for you!

Life is brighter when you work at Sun Life

• Excellent benefits and wellness programs to support the three pillars of your well-being – mental, physical and financial – including generous vacation and sick time, market-leading paid family, parental and adoption leave, a partially-paid sabbatical program, medical plans, company paid life and AD&D insurance as well as disability programs and more
• Retirement and Stock Purchase programs to help build and enhance your future financial security including a 401(k) plan with an employer-paid match as well as an employer-funded retirement account
• A flexible work environment with a friendly, caring, collaborative and inclusive culture
• Great Place to Work® Certified in Canada and the U.S.
• Named as a “Top 10” employer by the Boston Globe's “Top Places to Work” two years running

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

If you are a California resident, the salary range for this position is:

Southern region: 53,200-76,200 annually

Central region: 56,100-84,200 annually

Northern region: 60,000-90,000 annually

If you are a Colorado resident, the salary range for this position is 50,800-76,200

If you are a New York resident, the salary range for this position is 60,000-90,000 annually

If you are Washington resident, the salary range for this position is 56,100-84,200 annually

We consider various factors in determining actual pay including your skills, qualifications, and experience. In addition to salary, this position is eligible for incentive awards based on individual and business performance as well as a broad range of competitive benefits.

Sun Life Financial is a leading provider of group insurance benefits in the U.S., helping people protect what they love about their lives. More than just a name, Sun Life symbolizes our brand promise of making life brighter -for our customers, partners, and communities. Join our talented, diverse workforce and launch a rewarding career. Visit us at www.sunlife.com/us to learn more.

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

#LI-remote

Our Affirmative Action Program affirms our commitment to make reasonable accommodation to the known physical or mental limitation of otherwise-qualified individuals with disabilities or special disabled veterans, unless the accommodation would impose an undue hardship on the operation of our business. Please email recruitingUS@sunlife.com to request an accommodation.

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.