Senior Software Engineer II - Snowflake,API, Data Built Tool(DBT)

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:

• Build and optimize data pipelines and cloud data platforms (e.g. Snowflake), enable data transformation and analytics for enterprise use
• Data Management: Proficiency in Snowflake for data wrangling and management, optimizing data structures for analysis
• Apache Airflow (workflow orchestration) and related ETL tools; Locust for performance/load testing
• DBT Utilization: Build and maintain data marts and views using DBT, along with tools like Airflow
• Act as an individual contributor and come up with use cases for AI/ML implementations for projects being executed
• ETL/ELT Solutions: Design ETL/ELT solutions using technologies like Postgres, Snowflake, leveraging methodologies to acquire data from various structured or semi-structured source systems
• Enforce strict data quality standards, monitoring and conduct performance testing of data pipelines and APIs, optimize data processing jobs for efficiency and scalability.
• Bridge the gap between business needs and technical solutions.
• Communication: Solid communication skills to explain technical issues and solutions clearly to the Engineering Lead and key stakeholders (as required)
• Integrate CI/CD pipelines using EPL and GitHub, with focus towards secure coding practices
• Infrastructure as Code: Create and maintain Azure Infrastructure as Code using Terraform and GitHub Actions
• Understand and estimate feature based estimation of functionalities, and ensure on-schedule, and on-scope delivery within quality goals
• Ensure compliance with organization and project defined standards and processes and follow proactive vulnerability and secure based development practices
• 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:

• Bachelor’’s degree in Computer Science, Information Technology, or equivalent experience
• 8+ years of experience in designing ETL/ELT solutions using technologies like Snowflake, Postgres
• Experience with Web Services, Web Services Security, REST, SOAP
• Hands-on experience with instrumenting CI/CD pipelines
• Practical experience with public cloud platforms such as Microsoft Azure, Amazon Web Services, or Google Cloud Platform
• Proficiency in Snowflake for data wrangling and management
• Proven ability to use DBT (Data Build Tool) to build and maintain data marts and views
• Proven ability to configure, set up, and maintain GitHub for various code repositories
• Proven ability to quickly learn new technologies leverage them to execute on the use cases given to solve business problems
• Proven solid written and verbal communication skills including explaining complex concepts effectively to technical and non-technical audience

*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 enterpri…