FINEOS DET Engineer

Primary Responsibilities

• Develop and maintain FINEOS Data Extraction Technology (DET) scripts to support reporting, data extraction, and downstream system integrations.
• Support daily extraction, validation, and delivery of employee, employer, policy, and coverage-related data.
• Ensure data accuracy, completeness, consistency, and compliance with business requirements.
• Work extensively with the FINEOS data model, including party management, member models, benefits, payments, policies, and coverage administration.
• Configure and customize FINEOS AdminSuite components based on business and functional requirements.
• Support Absence Management processes, including leave requests, leave adjudication, notifications, activities, tasks, and workflows.
• Analyze, develop, debug, and optimize complex SQL queries used in DET-based data extraction and reporting.
• Improve DET script performance, scalability, and maintainability.
• Develop and support REST and SOAP API integrations for digital portals and downstream applications.
• Collaborate with business analysts and stakeholders to translate business requirements into technical solutions.
• Perform unit testing, defect analysis, troubleshooting, and remediation.
• Support production deployments, application maintenance, and production issue resolution.
• Participate in technical design reviews and solution discussions.
• Prepare technical documentation, operational procedures, and knowledge transfer materials.
• Coordinate with offshore development and support teams to ensure timely delivery and effective issue resolution.

Required Qualifications

• 10+ years of experience in enterprise application development, integration, or support.
• Strong hands-on experience with FINEOS AdminSuite and FINEOS Data Extraction Technology (DET).
• Expertise in developing and maintaining DET scripts for data extraction and reporting.
• Strong understanding of the FINEOS data model, product architecture, configuration, and customization.
• Functional knowledge of Short-Term Disability (STD), Long-Term Disability (LTD), Disability Insurance, and Absence Management.
• Experience with SQL development, complex query debugging, performance tuning, and data validation.
• Knowledge of FINEOS modules covering user maintenance, party management, member models, benefits, payments, policies, and coverage administration.
• Experience working with eForms, activities, tasks, notifications, and workflow configurations.
• Hands-on experience with REST and SOAP API integrations.
• Experience supporting downstream data interfaces and enterprise application integrations.
• Strong troubleshooting, analytical, and problem-solving capabilities.
• Excellent communication skills and experience coordinating with offshore teams.