Advisory Services Data Analyst - SQL, Python

Posted 12 Minutes Ago
Be an Early Applicant
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
In-Office
Junior
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
The Role
Analyzes, transforms, validates, and integrates healthcare data from external suppliers using Python, PySpark, SQL, Snowflake, and ETL tools. Manages data quality, enrichment, SFTP exchanges, database support, root cause analysis, and customized analytics. Coordinates with clients, vendors, governance teams, and cross-functional stakeholders to support implementations, production operations, issue resolution, and reliable data solutions.
Summary Generated by Built In
Requisition Number: 2401499
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:
  • Act as the Data Steward and primary point of contact for client data management, carrier relationships, vendor coordination, and issue resolution
  • Integrate, analyze, and process raw data from multiple external suppliers to support healthcare analytics use cases
  • Validate, transform, and load data into the enterprise data warehouse while ensuring data accuracy, completeness, and integrity
  • Coordinate with cross-functional teams for onboarding, implementation, production support, and issue resolution
  • Perform data standardization and transformation using internal ETL tools and frameworks
  • Conduct data quality reviews, root cause analysis, trend analysis, and issue remediation activities
  • Deliver customized analytical outputs aligned with client and business requirements
  • Manage SFTP processes, including setup, configuration, access management, and maintenance for secure data exchange
  • Provide database support using Snowflake and develop queries to analyze complex processed datasets
  • Implement preprocessor programming to clean, organize, and enhance raw datasets for improved quality and usability
  • Execute data enrichment activities, including:
    • Raw data grain modification
    • Claims proration
    • Crosswalk-based indexing and data merging
    • Creation of derived and calculated fields
  • Perform end-to-end data validation through analytical querying, manual verification, and trend analysis
  • Ensure datasets meet established quality standards by validating patterns, default values, and identifying anomalies before integration
  • Collaborate with data analysts, governance teams, and business stakeholders to design and enhance data solutions that support organizational objectives
  • Leverage enterprise-approved AI tools to enhance productivity and innovation by streamlining workflows and automating repetitive tasks. Evaluate emerging trends to drive continuous improvement and strategic innovation
  • Comply with all applicable Company policies, procedures, and business directives, changes including those relating to work location, team assignments, work schedules, and flexible work arrangements

Required Qualifications:
  • Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field (or equivalent experience)
  • 2+ years of experience in Data Analytics, Data Mining, ETL Processing, or related roles
  • Python & PySpark Development - Hands-on experience with Python and functional knowledge of PySpark for data processing, transformation, and analytics. Concepts like dataframes transformations, withcolumn, Spark SQL
  • Experience with distributed data processing frameworks, particularly PySpark
  • Experience with SFTP-based file transfer and data exchange processes
  • Data Quality & Validation - Experience performing data validation, identifying and troubleshooting data quality issues, conducting root cause analysis, and ensuring data accuracy and integrity across datasets
  • Database & Data Management - Experience with Snowflake, SFTP data exchange processes, Ability to understand functional relationships between datasets, identify appropriate merge/join keys, determine data grain and levels of detail, and analyze correlations to support accurate data integration and analytics
  • Knowledge of healthcare analytics, payer data, eligibility data, and claims data concepts (preferred)
  • Familiarity with data quality frameworks, validation methodologies, and data governance practices
  • Understanding of SAS and migration methodologies from SAS to PySpark (preferred)
  • Proficiency in Python and intermediate-level PySpark development
  • Solid SQL & Data Analytics Expertise - Proficiency in complex SQL queries, data validation, troubleshooting, trend analysis, and data quality assessments
  • Proven solid expertise in SQL, including:
    • Complex queries and joins
    • Performance optimization
    • Data validation and troubleshooting
  • Proven excellent communication and stakeholder management skills
  • Proven ability to collaborate effectively with cross-functional teams and manage multiple priorities in a dynamic environment
  • Demonstrated basic awareness of AI/ML concepts, terminology, and data-driven initiatives
  • Demonstrated solid analytical, problem-solving, and critical-thinking capabilities
  • Stakeholder & Cross-functional Collaboration - Demonstrated solid communication, problem-solving, and coordination skills to work with clients, vendors, business stakeholders, and technical teams

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 enterprise priority reflected in our mission.

