Software Engineer (Python/SQL)

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:
Data Pipeline Development
Design and implement ETL/ELT pipelines for structured, semi-structured, and unstructured data
Build and maintain data flows connecting operational systems, analytics platforms, and BI tools
Data Modeling and Schema Design
Create scalable schemas across multiple business domains
Apply dimensional modeling techniques for efficient data storage and retrieval
Infrastructure and Automation
Develop infrastructure for data ingestion, transformation, and delivery using tools like AWS, SQL, and Python
Automate workflows and implement reusable frameworks for data processing
Data Quality and Performance
Implement validation and monitoring processes to ensure data integrity
Optimize query performance and resource utilization in data systems
Collaboration and Support
Work with Data Architects, BI engineers, and Data Scientists to design end-to-end solutions
Assist stakeholders with data-related technical issues and ensure smooth development processes
~ 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:
Proven technical skills:
Languages and Tools: SQL, Python, Java/Scala, Git
Cloud Platforms: AWS (EC2, S3, Redshift), Azure Synapse, GCP BigQuery
Big Data Frameworks: Spark, Hive, Kafka, Airflow
ETL Tools: Informatica, Talend, SSIS
Data Modeling: Schema design, dimensional modeling