Data Analyst

About the Role

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

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

Qualification

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

Additional Information

Return to Office

Benefits

Diversity and Inclusion

About PubMatic

PubMatic is one of the world’s leading scaled digital advertising platforms, offering more transparent advertising solutions to publishers, media buyers, commerce companies and data owners, allowing them to harness the power and potential of the open internet to drive better business outcomes.

Founded in 2006 with the vision that data-driven decisioning would be the future of digital advertising, we enable content creators to run a more profitable advertising business, which in turn allows them to invest back into the multi-screen and multi-format content that consumers demand.