# Ambuj Pandey

Ambuj Pandey is a remote worker on Himalayas, Associate Data Analyst at Tata Consultancy Services, based in India.

Source: https://himalayas.app/@ambujpandey1

```text
Data Analyst specializing in ETL, dashboards, and data quality in life sciences.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Data Analyst, Data Engineer, Business Intelligence Analyst, ETL Developer, Analytics Engineer, Dashboard Development Specialist, Data Analytics Specialist, Business Data Analyst, Data Analyst |
| Skills | Tableau, SQL, Python, Informatica, Snowflake, Databricks, Power BI, ETL, Data Quality, Data Governance, Dashboarding, Performance Optimization, Stakeholder Management, Problem Solving, Collaboration, Data Warehouse |

## What I'm looking for

```text
I seek a mid-level analytics role where I can build ETL pipelines, develop dashboards, improve data quality, and collaborate with cross-functional teams for measurable impact.
```

## About

```text
I am a Data Analyst with over 3.5 years of experience building scalable data pipelines and ETL workflows in the life sciences domain. I have hands-on expertise in SQL, Python, Tableau, Informatica, and Snowflake and a track record of delivering analytical solutions with 98% data accuracy.

I design and develop interactive dashboards, implement Tableau Server administration and row-level security, and optimize SQL back-end logic to improve load performance by 25%. I also automate data quality checks using Python and Informatica, cutting manual QA effort by 50% and reducing reporting effort by 70% on key projects.

I collaborate closely with cross-functional teams and stakeholders, applying data governance and performance optimization best practices while leveraging my SAFe 6.0 Agile certification to drive reliable, production-ready analytics solutions.
```

## Experience

### Associate Data Analyst (current)

[Tata Consultancy Services](https://himalayas.app/companies/tata-consultancy-services). Dec 2021 - Present

```text
Developed scalable ETL workflows and interactive Tableau dashboards for a life sciences client, achieving 98% data accuracy and reducing dashboard load times by 25% while cutting manual reporting effort by 70%.
```

Skills: SQL, Python, Tableau, Informatica, Snowflake, ETL, Data-Quality, Performance-Optimization, Data-Warehouse

## Education

### Deen Dayal Upadhyay Gorakhpur University

Bachelor of Science, Science

```text
Completed a Bachelor of Science degree focusing on foundational science coursework and quantitative skills relevant to data analysis.
```

## Tech stack

- AWS Glue
- NumPy
- Pandas
- Gmail
- Databricks
- Python
- scikit-learn
- Microsoft Excel
- SQL

To contact Ambuj, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Gaurav kumar](https://himalayas.app/@gauravkumar6): System Engineer Data Analyst/BI, Tata Consultancy Pvt. Ltd.
- [Sourav Bhowmick](https://himalayas.app/@souravbhowmick): Associate Data Analyst, MOL Information Technology
- [Payal Pawar](https://himalayas.app/@payalpawar): Data Analyst, Community Dreams Foundation
- [Swathi Chinnasamy](https://himalayas.app/@swathichinnasamy): Data Analyst, Self Employed
- [Yokeshvar S](https://himalayas.app/@yokeshvars): Data Analyst, Hy Vee
- [Rohan Peter Dabre](https://himalayas.app/@rohanpeterdabre): Data Analyst, ViewAnalytics
- [Aishwarya Tiwari](https://himalayas.app/@aishwaryatiwari1): Freelance Data Analyst, Freelance
- [Sakshi Chavan](https://himalayas.app/@sakshichavan2): Data Analyst, Tata Consultancy Services
- [Mansi Somani](https://himalayas.app/@mansisomani): BI Engineering Analyst, Accenture
- [sivaleela Tella](https://himalayas.app/@sivaleelatella): Data Analyst & BI Developer, Wells Fargo International Pvt Ltd
