Remote BI Lead: Looker Studio Dashboards & 100+ Reports

Pilothouse Digital; Canada; Hybrid; CAD 75,000 - 95,000; Full time

Benefits offered by this job

GroupSource benefits

Virtual events

Work from home

Bike storage

Beer on tap

Job summary

Pilothouse is seeking a Data and Reporting Specialist to manage approximately 100 Looker Studio dashboards within our BigQuery data warehouse, delivering accurate, actionable data for internal teams. You will tailor reports to client goals, update mappings, monitor data quality, and serve as the go-to resource for account managers on reporting logic and data integrity.

This is not an entry-level role; you will own end-to-end dashboards from deployment to QA, ensuring reliability across a large

Qualifications

• 2+ years in digital marketing analytics or data management
• Proficient in building dashboards in Data Studio Pro
• Strong SQL and BigQuery skills
• Understanding of digital marketing metrics and ad platforms
• Experience with DevOps practices is a plus
• Experience with Google Cloud Platform (GCP)
• Experience managing 100+ reports with attention to accuracy
• Ability to communicate complex data concepts to non-technical teammates
• Agency environment or multi-client reporting experience preferred

Responsibilities

• Own deployment, maintenance, and QA of ~100 Looker Studio dashboards
• Handle internal requests to customize reports and metrics
• Update mappings, manage variables, and integrate new ad platforms in BigQuery
• Serve as main internal contact for account managers on reporting logic
• Monitor report performance and troubleshoot data flows

Tools

Data Studio Pro

BigQuery

Job description

Pilothouse is seeking a Data and Reporting Specialist to manage approximately 100 Looker Studio dashboards within our BigQuery data warehouse, delivering accurate, actionable data for internal teams. You will tailor reports to client goals, update mappings, monitor data quality, and serve as the go-to resource for account managers on reporting logic and data integrity.

This is not an entry-level role; you will own end-to-end dashboards from deployment to QA, ensuring reliability across a large