AI ML Engineer (SG25, 26, 27, 28, 29)

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, and maintain high-performance ETL solutions using SSIS to support business intelligence and data warehousing needs
• Write advanced and optimized T-SQL queries for data extraction, transformation, and loading
• Troubleshoot and enhance existing SSIS packages to ensure reliability and performance
• Monitor and support ETL processes across QA, UAT, and Production environments, including job monitoring and issue resolution
• Integrate data from diverse sources such as RDBMS, APIs, FTPs, and cloud storage in various formats (CSV, JSON, XML, Parquet, etc.)
• Utilize C# and Regex for complex data transformation tasks within ETL workflows
• Analyze business requirements and deliver fully automated, scalable ETL solutions
• Contribute to the development and refinement of ETL best practices, including data quality and cleansing standards
• Provide accurate work estimates and deliver solutions in alignment with project timelines
• Communicate effectively with the Data Engineering Manager regarding project status, risks, and dependencies
• Collaborate with cross-functional teams to ensure data solutions meet business needs
• Foster a culture of knowledge sharing and continuous improvement within the team
• 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

• Hands-on experience with Snowflake, Databricks, or Kafka
• Experience in data engineering, with solid expertise in SSMS, SSIS, and SQL
• Experience in business/data analysis
• Experience with version control systems like TFS or GitHub
• Solid understanding of database design, lifecycle management, and performance tuning
• Proven ability to build and maintain DevOps pipelines for data workflows
• Proven excellent communication skills and ability to work across teams and stakeholders