BI Senior Analyst

Role Context

We are looking for a Business Intelligence and Data Visualization specialist who will assist in the development and maintenance of the reporting infrastructure to help stakeholders gain insights in their advertising campaigns. In this role, he/she will be responsible for retrieving, compiling, and transforming and validating the data to build dashboards for various clients, leading to analysis and optimization of media investments.

Core Responsibilities

Data Integration and Transformation:

• Extract and integrate data from multiple platforms using tools like Super metrics, APIs, or FTP into Google BigQuery.
• Build and maintain automated data pipelines and workflows to ensure efficient and accurate data ingestion.
  
  

Data Analysis And Reporting

• Develop and maintain interactive dashboards and reports in Looker Studio or Power BI for visualizing key metrics.
• Structure and automate End-of-Campaign (EoC) reports for scalable reporting.
• Address ad hoc data requests and update dashboards based on evolving needs.
  
  

Data Validation And QA

• Ensure data accuracy by conducting QA between media platforms and reporting outputs using tools like SQL, Excel, and DAX.
• Identify and resolve data discrepancies, monitor data feeds for gaps or failures, and troubleshoot issues.
• Oversee QA processes for data provision to client data warehouses.
  
  

Taxonomy Governance And Collaboration

• Build & maintain taxonomy workflows to ensure adherence to naming conventions across all media channels.
• Collaborate with client teams to resolve data gaps and escalate issues as needed.
  
  

Required Skills / Experience

• Proven experience as a BI Analyst or similar role in data and analytics
• 2 – 4 years of work experience in data management, data visualization and data analytics preferably in a marketing and/or media agency.
• Experience with building dashboards in Looker Studio is a must; knowledge of visual techniques for data analysis and presentation is a plus,
• Experience with Looker BI for business logic design required.
• Experience with pipeline tools like Supermetrics/Adverity is required
• Experience working in Cloud environment (Google Cloud Platform),
• Experience working with SQL required, experience with Python a plus,
• Experience with the nuances of data granularity and limitations is required
• Not afraid to ask questions or seek clarity, while being confident in providing thoughtful answers
• Strong speaking and written professional communication skills,
• Strong analytical, critical thinking, and problem-solving skills,
• The ability to breakdown projects/requests and proactively action them
• The ability to thrive in a fast-paced and deadline-driven environment,
• Strategic Thinker & Doer,
• Curious and excited to learn,
• High sense of accountability and ownership,
• Collaborative with a partnership mindset.
  
  

requisitionid:42311