[Hiring] Senior Facets Technical Consultant @Genius Business Solutions

Role Description

We are seeking an experienced TriZetto Facets Technical Consultant to lead performance analysis and optimization of high-volume Facets batch processing and Microsoft SQL Server workloads. The role will focus on:

• Reducing batch processing windows
• Resolving application and database bottlenecks
• Improving workload efficiency
• Strengthening production stability, monitoring, and recovery

Qualifications

• 10+ years of experience in enterprise application development, production support, database engineering, or performance optimization, with strong hands-on TriZetto Facets experience
• Strong hands-on knowledge of BINB, 837I, CLMU, CKMM, 835, and BOTB batch streams, including execution flows, dependencies, failure analysis, restart/recovery, and performance optimization
• Deep understanding of Facets batch architecture, job streams, dependencies, sequencing, scheduling, and restart/recovery processes
• Strong hands-on experience with Microsoft SQL Server, T-SQL, stored procedures, and SQL performance tuning
• Experience with execution plans, Query Store, DMVs, indexing, wait statistics, locking/blocking, and deadlock analysis
• Proven experience troubleshooting and optimizing high-volume, performance-sensitive production batch workloads
• Good understanding of healthcare payer processing, particularly Claims, Providers, Payments, and adjudication processes
• Strong root-cause analysis, problem-solving, technical documentation, and stakeholder communication skills
• Ability to collaborate across application, database, infrastructure, testing, and production support teams

Requirements

• Facets
• SQL
• .Net
• SSIS

Preferred Qualifications

• Experience with NetworX, PBA, Facets Workflow, XC/extract processing, or related Facets components
• Experience with enterprise batch schedulers, monitoring, and observability tools
• Experience with performance testing, capacity analysis, workload forecasting, and operational automation
• Experience supporting and optimizing large-scale healthcare payer production environments

Company Description

Genius Business Solutions Inc. (GBSI) is a globally recognized IT services leader with 20+ years serving Fortune 500 organizations. Our teams deliver solutions across automotive, manufacturing, retail, and pharmaceutical industries. Headquartered in Moline, IL, GBSI supports clients and consultants throughout the US, Canada, Europe, and India.