Senior Data 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 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:

• Write SQL queries
• Design, develop, unit test and maintain ETL jobs to create or enhance data warehouses or marts
• Identify test solutions for small to medium size projects and create test strategy or test plans, as well as Support defect or issue resolution and retesting
• Deploy and test code from lower environments to production
• Document technical specifications, data models, process flows, etc.
• Identify areas of improvement areas and propose solutions for the same
• Collaborate with delivery and technical team members on design and development activities within Agile or Scrum teams
• Collaborate with business partners to understand business processes, standard release management requirements, and underlying data and reporting needs
• Willingness to work with different teams
• Be able to adapt in a dynamic work environment, learn quickly and solve problems
• Track progress and status reporting
• Application support
• Conduct research and stay updated on the latest AI technologies and tools available for in ETL and data engineering.
• Leverage GitHub Copilot for productivity
• 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

• Graduate degree or equivalent experience
• Bachelor's degree in Computer Science or related field
• 1+ years of experience in any ETL tool
• 1+ years of experience with data warehouses or marts (data modeling and design)
• 1+ years of intermediate to advanced SQL experience
• 1+ years of SSIS development experience
• Experience working in a matrixed environment on a fast-paced project
• Business-side experience with IT partners, or IT-side experience with Business partners
• Experience as a AI builder, should be able to propose AI driven projects
• Demonstrated ability to use AI and AI enabled tools in daily work for productivity increase
• Proven proactive thinker, self-driven, great team player who drives innovation
• Proven quickly adopt AI enabled tools available in the market

• API Experience
  • Understanding of RESTful Principles and GraphQL
  • Expertise in Programming Languages (e.g., JavaScript, Python, Java)
  • Knowledge of API Security Best Practices
  • Proficiency in API Design and Architecture
  • Proficiency with API Documentation Tools (e.g., Swagger or OpenAPI)
• Data Bricks Experience
  • Experience with Delta Live Tables within data processing jobs
  • Creating and scheduling data processing (ETL) jobs using Data Bricks to load into Delta and/or Delta Live Tables, Data Lakes