Data Analyst, Sr

Transformcap; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Health Catalyst is seeking a Senior Data Analyst to design, optimize, and support enterprise data pipelines and reporting solutions. The role emphasizes SQL, Python, ETL development, and data engineering practices within a fast-paced healthcare data environment.

The candidate will work with large-scale data processing systems, relational databases, and BI tools, coordinating with US-based clients and cross-functional teams to deliver scalable data solutions and governance across multiple systems.

Qualifications

• 5+ years of relevant industry experience in software engineering, ETL, or data engineering roles.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.

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.

Skills

SQL expertise

Python scripting

ETL tooling

Data visualization

Communications

Education

Bachelor's degree in CS/IT/Engineering

Tools

Pentaho Data Integration

Power BI

Tableau

SSRS

Job description

Join one of the nation’s leading and most impactful health care performance improvement companies.

Over the years, Health Catalyst has achieved and documented clinical, operational, and financial improvements for many of the nation’s leading healthcare organizations. We are also increasingly serving international markets.

Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement through:

• Data: integrate data in a flexible, open & scalable platform to power healthcare’s digital transformation
• Analytics: deliver analytic applications & services that generate insight on how to measurably improve
• Expertise: provide clinical, financial & operational experts who enable & accelerate improvement
• Engagement: attract, develop and retain world-class team members by being a best place to work

Job Summary

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..

The above statements describe the general nature and level of work being performed in this job function. They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.

Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position.

At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.