Senior Software Engineering Lead - TSQL and 837 Medical Claims

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities:

• Design, develop, & maintain complex T-SQL queries, stored procedures, functions, views, & triggers
• Optimize existing SQL queries for performance and scalability
• Implement indexing strategies and query tuning techniques
• Work alongside a very small technical team to provide redundancy
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

• 837 claim and EDI experience
• Experience with database design, data modeling, and normalization
• Experience applying programming methods using SQL
• Proficiency in T-SQL (Transact-SQL) for writing complex queries, stored procedures, functions, and triggers
• Solid understanding of Microsoft SQL Server architecture and tools
• Knowledge of performance tuning, query optimization, and indexing strategies
• Proven ability to analyze complex data requirements and translate them into efficient SQL solutions
• Proven solid debugging and troubleshooting skills for database-related issues

• Database management experience
• Experience with version control with tools such as Git, CICD
• Understanding of APIs
• Soft skills like communication, problem-solving, and teamwork are equally important