Sr. 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.

Job Description:

Location:  Sun Life embraces a hybrid work model that balances in-office collaboration with the flexibility of virtual work in the contiguous states plus AK. 

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 Sr. Developer improves and implements technical solutions. 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.

**Individual must work 8:00AM - 5:00PM PST time zone.

How you will contribute: 

• Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica, and .NET technologies. Requests 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 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 Developer, Data Analyst, or equivalent implementing technical solutions (extracts, middleware, stored procedures, EDI, ETL packages)

• 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