Data Analyst | 2- 3 Yrs | Media /Advertisement Domain | Remote

Bandhan Technologies Private Limited; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Bandhan Technologies Private Limited is seeking a Senior Analyst to own the reporting layer for client accounts, building and evolving dashboards that translate paid media data into actionable insights. You’ll be on calls, explaining methodology and ensuring accuracy with analytics leads, media strategists, and platform specialists.

You’ll design scalable reporting frameworks, work with SQL, Python, and BI tools, and help streamline pipelines while maintaining QA and clear client communication.

Qualifications

• 2–3 years of experience in data, analytics, or reporting
• Proficiency in a modern BI/dashboarding tool and building dashboards from scratch
• Strong SQL skills with joins, aggregations, window functions, and debugging
• Hands-on experience with paid media data from at least two platforms
• Working knowledge of Python for data wrangling and automation
• Understanding of core media metrics (impressions, CPM, ROAS, CPA, etc.)
• Attention to detail and a QA mindset
• Comfort communicating directly with clients

Responsibilities

• Build and maintain client-facing dashboards translating multi-platform media data into performance views
• Own the reporting cadence: weekly pacing, monthly summaries, ad hoc analyses
• Design scalable reporting frameworks
• Document data logic and methodology for auditable outputs

Skills

SQL

Python

Client communication

QA & data validation

Tools

Tableau

Snowflake

dbt

Alteryx

Job description

THE ROLE

We're looking for a Senior Analyst who can own the reporting layer for a set of client accounts — building, maintaining, and evolving dashboards and performance reports that translate media data into actionable intelligence. You’re fluent in SQL, comfortable in a modern BI/dashboarding tool, and have firsthand experience working with the messy, multi-platform reality of paid media data.

This is a client-facing role, which means you’ll be on calls, in meetings, and occasionally explaining methodology to people who care deeply about the numbers. You’ll work closely with analytics leads, media strategists, and platform specialists to make sure the reporting picture is accurate, complete, and useful.

WHAT YOU’LL DO

Reporting & Visualization

• Build and maintain client-facing dashboards in our BI/dashboarding environment, translating multi-platform media data into clean, navigable performance views
• Own the reporting cadence for assigned accounts: weekly pacing reports, monthly performance summaries, and ad hoc analyses as needed
• Design reporting frameworks that scale — not one-off builds that only you can maintain
• Document data logic, calculated fields, and methodology so outputs are auditable and explainable

Data Engineering & Pipeline Work

• Be comfortable with adjusting SQL queries and using natural language LLM inqueries against our cloud data warehouse to pull, clean, and structure media performance data for reporting
• Contribute to the ongoing work of streamlining and centralizing our reporting pipelines
• Partner with our teams to use AI and Python for data transformation, automation, or light analytical tasks where SQL alone isn’t the right tool
• QA your own work and flag data integrity issues proactively — you’re a first line of defense before numbers reach clients

Media Data & Platform Fluency

• Work directly with data from major ad platforms across paid social, paid search, programmatic, and emerging channels
• Understand the measurement nuances of paid media data — attribution windows, modeled vs. observed conversions, platform discrepancies
• Collaborate with activation and strategy teams to ensure reporting reflects actual media executions accurately
• Stay current on platform reporting changes (API updates, measurement shifts, new ad types) and adjust accordingly

Client Engagement

• Participate in client calls and reporting presentations, fielding questions about data sources, methodology, and performance trends
• Translate technical data issues into plain-language explanations for non-technical stakeholders
• Identify patterns in performance data worth flagging or investigating, not just reporting what’s already obvious

WHAT YOU BRING

Required

• 2–3 years of experience in a data, analytics, or reporting role, ideally at a media agency, ad tech company, or in-house media team
• Proficiency in a modern BI/dashboarding tool: you can build production-quality dashboards from scratch, not just modify existing templates
• Strong SQL skills: comfortable with joins, aggregations, window functions, and debugging queries against large tables
• Hands‑on experience with paid media data from at least two major advertising platforms (across paid social, paid search, programmatic, or similar)
• Working knowledge of Python for data wrangling, automation, or analysis
• Understanding of core media metrics and how they are measured differently across platforms (impressions, CPM, ROAS, CPA, viewability, etc.)
• Strong attention to detail and a compulsion to QA your own work before it goes out the door
• Comfortable communicating directly with clients and explaining data clearly

Preferred

• Experience with Snowflake or another cloud data warehouse
• Familiarity with Alteryx, dbt, or similar data prep or transformation tools
• Exposure to attribution and measurement platforms (e.g., Northbeam, Triple Whale, Measured, Nielsen)
• Experience with data visualization tools such as Tableau
• Comfort using AI coding tools (Claude, Copilot, ChatGPT) to accelerate SQL writing, debugging, or Python work

WHAT TO EXPECT

You’ll join a small, high-accountability team where the work is visible and the feedback is direct. Our clients are engaged and expect accuracy — which means the reporting layer you own actually matters. You’ll have room to grow: as our capabilities expand and we standardize how reporting is delivered, there are real opportunities to take on more ownership, more complexity, and more client exposure over time.