Senior Analyst, BI

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

Benefits offered by this job

Annual Leave 15 days

Sick Leave 12 days

Maternity/Paternity Leave

L&D Budget

Group Personal Accident & Life Cover

Family Insurance

Monthly Cross Team Lunch

Recognition program

Job summary

Assembly Global in Bengaluru is seeking a Senior BI Specialist to consolidate data knowledge and drive standardized reporting for digital marketing campaigns. You will oversee data integration with client tech stacks and collaborate with activation and consulting teams to maximize data use across reporting, forecasting and planning.

The role requires strong SQL, data visualization, and GCP expertise, with the ability to present insights clearly to senior stakeholders.

Qualifications

• 5+ years in a dashboard producer role.
• Proficient with data viz and dashboards tools: Looker Studio, Tableau, Datorama, Power BI.
• Experience using SQL and relational databases.
• Experience with Google Cloud Platform and BigQuery.
• BI role background with strong analytical/reporting skills.
• Ability to present insights clearly to stakeholders.

Responsibilities

• Create and deliver cross-channel reporting and dashboards.
• Escalation point to support Activation and BI Execs on reporting issues.
• Present complex analysis to senior client stakeholders.
• Analyze client needs and carry out insights-based investigations.
• Understand data nuances and martech setups.
• Collaborate with Channel Teams to identify insights and optimization opportunities.
• Support Strategy/AM teams with analysis.
• Assist with client data imports and internal tech processes.
• Research martech stacks and seek automation opportunities.
• Deliver basic training to junior staff.

Skills

Dashboard producer

Data visualization tools

SQL & relational databases

Google Cloud & BigQuery

BI experience

Insight presentation

Tools

Looker Studio

Tableau

Datorama

Power BI

SQL

BigQuery

Job description

About Us

At Assembly, we help brands find the change to fuel business growth. We are an award-winning global brand performance agency, home to 1,600 talented people across 25 offices globally. We create unique data, technology and media solutions that enable faster and smarter problem solving and an inspired, collaborative workplace culture.

At Assembly, we help brands find the change to fuel business growth. We are an award-winning global brand performance agency, home to 1,600 talented people across 25 offices globally. We create unique data, technology and media solutions that enable faster and smarter problem solving and an inspired, collaborative workplace culture.

At Assembly we embody three core values: Show Up - actively contribute to a space of personal and collective growth; Make Change - embrace obstacles as opportunities, taking intentional steps to drive positive change; and Win Well - approach success with integrity, responsibility, and a commitment to collaboration, understanding that the journey is as important as the destination. Together, we create an environment that fosters continuous learning, adaptability, and a shared passion for making a meaningful impact.

We stay ahead of what’s next, providing fresh insights to spark new ideas. We’re a trusted partner to our clients, working behind the scenes to bring imagination, depth, and clarity to their biggest challenges—in entertainment, technology, lifestyle, sports, and gaming. Together, we create with confidence

Overview

We're looking for a Senior BI Specialist to join the Business Intelligence function responsible for consolidating technical knowledge to develop consistent processes across the agency. The Function is responsible for managing data collection, analysis, insight and tech solutions for our digital marketing clients. The BI Function sits within the Client Teams and this role will be to support the planning and management of digital marketing campaigns.

Internally you will oversee the integration of a client’s technology stack into our own systems and processes, working alongside activation and consultancy teams to ensure this data is being correctly utilised across reporting, analysis, forecasting and planning.

Responsibilities

• Creation and delivery of ongoing cross-channel reporting including building new reports and reporting dashboards to brief
• Act as point of escalation to support Activation and BI Execs in solving reporting issues
• Presenting complex analysis to senior client stakeholders
• Carry out analysis based on clients' needs.
• Develop an understanding of the nuances of data available to us.
• Work alongside Channel Teams (PPC/Paid Social etc) to identify insights from reporting data and optimisation opportunities
• Support Strategy/AM teams by providing analysis where needed
• Support with client data imports
• Support on all internal tech processes
• Research & build understanding of clients’ martech setup
• Seek new ways to automate & streamline internal processes
• Deliver basic training sessions to more junior staff/wider business

Required Skills

• 5 + years of experience in Dashboard producers role .
• Experience with data visualisation and dashboarding tools such as Google Looker Studio, Tableau, Datorama, PowerBI
• Experience using SQL and relational databases
• Experience working with G oogle C loud P latform and handling Big Query tables
• Experience within a BI role or a role utilising strong analytical and technical skills
• Experience analysing and understanding business insights with the ability to develop and present clear and insightful reports to stakeholders

Desirable

• Experience in the digital marketing industry with an understanding of channel-based activation (PPC, SEO, Display / Programmatic, Social, etc.)
• Knowledge of Python or other coding languages
• Experience using statistical analysis to provide insights (e.g. linear regression)

Benefits

• Annual Leave in number of 15 allotted to all employees beginning of every calendar year.
• Sick Leave in number of 12 is allotted effective DOJ and beginning of ever calendar year.
• Other Leaves-Maternity Leave & Paternity Leaves, Birthday Leave Entitlement
• Dedicated L&D Budget for all Teams to upskill & get certified
• All employees are entitled for Group Personal Accident Cover & Life Cover Insurance.
• Insurance coverage for the entire family (Employee + up to 7 dependents - Self, Spouse, up to 4 children, and Parents)
• Monthly Cross Team Lunch
• Rewards and Recognition program-Employee of the month, Star Performer, Tenure Celebration & many more

Equal Opportunities

Assembly is an advocate for equal opportunity in the workplace. We are committed to ensuring equal opportunities regardless of race, colour, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability and gender identity. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires accommodation, please let us know.

Social and Environmental Responsibility

At Assembly, we have a responsibility to bring impact into our every day. This means we must always look for ways in which to be conscious citizens in our roles to support society and environmental sustainability. We encourage employees to; be a conscious citizen by actively participating in our organisation's sustainability efforts, help us promote environmentally friendly practices within the workplace, collaborate with community organisations and stakeholders to support initiatives aligned with our company's values, participate in volunteer activities that benefit the community. Employees are also encouraged to make suggestions and evaluate our business practices to identify areas for improvement in social and environmental performance. Employees at Assembly demonstrate commitment to sustainability and inclusivity in their actions and behaviors.