Looker Studio Expert

Key Responsibilities Marketing Performance Analytics * Analyze Store performance across multiple digital marketing channels including paid media, CRM, email, social, affiliate, and product marketing. * Identify trends, anomalies, and performance drivers impacting business KPIs. * Answer ad hoc business questions using data-driven analysis. * Translate quantitative findings into strategic recommendations. ⸻ Reporting & Dashboard Development * Design, develop, and maintain executive dashboards and recurring performance reports. * Consolidate data from multiple marketing platforms into unified reporting solutions. * Create scalable reporting frameworks that improve consistency and visibility across teams. * Present insights through clear visualizations and business narratives. ⸻ Data Analysis * Write and optimize SQL queries to extract, transform, validate, and analyze large datasets. * Perform data quality validation and investigate reporting discrepancies. * Utilize window functions, joins, aggregations, CTEs, and other advanced SQL techniques. * Support ongoing analysis using scripting and analytical tools when appropriate. ⸻ Reporting Automation One of the team’s major initiatives is reducing manual reporting through automation. Responsibilities include: * Automating recurring reports * Streamlining reporting workflows * Improving reporting efficiency * Eliminating repetitive manual processes * Building reusable reporting pipelines * Developing scalable analytical solutions ⸻ Stakeholder Collaboration Partner closely with * Marketing Managers * Product Marketing * Performance Marketing * Digital Marketing teams * Business stakeholders * Executive leadership Responsibilities include * Understanding business questions * Defining reporting requirements * Presenting analytical findings * Explaining the “why” behind performance changes * Influencing business decisions through data ⸻ Required Qualifications * Strong SQL experience * Experience building dashboards from scratch * Data visualization experience (Looker Studio, Power BI, Tableau, or similar) * Strong analytical and problem-solving skills * Experience translating technical findings into business insights * Excellent communication and presentation skills * Experience working with cross-functional stakeholders ⸻ Preferred Qualifications * Google BigQuery * Google Looker Studio * Google Analytics * Python or R for automation * Marketing analytics * ETL or data transformation experience * Executive reporting * KPI framework development * Reporting automation ⸻ Technical Skills * SQL * BigQuery * Looker Studio * Google Sheets * Excel * Power BI (preferred transferable experience) * Data Visualization * Reporting Automation * Data Validation * Business Intelligence * Dashboard Development