Sun Life is a leading financial services organization dedicated to helping people achieve lifetime financial security. The Application Developer is responsible for monitoring and updating complex data sets, ensuring compliance and quality, and collaborating with various teams to enhance data exchange and integration.
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.
Qualification
Required
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.
Required to attend additional training as requested/deemed necessary.
Preferred
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.
Benefits
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
Sun Life is a leading financial services organization dedicated to helping people achieve lifetime financial security and live healthier lives.
