BI Senior Analyst

As a Business Intelligence and Data Visualization specialist, your role will involve assisting in the development and maintenance of the reporting infrastructure to provide insights for advertising campaigns. You will be responsible for retrieving, compiling, transforming, and validating data to create dashboards for clients, leading to the analysis and optimization of media investments. **Core Responsibilities:** - **Data Integration and Transformation:** - Extract and integrate data from multiple platforms using tools like Supermetrics, APIs, or FTP into Google BigQuery. - Build and maintain automated data pipelines and workflows for efficient and accurate data ingestion. - **Data Analysis And Reporting:** - Develop and maintain interactive dashboards and reports in Looker Studio or Power BI to visualize 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 a Cloud environment (Google Cloud Platform). - Experience working with SQL required, experience with Python is a plus. - Experience with the nuances of data granularity and limitations is required. - Strong speaking and written professional communication skills. - Strong analytical, critical thinking, and problem-solving skills. - The ability to break down projects/requests and proactively address 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.,