Quick overview
Job description
Job Title: Senior Facets Technical Consultant
Location: Remote
Job Description:
Job Summary
- 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, and strengthening production stability, monitoring, and recovery.
Key Responsibilities
- Analyze and optimize Facets batch jobs, SQL queries, scripts, and stored procedures.
- Perform batch runtime, dependency, critical-path, workload, and throughput analysis to identify optimization opportunities.
- Diagnose SQL Server performance issues, including locking, blocking, deadlocks, wait statistics, indexing, CPU, memory, and I/O bottlenecks.
- Recommend improvements to batch sequencing, parallel processing, workload distribution, SQL performance, and batch-window reduction.
- Perform root-cause analysis of recurring batch failures and recommend restart/recovery procedures, operational runbooks, monitoring, and automation improvements.
- Analyze performance across Claims, Payments, XC, and Pre/Post-Adjudication processing.
- Establish performance baselines and validate optimization recommendations through performance and regression testing.
- Support capacity planning, workload forecasting, performance monitoring, and environment comparisons.
- Document findings, risks, recommendations, and a prioritized performance improvement roadmap.
Required Qualifications
- 10+ years of experience in enterprise application development, production support, database engineering, or performance optimization, with strong hands-on TriZetto Facets experience.
- Must have 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.
Similar jobs
- SP
Software Engineer, Super IntelligenceRecently posted Auto Apply
SpaceXSI · Palo Alto · Hybrid · Posted 16 Nov 2026 🇺🇸
RustTCP/IPC+++1Technology$140k - $225k/yr - SY

Junior BI Analyst/Junior Software Developer - RemoteRecently posted
SynergisticIT · Brooklyn, New York · Remote · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementJavaPython+3Technology$95k - $154k/yr - GB
Systems Analyst 2Recently posted
Green Bay Packaging - Corporate · Green Bay, Wisconsin · On-site · Posted 16 Nov 2026 🇺🇸
ERPCompensation & BenefitsContinuous Improvement+1TechnologySalary not listed - HM
It Application Analyst Iii -epic CupidRecently posted
Hackensack Meridian Health · Iselin, New Jersey · Hybrid · Posted 16 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPointTechnology$97.0k/yr - HM
It Application Analyst V - Ancillary HealthRecently posted
Hackensack Meridian Health · Iselin, New Jersey · Hybrid · Posted 9 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPoint+1Technology$133.1k/yr - DA
Full Stack Software Developer - AI TrainerRecently posted
DataAnnotation · Vienna, Virginia · Hybrid · Posted 16 Nov 2026 🇺🇸
SwiftC#C+++8Technology$50 - $100/hr - TA

Electrical Engineer (Senior/Staff), AvionicsRecently posted Auto Apply
True Anomaly · Denver · Hybrid · Posted 16 Nov 2026 🇺🇸
MATLABFPGAAssembly+4Technology$135k - $250k/yr - TA

Electrical Engineer II-III, AvionicsRecently posted Auto Apply
True Anomaly · Denver · Hybrid · Posted 16 Nov 2026 🇺🇸
MATLABAssemblyBudgeting+6Technology$90k - $165k/yr - AW

Senior Systems Software Engineer, EC2 NetworkingRecently posted
Amazon Web Services, Inc. · San Diego, California · Hybrid · Posted 16 Nov 2026 🇺🇸
Embedded SystemsCI/CDTechnologySalary not listed - SP

Site Reliability Engineer, GNC (Falcon)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 16 Nov 2026 🇺🇸
DockerTCP/IPAnsible+8Technology$125k - $160k/yr - SP

Sr. Mechanical Engineer (Starship Avionics)Recently posted Auto Apply
SpaceX · Hawthorne · Hybrid · Posted 16 Nov 2026 🇺🇸
CADFEAMechanical Design+2Technology$135k - $215k/yr - CO

Machine Learning Engineer 5Recently posted
Capital One · Mc Lean, VA · Hybrid · Posted 16 Nov 2026 🇺🇸
GCPScalaAWS+14Technology$229.9k - $262.4k/yr
