Senior Data Engineering Consultant

Optum; India; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Optum is seeking a senior data platform engineer to design and build end-to-end data pipelines, models and analytics solutions within healthcare data ecosystems. You will work across SQL Server, Snowflake, Azure Data Factory, and BI tools to enable reliable reporting and insights.

The role emphasizes performance tuning, data modeling, documentation, and collaboration with analytics teams, with a steady focus on HIPAA compliance and scalable cloud platforms.

Qualifications

• Undergraduate degree or equivalent experience.
• Data platform or cloud certifications.
• 10+ years of experience with Snowflake, Synapse or cloud-native data platforms.
• Experience with SSAS or other legacy BI components.
• Experience with CozyRoc SSIS+ or other third-party ETL/ELT components.
• Experience with data APIs (ServiceNow, UKG, Kronos).
• Experience with healthcare data constructs or clinical systems.
• Exposure to AI/ML concepts, tools, or platforms.

Responsibilities

• Build and maintain ETL/ELT pipelines using SQL Server, SSIS, Azure Data Factory, Snowflake, Airflow, and dbt.
• Provide maintenance for SSAS Tabular and/or Multidimensional models.
• Support reporting via SSRS, Power BI, and Tableau; ensure data accuracy.
• Optimize performance across SQL Server, Snowflake, SSIS, ADF, dbt, and BI tools.
• Design relational and dimensional data models; document data structures.
• Document pipeline logic and support incidents via ServiceNow.
• Participate in sprint ceremonies and share knowledge across teams.
• Handle unstructured, complex issues; mentor others.

Skills

Data platform certs

10+ years Snowflake/Synapse

SSAS/BI legacy

ETL/ELT tools (SSIS+)

Data APIs (ServiceNow/Kronos)

Healthcare data domain

AI/ML concepts/tools

Education

Undergraduate degree or equivalent experience

Tools

Snowflake

Synapse

Azure Data Factory

dbt

Power BI

Job description

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.

Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data. Selects, develops and evaluates personnel to ensure the efficient operation of the function. Generally work is self-directed and not prescribed.

Primary Responsibilities:

• Data Pipeline Development
  • Build and maintain ETL/ELT pipelines using SQL Server, SSIS, Azure Data Factory, Snowflake, Airflow, and dbt
  • Support and enhance legacy SSIS pipelines while contributing to modernization efforts
  • Ensure timely, accurate, and secure data movement across systems
  • Implement and maintain robust logging, error handling, and auditing frameworks
  • Participate in peer reviews and support reusable, framework-driven engineering practices
• Analytics Semantic Layer (Legacy SSAS Support)
  • Provide maintenance and enhancement support for SSAS Tabular and/or Multidimensional models
  • Troubleshoot processing issues, performance bottlenecks, and security role configurations
  • Ensure SSAS models continue to meet reporting and analytics needs during modernization transitions
• Reporting Data Delivery
  • Support reporting via SSRS, Power BI, and Tableau
  • Validate data accuracy and ensure outputs meet stakeholder needs
  • Collaborate with analytics teams to deliver actionable insights and promote self-service reporting
  • Assist with legacy SSRS report maintenance and performance tuning as needed
• Performance Tuning Optimization
  • Optimize performance across SQL Server, Snowflake, SSIS, ADF, dbt, Airflow, and reporting platforms
  • Tune T SQL queries, stored procedures, indexing strategies, and data models
  • Identify and remediate bottlenecks across pipelines, semantic layers, and reporting workloads
  • Partner with platform teams to improve reliability, scalability, and cost efficiency
• Data Modeling (Relational Dimensional)
  • Design and maintain relational and dimensional data models supporting analytics, reporting, and operational workflows
  • Apply best practices for star schema design, SCD handling, and semantic consistency
  • Document data structures, lineage, and business logic for cross-team clarity
• Documentation Support
  • Document pipeline logic, dependencies, and operational procedures
  • Respond to incidents and service requests through ServiceNow
  • Follow change control, governance, and compliance standards (HIPAA, ITIL)
• Collaboration Continuous Learning
  • Participate in sprint ceremonies and design reviews
  • Communicate clearly across technical and non-technical audiences
  • Share knowledge through documentation and peer support
  • Embrace feedback and contribute to a positive, growth-oriented team culture
• Works with less structured, more complex issues
• Serves as a resource to others
• 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:

• Undergraduate degree or equivalent experience
• Data platform or cloud certifications
• 10+ years of experience with Snowflake, Synapse, or cloud native data platforms
• Experience with SSAS or other legacy BI components
• Experience with CozyRoc SSIS+ or other third-party ETL/ELT components
• Experience with data APIs (ServiceNow, UKG, Kronos)
• Experience with healthcare data constructs or clinical systems
• Exposure to AI/ML concepts, tools, or platforms (e.g., Azure Machine Learning, Python ML libraries, AI-assisted development tools)

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.