Data Analyst at PubMatic | Pune

PubMatic; Pune District; On-site; INR 600,000 - 800,000; Full time

Benefits offered by this job

Healthcare insurance

Broadband reimbursement

Paternity/maternity leave

Healthy snacks and catered lunches

Job summary

PubMatic is hiring a Data Analyst to join the Finance Reporting & Insights team in Pune. The ideal candidate will excel in data analysis, utilizing tools like Excel and SQL to transform large data sets into actionable insights for the finance and operations teams.

Applicants should have 2+ years of experience, a background in Math or Statistics, and strong communication skills. The position promises a dynamic work environment with opportunities to collaborate and contribute towards productivity enhancements.

Qualifications

• Total work experience of 2+ years in a fast-paced environment.
• Familiarity with business analysis and revenue monitoring tools.
• Experience in MIS functions with independent analysis of data.

Responsibilities

• Collect and analyze large data sets using various tools.
• Develop spreadsheets and Excel macros for data analysis.
• Assist in preparing monthly publisher statements and improving tools.

Skills

Data analysis

Excel (advanced)

SQL

Business analysis

Problem-solving

Programming knowledge

Communication skills

VBA programming

Education

Graduation in Math, Statistics, Science, or Engineering

Master’s degree

Tools

Microsoft Excel

MS Access

Hive Database

Looker

BT tools

Job description

About The Role (Data Analyst)

PubMatic is looking for a sharp analytical individual to work as a Data Analyst in the Finance Reporting & Insights function. People with a penchant for extracting the truth out of numbers and summarizing it for the finance and operations teams would be the best fit for the role.

What You’ll Do as Data Analyst

• The Data Analyst will be responsible for collecting and analyzing tremendous data sets using tools such as Microsoft Excel, Access, SQL and Hive databases and presenting them in easy-to-understand formats, creating dashboards and visualizations in BI tools.
• The Data Analyst will be expected to retrieve data from publishers, ad networks & aggregators UI and develop spreadsheets and Excel macros to filter, analyze, generate reports, and draw conclusions from that data. It will be important to focus on the primary metrics while understanding the business requirements of the different teams within the business.
• Apart from reporting tasks, the Data Analyst will work closely with other functions in the Pune Billing Team to assist with the preparation of monthly publisher statements, tools that will improve productivity, and the revenue yield generated for our publishers.

We’d Love for You to Have

• Total work experience of 2+ years in a fast-paced, change-oriented environment.
• Worked in shifts, interacting with US or UK clientele/vendors.
• Exposure to business analysis, tracking metrics, and building revenue monitoring tools.
• Should be involved in MIS functions requiring independent analysis of data.
• Exposure to financial modeling and operations analysis is a plus.
• Basic knowledge of running MapReduce jobs in Hive databases.
• Basic programming knowledge.
• Logical reasoning ability, problem-solving, and analytical mindset.
• Pro-active, quick learning, detail-oriented.
• Excellent written and spoken English with the ability to handle communication across levels.
• Experience with MS Office products includes a strong grasp of Excel (Charting, Formulae, Pivots).
• Advanced Excel/Access: VB Macros in Excel and MS Access.
• VBA programming exposure is a plus.
• Experience with MS-SQL / MySQL.
• Hands-on experience with a BT tool, Looker preferred.
• Hands-on experience with Hive Database / Data Analytics tools.
• Added advantage if hands-on experience in HTML / PHP / JavaScript / Python.
• Shift Time: 5:00 PM to 2:00 AM IST.
• Working with knowledge in Chat GPT in Excel and Data Analysis.
• Use of Claude / Gemini for coding and automation, and a mindset that can leverage AI for a purpose.

Qualification

Graduation in Math, Statistics, Science, or Engineering with a good academic record. Master’s is a plus.

Benefits: Our benefits package includes the best of what leading organizations provide, such as paternity/maternity leave, healthcare insurance, broadband reimbursement. As well, when we’re back in the office, we all benefit from a kitchen loaded with healthy snacks and drinks and catered lunches and much more!

Diversity and Inclusion: PubMatic is proud to be an equal opportunity employer; we don’t just value diversity, we promote and celebrate it. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.