Data Analyst, Senior (SQL, ETL, Python)

Health Catalyst; Hyderabad; On-site; INR 1,500,000 - 2,200,000; Full time

Job summary

Health Catalyst is seeking a Senior Data Analyst to design and optimize enterprise data pipelines and reporting solutions. The role emphasizes SQL, Python automation, and ETL development, with interaction across global teams and US-based stakeholders.

Ideal candidates will have hands-on experience with large-scale data processing, MSSQL/MySQL, Pentaho, and BI platforms, in a healthcare-oriented environment.

Qualifications

• Hands-on experience designing scalable ETL pipelines and data integration workflows.
• Strong SQL skills with performance tuning in MSSQL and MySQL.
• Python scripting for automation and data processing.
• Experience with Power BI or Tableau for dashboards and reporting.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines and data integration workflows.
• Develop and optimize complex SQL queries, stored procedures, views, and database objects.
• Work with ETL tools such as Pentaho for data ingestion and orchestration.
• Build Python-based automation scripts and data processing utilities.
• Create dashboards and reports using Power BI or Tableau.
• Analyze performance bottlenecks in SQL, ETL jobs, and reporting systems.
• Collaborate with cross-functional teams to gather data requirements.
• Communicate with US-based clients to understand requirements and provide updates.
• Maintain data quality, governance, and production runbooks.

Skills

SQL (MSSQL)

SQL (MySQL)

Python scripting

ETL tools

Power BI / Tableau

Data engineering

Communication

AWS / Cloud

Education

Bachelor's degree in CS/IT/Engineering

Tools

Pentaho Data Integration

SSRS

Job description

We are looking for a highly motivated and experienced Senior Data Analyst with strong expertise in SQL, Python, ETL development, and data engineering practices. The ideal candidate will have hands‑on experience working with large-scale data processing systems, relational databases, ETL tools, reporting platforms, and Python-based automation solutions.

The role involves designing, developing, optimizing, and supporting enterprise data pipelines, reporting solutions, and database-driven applications in a fast-paced environment. The candidate will also be expected to work closely with US-based clients and stakeholders, requiring strong communication and collaboration skills. Experience in the healthcare domain is a plus.

Key Responsibilities

• Design, develop, and maintain scalable ETL pipelines and data integration workflows.
• Develop and optimize complex SQL queries, stored procedures, views, and database objects in MSSQL and MySQL.
• Work with ETL tools such as Pentaho or equivalent technologies for data ingestion, transformation, and orchestration.
• Build Python-based automation scripts and data processing utilities.
• Create and maintain dashboards and reports using reporting tools such as Power BI, Tableau, or equivalent platforms.
• Analyze and troubleshoot performance bottlenecks in SQL queries, ETL jobs, and reporting systems.
• Collaborate with cross-functional teams including business analysts, QA teams, and stakeholders to gather and implement data requirements.
• Communicate effectively with US-based clients to understand requirements, provide updates, and resolve technical issues.
• Participate in client discussions, status meetings, and technical walkthroughs.
• Ensure data quality, integrity, and governance across multiple systems.
• Participate in code reviews, deployment activities, and production support.
• Contribute to system architecture discussions and technical design decisions.
• Maintain technical documentation and operational runbooks.

Required Skills

• Strong expertise in SQL (MSSQL and MySQL).
• Hands‑on experience with Pentaho Data Integration (PDI) or equivalent ETL tools.
• Experience in Python scripting, automation, and data processing.
• Experience with reporting tools such as Power BI, Tableau, SSRS, or equivalent.
• Strong understanding of SQL query optimization and database performance tuning.
• Excellent verbal and written communication skills.
• Understanding of AWS services and cloud-based data processing concepts.
• Experience communicating with US-based clients and working in global delivery environments.

Good to Have

• Basic healthcare domain knowledge.
• Experience with cloud platforms such as AWS or Azure.
• Understanding of data warehousing concepts.

Experience Required

5+ years of relevant industry experience in software engineering, ETL, or data engineering roles.

Educational Qualification

Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.

• Equal Employment Opportunity has been, and will continue to be, a fundamental principle at Health Catalyst, where employment is based upon personal capabilities and qualification without discrimination or harassment on the basis of race, color, national origin, religion, sex, sexual orientation, gender identity, age, disability, citizenship status, marital status, creed, genetic predisposition or carrier status, sexual orientation or any other characteristic protected by law.. Health Catalyst is committed to a work environment where all individuals are treated with respect and dignity..