Architecture Analyst

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.

Architecture Analyst is responsible for designing scalable data solutions, optimizing PostgreSQL platforms, building Python-based pipelines, ensuring enterprise data quality and understanding datamart processes. Knowledge of ServiceNow CMDB is a solid plus.

Primary Responsibilities:

• Translate business requirements into scalable data architecture and models
• Design and support datamart structures and data flow processes
• Optimize PostgreSQL performance (SQL tuning, indexing, partitioning)
• Develop Python-based ETL / automation pipelines
• Implement data quality rules, validation, reconciliation, and monitoring
• Define architecture standards, documentation, and best practices
• Collaborate with engineering, analytics, and business teams
• 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

• 6+ years of experience in data engineering / architecture roles
• Solid hands-on experience in PostgreSQL & Advanced SQL
• Knowledge of Python (ETL, automation)
• Knowledge of Data Quality frameworks
• Knowledge of Datamart concepts and lifecycle
• Knowledge of data modeling, pipeline design, and performance tuning
• Knowledge of Git, Linux, SDLC practices

• ServiceNow CMDB knowledge
• Knowledge of Cloud platforms (AWS / Azure / GCP)
• Knowledge of Orchestration tools (Airflow / Prefect)
• Knowledge of BI tools
• Data warehouse exposure