Application Developer, DentaQuest

Sun Life U.S. is one of the largest providers of employee and government benefits, helping approximately 50 million Americans access the care and coverage they need. Through employers, industry partners and government programs, Sun Life U.S. offers a portfolio of benefits and services, including dental, vision, disability, absence management, life, supplemental health, medical stop-loss insurance, and healthcare navigation. We have more than 6,400 employees and associates in our partner dental practices and operate nationwide.

Visit our website to discover how Sun Life is making life brighter for our customers, partners and communities.  

DentaQuest manages dental and vision benefits for more than 33 million Americans. Our outcomes-based, cost-effective solutions are designed for Medicaid and CHIP, Medicare Advantage, small and large businesses, and individuals. With a focus on prevention and value, we aim to make quality care accessible to improve the oral health of all.

Location: We support US flexible 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 Application Developer monitors and updates complex data sets derived from our ETL processes and ensures overall compliance and quality. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customer's data exchange and integration needs.

How you will contribute: 

• Monitor complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica, and .NET technologies. Datasets include custom flat files, EDI, user applications, and a significant focus on healthcare encounters and HIPAA X12 transactions: 277, 835, 837, 997, 999, TA1.

• Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems

• Research, troubleshoot, and resolve data issues impacting extract delivery.

• Work closely with Business Systems Analysts and Application Developers to understand requirements regarding solutions; ensure data quality and match-back to core systems transaction results.

• Collaborate on the definition, development, and maintenance of standards and processes.

• Drive continuous improvement and automation in BI solutions and processes.

• Support DentaQuest goals and objectives by working closely with management team to deliver value to the business.

• Other duties as needed or required.

What you will bring with you: 

• BS degree in Business, Computer Science, Engineering, Information Systems, or related field (or equivalent experience)

• 2 years as a Data Analyst

• Experience with SQL Server, Transact SQL and SQL Server Integration Services (SSIS), and highly desirable - Informatica, C#, and XML.

• Managed file transfer automation experience: FTP, SFTP, PGP

• Expert knowledge of relational database applications and data query protocols (SQL Server, Structured Query Language)

• Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.

• Excellent analytical, problem-solving, and innovative thinking skills.

• Desired experience with encounters or claims, business analysis experience in healthcare, preferably managed care or Medicaid.

• Desired knowledge of dental or medical insurance claims processing including:

  • Hands on experience with HIPAA X12 EDI transaction formats including: 277, 835, 837, 997, 999, TA1

  • Familiarity with appropriate handling of PHI data

• Required to attend additional training as requested/deemed necessary

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.

Salary Range: $78,200 - $117,300

At our company, we are committed to pay transparency and equity. The salary range for this role is competitive nationwide, and we strive to ensure that compensation is fair and equitable. Your actual base salary will be determined based on your unique skills, qualifications, experience, education, and geographic location. In addition to your base salary, this position is eligible for a discretionary annual incentive award based on your individual performance as well as the overall performance of the business. We are dedicated to creating a work environment where everyone is rewarded for their contributions.

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

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! 

We are committed to fostering an inclusive environment where all employees feel they belong, are supported and empowered to thrive.  We are dedicated to building teams with varied experiences, backgrounds, perspectives and ideas that benefit our colleagues, clients, and the communities where we operate.  We encourage applications from qualified individuals from all backgrounds.

Life is brighter when you work at Sun Life

At Sun Life, we prioritize your well-being with comprehensive benefits, including generous vacation and sick time, market-leading paid family, parental and adoption leave, medical coverage, company paid life and AD&D insurance, disability programs and a partially paid sabbatical program.  Plan for your future with our 401(k) employer match, stock purchase options and an employer-funded retirement account.  Enjoy a flexible, inclusive and collaborative work environment that supports career growth.  We’re proud to be recognized in our communities as a top employer.  Proudly Great Place to Work® Certified in Canada and the U.S., we’ve also been recognized as a "Top 10" employer by the Boston Globe's "Top Places to Work" for two years in a row.  Visit our website to learn more about our benefits and recognition within our communities.

We will make reasonable accommodations to the known physical or mental limitations 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 thebrightside@sunlife.com to request an accommodation.

For applicants residing in California, please read our employee California Privacy Policy and Notice.

We do not require or administer lie detector tests as a condition of employment or continued employment.

Sun Life will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including applicable fair chance ordinances.

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.