Senior Data Analyst

Brandtech+ (formerly known as OLIVER+) is a global team of creative thinkers, tech-savvy trendsetters, and production pros specialising in film, CGI, automation, AI, motion design, and digital/print content. We partner with over 300 clients in 40+ countries and counting. Our focus is to connect clients with high-quality solutions, talent and ambitious opportunities worldwide.

As a part of The Brandtech Group, we're at the forefront of leveraging cutting-edge AI technology to revolutionise how we create and deliver work. Our AI solutions enhance efficiency, spark creativity, and drive insightful decision-making, empowering our teams to produce innovative and impactful results.

Role: Data Analyst – Management Information

Location: India (Remote)

A little bit about the role:

We are seeking a Management Information Data Analyst with advanced AI skills who can utilize machine learning models to optimize SQL query development and dataset management. The ideal candidate should be well-versed in data visualization tools such as ZOHO and Power BI, with a proven ability to create compelling reports and dashboards according to specific requirements. This role requires a strong aptitude for interrogating and validating data, working collaboratively with stakeholders to ensure data integrity.

As a subject matter expert, you will propose innovative methods for presenting key metrics to stakeholders, ensuring clear and impactful communication of data-driven insights. You should have excellent verbal and written English skills to facilitate client interactions as needed. Additionally, you will support teams by preparing PowerPoint presentations for monthly MI reports, Quarterly Business Reviews, and handling various ad hoc reporting requests.

What you'll be doing:

• Design and execute custom SQL queries to resolve complex data inquiries and integrate AI into daily business operations.

• Develop reports and management information (MI) dashboards that adhere to project briefs and client key performance indicators (KPIs), utilizing tools such as PowerPoint, ZOHO Analytics, and Microsoft Power BI.

• Collaborate with the account team to ensure data integrity and maintain accurate MI data.

• Apply best practices to guarantee complete data capture for effective KPI measurement.

• Analyse and present data to fulfil stakeholder requirements, ensuring insights are clear and actionable.

• Understand and collaborate with clients to deliver tailored solutions that meet their specific needs.

• Attain proficiency in our proprietary tools, including OMG and the AI Sandbox.

• Grasp diverse client business models to improve the relevance and quality of provided reports.

• Manage and maintain the client-facing dashboard on a daily basis.

• Conduct data impact analysis to assess changes and their implications.

• Set up and deliver weekly and monthly reports and MI packs.

• Oversee data hygiene management to ensure data cleanliness and track any issues.

What you'll need:

• Strong problem-solving skills and experience in client-facing roles.

• Exceptional attention to detail and accuracy.

• Ability to work efficiently in a fast-paced environment with excellent time management and prioritization skills.

• Competence in understanding requests and delivering insightful reports.

• Experience in handling large and complex datasets.

• Advanced skills in Excel, including pivot tables, complex formulas (such as VLOOKUPs and nested IF statements), and proficiency with Power Query and Python for Excel.

• Proficiency in data visualization tools like ZOHO and Power BI.

• Competency in SQL and Python programming languages.

• Proficiency in utilizing AI technologies and various large language models (LLMs) to enhance role efficiency.

• Experience in agency and marketing environments is an advantage.

• Confidence in engaging effectively with senior internal and external stakeholders.

Our values shape everything we do:

Be Ambitious to succeed

Be Imaginative to push the boundaries of what's possible

Be Inspirational to do groundbreaking work

Be always learning and listening to understand

Be Results-focused to exceed expectations

Be actively pro-inclusive and anti-racist across our community, clients and creations

Brandtech+, a part of the Brandtech Group, is an equal opportunity employer committed to creating an inclusive working environment where all employees are encouraged to reach their full potential, and individual differences are valued and respected. All applicants shall be considered for employment without regard to race, ethnicity, religion, gender, sexual orientation, gender identity, age, neurodivergence, disability status, or any other characteristic protected by local laws.

Brandtech+ has set ambitious environmental goals around sustainability, with science-based emissions reduction targets. Collectively, we work towards our mission, embedding sustainability into every department and through every stage of the project lifecycle.'