Software Engineer

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 diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities:

• Designing, developing and testing SSIS packages to be used during the ETL process
• Analyze the issues encountered during day-to-day tasks and work towards resolving them quickly and effectively
• Working with various customers and stakeholders, to understand business use cases or requirements
• Developing SQL Server Database code for all new features
• Lead the technical team in fixing production issues
• Validate and debug packages to ensure they function properly before they are deployed
• Lead the team in migration efforts of DB and ETL code from lower version to higher version
• Automate the generation of reports using SSIS
• Deploy the code to production in a timely manner
• Mentor, guide, and provide technical and functional KT to the new joiners in the team
• Owned complete code reviews in a timely manner
• 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

Required Qualifications:

• Graduate degree or equivalent experience
• Hands-on development experience with Transact-SQL, including stored procedure development
• Experience in programming in T-SQL and Microsoft .net
• Experience in UI frameworks such as Angular, React
• Proficient in creating SSIS packages for importing data utilizing XML, CSV and comma delimitate files
• Proficient in C# programming language
• Proven ability to design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
• Proven ability to build data transformations with SSIS including importing data from files, moving data from one database platform to another
• Proven ability to design and develop data transformation solutions using SSIS components such as Data Flow Task, Data Flow transform tasks, Data Flow containers, Foreach Loop containers, Script components, XML components
• Proven ability to debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
• Proven ability to design, build, and maintain metadata models and complex ETL packages

Preferred Qualifications:

• Experience in Azure
• Solid knowledge and working experience as an ASP .NET MVC developer

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes – an enterprise priority reflected in our mission.