Data Analyst

  • Aundh, Pune, India
  • Full-time
  • Department: Finance

Company Description

PubMatic (Nasdaq: PUBM) is an independent technology company maximizing customer value by delivering digital advertising’s supply chain of the future. PubMatic’s sell-side platform empowers the world’s leading digital content creators across the open internet to control access to their inventory and increase monetization by enabling marketers to drive return on investment and reach addressable audiences across ad formats and devices. Since 2006, our infrastructure-driven approach has allowed for the efficient processing and utilization of data in real time. By delivering scalable and flexible programmatic innovation, we improve outcomes for our customers while championing a vibrant and transparent digital advertising supply chain.

Job Description

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 best fit for the role.


  • 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.
  • 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 preparation of monthly publisher statements, tools that will improve productivity and the revenue yield generated for our publishers. 


  • Preferred Qualifications: Graduation in Math, Statistics, Science or Engineering
  • 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

Technical Skills:

  • MS Office products including strong grasp of Excel (Charting, Formulae, Pivots),
  • Advance Excel/Access: VB Macros in Excel and MS Access
  • VBA programming exposure is a plus
  • MS-SQL / MySQL
  • Hands on experience on Hive Database / Data Analytics tools
  • Added advantage if hands on experience in HTML / PHP / Java Script / Python


General attributes:

  • Any graduation, as specified by role, with good academic record / Masters is a plus
  • Total work experience of 3 to 5 years in a fast paced change-oriented environment
  • Worked in shifts interacting with US or UK clientele / vendors
  • Logical reasoning ability, problem solving and analytical mindset
  • Pro-active, quick learning, detail oriented
  • Excellent written and spoken English with ability to handle communication across levels


Additional Information

Return to Office: PubMatic employees throughout the global have returned to our offices via a hybrid work schedule (3 days “in office” and 2 days “working remotely”) that is intended to maximize collaboration, innovation, and productivity among teams and across functions. All PubMatic employees in the US and India are required to be fully vaccinated to return to our offices. Covid-19 boosters are not required at this point in time.

Benefits: Our benefits package includes the best of what leading organizations provide, such as stock options, 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.