Skills Required

  • Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field, or equivalent experience
  • 2+ years of experience in data analytics, data mining, ETL processing, or related roles
  • Hands-on Python development experience and functional knowledge of PySpark for data processing, transformation, and analytics
  • Experience with distributed data processing frameworks, particularly PySpark
  • Experience with SFTP-based file transfer and data exchange processes
  • Experience performing data validation, troubleshooting data quality issues, root cause analysis, and ensuring data accuracy and integrity
  • Experience with Snowflake and database/data management, including dataset relationships, merge and join keys, data grain, and data integration
  • Knowledge of healthcare analytics, payer data, eligibility data, and claims data concepts
  • Familiarity with data quality frameworks, validation methodologies, and data governance practices
  • Understanding of SAS and migration methodologies from SAS to PySpark
  • Proficiency in Python and intermediate-level PySpark development
  • Proficiency in complex SQL queries, data validation, troubleshooting, trend analysis, and data quality assessments
  • SQL expertise including complex queries and joins, performance optimization, data validation, and troubleshooting
  • Excellent communication and stakeholder management skills
  • Ability to collaborate with cross-functional teams and manage multiple priorities
  • Basic awareness of AI/ML concepts, terminology, and data-driven initiatives
  • Analytical, problem-solving, and critical-thinking capabilities
  • Communication, problem-solving, and coordination skills for working with clients, vendors, business stakeholders, and technical teams

What the Team is Saying

Optum Compensation & Benefits Highlights

  • Leave & Time Off Breadth — Paid time off is often regarded as generous, with meaningful accrual and flexibility to use it. While practices can vary by team, the overall time-off offering stands out as a relative strength.
  • Retirement Support — A 401(k) plan with employer matching is available and generally well-regarded for supporting long-term savings. It remains valuable, though candidates should verify the current match formula.
  • Parental & Family Support — Programs such as parental leave, family medical leave, and adoption assistance are included as notable elements of the total rewards package. These resources can meaningfully support work-life balance when applicable to the role and location.

Optum Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Eden Prairie, MN
160,000 Employees
Year Founded: 2011

What We Do

Optum, part of the UnitedHealth Group family of businesses, 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. At Optum, we support your well-being with an understanding team, extensive benefits and rewarding opportunities. By joining us, you’ll have the resources to drive system transformation while we help you take care of your future. We recognize the power of connection to drive change, improve efficiency and make a difference in health care. Join a team where your skills and ideas can make an impact and where collaboration is key to creating technology that produces healthier outcomes.

Gallery

Gallery
Gallery
Gallery

Optum Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Optum has three workplace models that balance the needs of the business and the responsibilities of each role. These models, core on‑site (5 days/week), hybrid (4 days/week) and telecommute or fully remote, vary by country, role and location.

Typical time on-site: Not Specified
HQEden Prairie, MN
Metro Manila, Philippines
Cebu, Philippines
Davao, Philippines
Ann Arbor, MI
Atlanta, GA
Baltimore, MD
Bengaluru, India
Chennai, India
Dallas, TX
Detroit, MI
Dublin, Ireland
Hartford, CT
Houston, TX
Hyderabad, India
Jacksonville, FL
Las Vegas, NV
Letterkenny, Ireland
Louisville, KY
Madison, WI
Minneapolis, MN
Nashville, TN
New Delhi, India
Philadelphia, PA
Phoenix, AZ
Pune, India
Raleigh, NC
San Diego, CA
Washington, DC
Learn more

Similar Jobs

Optum Logo Optum

Data Engineering Lead

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Software Engineering Lead

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Architect

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Optum Logo Optum

Principal Capacity - Technical Performance Management

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Noida, Gautam Buddha Nagar, Uttar Pradesh, IND
160000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account