Advisory Svcs Consultant

*Develop and deliver Facets System Integration (SI) code, Custom API code, and other custom solutions using programming languages (e.g., C#, .NET, SQL). *Configure and customize Facets applications and modules (e.g., Claims, Membership, Provider, Billing) to meet client needs. *Write and optimize SQL queries and stored procedures for data manipulation and system enhancements. *Develop integrations with other healthcare systems and external applications using web services, APIs (e.g., REST API, FXI), Batch interfaces and EDI transactions (e.g., 834, 835, 837). - Undergraduate degree or equivalent experience. *8+ experience as a Facets Developer, with a strong understanding of the TriZetto Facets application, its core modules (Claims, Membership, Provider, Billing) and Data mapping *8+ Experience of working in Facets Migrations, Upgrades and regulatory programs *8+ years of experience in the healthcare domain, particularly with payer systems, HIPAA standards, and EDI (Electronic Data Interchange) transactions (e.g., ANSI X12, 834, 835, 837). *Strong hands-on development experience with Facets custom interfaces, extensions, and REST API development. *Experience working in Agile environments and across the full Software Development Life Cycle (SDLC). *Proficiency in SQL (MS SQL Server, Oracle PL/SQL) for complex query writing, stored procedures, and ETL process *Strong programming skills in C# and .NET Framework (including ASP.NET, Web Forms, Web Services, and API development). *UI/UX development experience with front end technologies like Angular, React, HTML, CSS *Familiarity with web services and integration tools (e.g., Mule soft, REST APIs). *Experience in Cloud platform like Azure, AWS, GCP. *Experience with version control systems (Git). *Developing AI solutions using Co-Pilot etc. Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make the health system work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work. SM Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.