Data & Automation Internship by Pilgrim

Data & Automation Internship

20 Apr 2026

Introduction

This content describes a focused set of work centered on data pulling, cleaning, and transformation from sources such as Excel sheets and BigQuery. It also includes building interactive dashboards in Power BI and/or Zoho Analytics, along with developing automation scripts using Python, Selenium, and Playwright. In addition, the work involves collaborating with internal teams to design and ship lightweight internal tools. The overall scope is practical, tool-based, and centered on turning data into usable outputs and internal solutions.


Data Pulling, Cleaning, and Transformation

The first part of the work focuses on pulling, cleaning, and transforming data. The sources named here are Excel sheets and BigQuery, which means the work begins with data coming from more than one place. The process is not only about collecting information, but also about preparing it so it can be used in later steps. That preparation is an important part of the workflow because raw data often needs to be cleaned and transformed before it becomes useful.

Working with Excel sheets and BigQuery suggests a need to handle data in different formats or environments. The content does not add more detail about the exact methods used, so the description stays at the level of the stated tasks. Still, the sequence is clear: data is pulled, then cleaned, then transformed. This order shows a structured approach to data handling rather than a single isolated action.

The emphasis on these tasks also shows that the work is built around making data ready for analysis and reporting. Cleaning and transformation are essential because they help shape the data into a form that can support dashboards, automation, and internal tools. In this way, the data work connects directly to the rest of the responsibilities. It is the foundation that supports the other outputs described in the content.

Core data sources mentioned

  • Excel sheets
  • BigQuery

Core data tasks mentioned

  • Pull data
  • Clean data
  • Transform data

Read More: Deloitte Australia | Data Analytics | Forage


Interactive Dashboards in Power BI and Zoho Analytics

A major part of the work is building interactive dashboards in Power BI and/or Zoho Analytics. This indicates that the cleaned and transformed data is used to create visual or interactive outputs. The content does not specify the exact dashboard features, so the focus remains on the stated goal: building dashboards that are interactive. That makes the dashboard work a direct extension of the earlier data preparation tasks.

The mention of Power BI and Zoho Analytics shows that the work can be done in one or both of these tools. Since the wording includes “and/or,” the content allows for either platform or both, without requiring one specific choice. The important point is that the dashboards are built in a business analytics context and are meant to be interactive. This makes them useful for presenting data in a way that can be explored rather than only viewed statically.

Interactive dashboards often sit between raw data and decision-making, and that is consistent with the rest of the content. The data is first prepared, then displayed through dashboards, and then supported by automation and internal tools. This creates a connected workflow where each part supports the next. The result is a practical data-focused process that turns source data into something easier to use and understand.

Dashboard tools mentioned

  • Power BI
  • Zoho Analytics

Dashboard outcome mentioned

  • Interactive dashboards

Read More: Free Microsoft Power BI Course with Certificate Online


Automation Scripts with Python, Selenium, and Playwright

Another key part of the work is developing automation scripts using Python, Selenium, and Playwright. This shows that the role includes scripting and automation, not only data handling and dashboard creation. The content does not describe the scripts in detail, so the safe interpretation is limited to the tools and the purpose stated. The purpose is clear: to automate tasks through scripts.

The three tools listed together suggest a workflow that relies on programming and browser automation. Python is named alongside Selenium and Playwright, which means the automation work is not tied to a single tool. Instead, the content presents a set of tools used for building scripts. This makes automation a distinct responsibility within the broader scope of the work.

Automation fits naturally with the other tasks described. Data is pulled and transformed, dashboards are built, and scripts are developed to automate work. The content does not say which tasks are automated, so no extra detail should be added. Even so, the presence of automation scripts indicates a practical approach to reducing manual effort and supporting repeatable processes.

Automation tools mentioned

  • Python
  • Selenium
  • Playwright

Automation output mentioned

  • Automation scripts

Read More: Free ChatGPT Tutorial


Collaboration and Lightweight Internal Tools

The final part of the content highlights collaboration with internal teams to design and ship lightweight internal tools. This shows that the work is not isolated. It involves working with others inside the organization to create tools that are useful internally. The phrase “design and ship” suggests that the work covers both planning and delivery, while “lightweight” indicates that the tools are intended to stay focused and practical.

Because the content does not describe the tools themselves, it is best to keep the description centered on the stated outcome. The tools are internal, which means they are meant for use within the organization rather than for external audiences. The collaboration aspect is also important because it connects technical work with team needs. That makes the role both technical and cooperative.

This chapter ties together the earlier parts of the content. Data work, dashboards, and automation all support the creation of internal tools. The tools likely benefit from cleaned data, visual reporting, and scripts, even though the content does not specify exact dependencies. What is clear is that the work aims to produce usable internal solutions through teamwork.

Collaborating with internal teams to design and ship lightweight internal tools is a stated part of the work.


Related Learning and Experience Links

The available internal links connect naturally to the themes in this content, especially data analytics, Power BI, and related learning paths. These links can help readers explore closely related topics without changing the meaning of the original content. The titles below are included exactly as provided, and only the listed URLs are used. No additional links are added beyond the available set.

Relevant internal links

The links above fit the content because they align with data analytics, dashboard work, and related learning or experience programs. They are presented as optional follow-up resources rather than as new claims about the work itself. The article remains limited to the content provided, while the links offer a way to continue exploring related topics.


Frequently Asked Questions

What kind of data work is described here?

The content describes pulling, cleaning, and transforming data. The named sources are Excel sheets and BigQuery. No additional data sources or methods are given, so the description stays focused on those tasks and those sources only.

Which dashboard tools are mentioned?

The content mentions Power BI and/or Zoho Analytics. The dashboards are described as interactive. No other dashboard tools or features are listed, so the answer is limited to those names and that outcome.

What automation tools are included?

The automation scripts are developed using Python, Selenium, and Playwright. The content does not explain the scripts in more detail, so only the tools and the fact that they are used for automation are included here.

Does the content mention collaboration?

Yes. It says the work includes collaborating with internal teams. The purpose of that collaboration is to design and ship lightweight internal tools. No further details about the teams or tools are provided.

Are there internal links related to this content?

Yes. The available internal links include titles related to Data Analytics, Power BI, ChatGPT, and Tata Free Data Analytics Virtual Experience Program 2026. Only the listed URLs are used, and no extra links are added beyond the provided set.

What is the overall focus of the content?

The overall focus is on a practical workflow that includes data preparation, interactive dashboards, automation scripts, and internal tools. The content presents these as connected responsibilities rather than separate unrelated tasks.


Conclusion

This content presents a clear, practical scope of work centered on data and internal solutions. It includes pulling, cleaning, and transforming data from Excel sheets and BigQuery, building interactive dashboards in Power BI and/or Zoho Analytics, and developing automation scripts with Python, Selenium, and Playwright. It also includes collaboration with internal teams to design and ship lightweight internal tools. Taken together, the content describes a workflow that turns data into useful outputs through analysis, automation, and teamwork.

Share this post –
Job Overview

Date Posted

April 6, 2026

Location

In-Office

Salary

Rs 15k-20k/Month

Expiration date

20 Apr 2026

Experience

Fresher

Gender

Both

Qualification

Any

Company Name

Pilgrim

Job Overview

Date Posted

April 6, 2026

Location

In-Office

Salary

Rs 15k-20k/Month

Expiration date

20 Apr 2026

Experience

Fresher

Gender

Both

Qualification

Company Name

Pilgrim

20 Apr 2026
Want Regular Job/Internship Updates? Yes No