Analyst, BI

UNAVAILABLE; Bengaluru; On-site; INR 1,500,000 - 2,500,000; Full time

Benefits offered by this job

Group Personal Accident Cover & Life

Monthly Cross Team Lunch

Learning & Development budget

Employer-paid insurance for family

Job summary

Assembly is seeking a BI Specialist to join the Business Intelligence function. You will consolidate technical knowledge to develop consistent processes across the agency and support planning and management of digital marketing campaigns.

You will oversee integration of a client’s tech stack, work with activation and consultancy teams, and ensure data is utilized across reporting and forecasting. You will deliver cross-channel reporting, present insights to stakeholders, and help automate

Qualifications

• 3+ years of experience in dashboard production.
• Experience with data visualization and dashboarding tools such as Looker Studio, Tableau, Datorama, PowerBI.
• Experience using SQL and relational databases.
• Experience with Google Cloud Platform and BigQuery.
• Experience in BI or analytical/technical roles.
• Ability to analyze and present clear reports to stakeholders.

Responsibilities

• Create and deliver cross-channel dashboards and reports.
• Act as escalation point to support BI Execs with reporting issues.
• Present complex analyses to senior client stakeholders.
• Analyze client needs and develop insights from data.
• Collaborate with channel teams to extract insights and optimization opportunities.
• Assist Strategy/AM teams with analysis and data imports.

Skills

Dashboard production

Data visualization

SQL

Analytical thinking

Stakeholder reporting

Tools

Google Looker Studio

Tableau

Datorama

PowerBI

SQL databases

Google Cloud Platform

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 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; andWin 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 aBISpecialistto join the Business Intelligence function responsible forconsolidatingtechnical knowledge to develop consistent processes across the agency. The Functionis responsible formanaging data collection, analysis,insightand tech solutions for our digital marketing clients. The BI Function sits within the ClientTeamsand 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,forecastingand 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) toidentifyinsights 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'martechsetup
• Seek new ways to automate & streamline internal processes
• Deliver basic training sessions to more junior staff/wider business

Required Skills

• 3+ years of experience in Dashboardproducersrole.
• Experience with data visualisation and dashboarding tools such asGoogle Looker Studio,Tableau, Datorama,PowerBI
• Experience usingSQL and relational databases
• Experience working with GoogleCloudPlatformand 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.