Advertising ops specialist, IN Advertising

Amazon; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Benefits offered by this job

Equal opportunity employer

Inclusive culture

Opportunity for personal growth

Job summary

A leading technology firm in India is looking for an Advertising Ops Specialist to provide operational support for its Ads team. You will automate reporting and resolve data issues while ensuring operational continuity. The ideal candidate has a bachelor's degree in a relevant field and proficiency in SQL and Excel VBA. Experience with BI tools like Tableau and Salesforce is preferred. This role offers a collaborative environment focused on driving innovation in advertising products.

Qualifications

• 2+ years of technical work experience or relevant Bachelor's degree.
• Knowledge of writing and optimizing SQL queries in a business environment.
• Experience with Excel including macros, pivots, and lookups.

Responsibilities

• Provide day-to-day operational support and triage incoming requests.
• Monitor operational health of reports and dashboards.
• Automate repetitive workflows using Excel VBA and SQL.

Skills

SQL querying

Excel VBA development

Data Visualization

Salesforce operational reporting

Education

Bachelor's degree in engineering, statistics, computer science, or equivalent

Tools

Quick Sight

Tableau

Power BI

Job description

Advertising ops specialist, IN Advertising

About the Team and the Role

Join the Amazon IN Ads team as a key operational partner to the Sales team. You will deliver accurate, scalable reporting, dash-boarding, and automation solutions while providing day-to-day support — triaging requests, resolving issues with minimal back-and-forth, and responding to incidents within defined SLAs. The role demands a first time-right mindset: translating sales team needs into reliable data outputs, automated workflows, and stable operations with minimum iterations. Core skills include hands‑on SQL querying, Excel VBA development, dash-boarding, and Salesforce operational reporting, with a sharp focus on eliminating manual toil, ensuring data accuracy at scale, and maintaining operational continuity.

Key job responsibilities

Day-to-Day Responsibilities

Provide day‑to‑day operational support, triage incoming requests, and respond to incidents within defined SLAs.

• Act as the first point of contact for data issues — ensuring timely resolution and stakeholder communication.
• Maintain and track incident logs, elevate where needed, and drive follow-through to closure.
• Monitor operational health of reports, dashboards, and automated workflows to proactively identify and resolve issues before they impact stakeholders.

A day in the life

• Automate repetitive workflows and reporting pipelines using Excel VBA macros, SQL stored procedures, and Salesforce Flows.
• Troubleshoot production data/reporting/dashboard issues, perform root cause analysis, and implement sustainable fixes to reduce recurring incidents and SLA breaches.
• Support operational processes including data uploads, bulk updates, and scheduled report distribution while monitoring system health.

Process Improvement

Identify automation opportunities by analyzing existing manual workflows, recurring incidents, and SLA patterns to propose automated workflows. Document all dashboards, reports, queries, macros, and workflows to ensure knowledge continuity and team scalability.

About the team

The Amazon India Ads business functions as a strategic start-up with support and interest from business units across the company as well as Amazon’s top management. We are investing heavily in building a world class advertising business and are responsible for defining and delivering a collection of advertising products that drive awareness, engagement, discovery and sales. We deliver billions of ad impressions and millions of clicks daily and are breaking fresh ground to create new, cutting edge ad products. We are highly motivated, collaborative and fun-loving with an entrepreneurial spirit and bias for action.

Basic Qualifications

• 2+ years of technical work experience, or Bachelor's degree in engineering, statistics, computer science, operations research, business analytics, information systems or equivalent
• Knowledge of writing and optimizing SQL queries in a business environment with large-scale, complex datasets
• Bachelor's degree in engineering, statistics or business, or a CPA and experience in Excel (macros, index, conditional list, arrays, pivots, lookups)
• Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
• Salesforce familiarity: working knowledge of Salesforce objects, reports, dashboards.

Preferred Qualifications

• Experience with business intelligence (BI) tools such as Tableau, Quicksight, Power BI and CRM Salesforce
• Experience implementing repeatable processes and driving automation or standardization

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.