at Sun Life Financial (U.S.) Services Company, Inc. in South Portland, Maine, United States
Job Description
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.
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: 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 ourClients.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 challengedbyworking withdynamic colleaguesto find new and innovative ways to make Sun Life the best benefits company in America.
The opportunity:
The Sr. ProgrammerAnalyst performs advanced-level supports of proprietary applications. This role governs application design/analysis, developing project plans, coding, testing, documenting all code, and maintaining and upgrading existing applications.
How you will contribute:
Develop and maintain C#, BizTalk applications that process electronic eligibility files (EDI 834)
Focus on maintaining and enhancing data migration ETL's
Optimizing the stored procedures, indexing and performance to enhance the database performance
Investigating Database bottlenecks: dead-lock resolution, data serialization issues - delayed writes, locks, columnar updates, etc.
Work closely with business users to identify, report and correct data centric issues.
Deployment of enhancements and modifications/releases environments (Dev, QA, Prod)
What you will bring with you:
Strong experience with SQL Server and writing/optimizing SQL queries and stored procedures
Experience on EDI 83X formats (EDI 834 is preferred
Should have knowledge and hands-on experience of SSIS. SSRS is a bonus.
Strong working experience with .NET Framework (C#)
Working experience in configuring, developing and assisting BizTalk applications (BizTalk Server 2010 or higher required; BRE and BizTalk 360 is a plus)
Good grasp of Software Development Life Cycle
Proven track record in delivering high-quality Database backend projects within tight deadlines.
Excellent reasoning skills and resourcefulness
Excellent communication skills
Must be able to work well alone and in a team-oriented, collaborative environment.
Hands on experience in Database finetuning, resolution of performance bottlenecks (using Profilers and similar tool suite)
Working experience with data migration/integration (within the healthcare field, particularly dental health benefits administration is a plus).
Ability to work in a fast-paced environment and deliver results with quick turnaround times.
HIPAA, PHI, PII and Information security awareness, preferred.
Working experience on US Healthcare medical insurance segment, Medicaid dental/vision benefits piece preferred.
Experience with process automation preferred.
Experience in scripting with PowerShell preferred.
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... For full info follow application link.
Sun Life Financial is an equal employment and affirmative action employer. All qualified applicants will receive consideration without regard to race, color, sex, religion, age, national origin, disability, veteran status, sexual orientation, gender identity or expression, marital status, ancestry or citizenship status, genetic information, pregnancy status or any other characteristic protected by law. Sun Life Financial is committed to building a diverse and inclusive company culture.
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.
