Business Intelligence Data and Reporting Specialist

Job summary

You will own the deployment, maintenance, and quality assurance of approximately 100 client dashboards while managing complex data flows within BigQuery. Additionally, you will serve as the primary technical contact for account managers to resolve data anomalies and customize reporting metrics.

Job details

About the Job At Pilothouse, Data and Reporting Specialists are the backbone of our client performance visibility. This is not a passive reporting or entry-level data entry role. We are looking for someone who can manage complex data flows, bridge the gap between BigQuery architecture and Looker Studio dashboards, and ensure our internal teams have accurate, actionable data at all times. You will manage a portfolio of approximately 100 Looker Studio client reports, working within our established BigQuery data warehouse and template framework. Success in this role comes from maintaining high data integrity across a large client roster, swiftly actioning dashboard customization requests, and serving as a trusted internal advisor to account managers on platform and reporting logic. What You'll Do Own the deployment, maintenance, and QA of approximately 100 Looker Studio client dashboards at any given time, based on standardized agency templates Action internal requests from account teams to customize reports, add new charts, or adapt metrics to align with specific client goals Work within our existing BigQuery architecture to update variables, manage client rosters, map new fields, and integrate new ad platforms into existing pipelines Serve as the primary internal contact for account managers regarding reporting logic, data anomalies, and dashboard functionality Proactively monitor report performance and data flows to troubleshoot bugs and continuously refine reporting efficiency What We're Looking For 2+ years of experience in digital marketing analytics, performance reporting, or data management Strong hands-on proficiency in building and maintaining dashboards in Looker Studio (formerly Google Data Studio) Solid working knowledge of Google BigQuery and SQL to update mapping, manage variables, and troubleshoot data connections Solid understanding of digital marketing metrics and ad platform ecosystems (Meta, Google Ads, GA4, TikTok, Amazon, etc.) Hands-on experience with DevOps practices Proven experience with GCP (Google Cloud Platform) Demonstrated ability to manage high-volume deliverables (100+ reports) with acute attention to detail and accuracy Strong communication skills with the ability to explain technical reporting concepts clearly to non-technical account team members Experience working in an agency environment or handling multi-client reporting portfolios is highly preferred The Ideal Candidate You take pride in precision, speed, and clean organization. You can look at a broken report or a data mismatch, diagnose the root cause quickly in BigQuery or Looker Studio, and resolve it without disrupting upstream processes. You enjoy operating at the intersection of technical data structure and visual client presentation. You don't wait to be told when a metric looks off—you spot anomalies early, fix them, and keep account teams informed. Most importantly, you care about accuracy and operational reliability. About Pilothouse Pilothouse is one of North America's leading ecommerce growth agencies. We partner with ambitious consumer brands and manage tens of millions in monthly media spend across Meta, Google, Amazon, Email, CRO, Creative, and Analytics. Our model is built on alignment. We succeed when our clients grow. APPLICATION INSTRUCTIONS - friendly hint - don't miss this part ; ) Along with your resume, please submit a cover letter and a brief explanation of why you are interested in this position. Feel free to include an example of some of the awesome things you've done that make you stand out. We appreciate your time and thank all applicants for their interest, but we will only be responding to shortlisted applicants. BENEFITS Perks for our online team members: Benefits package through GroupSource after completion of the 3-month probationary period (CANADA ONLY) Fun virtual events - we host company events to focus on fun and growth Casual dress Work from home Flexible work schedule Perks for if you’re ever in town: Commuter-friendly - we have bike storage inside our office Dog friendly Beer on tap - cold, local beer waiting for you Compensation: $75,000 - $95,000 CAD annually

What you’ll do

You will own the deployment, maintenance, and quality assurance of approximately 100 client dashboards while managing complex data flows within BigQuery. Additionally, you will serve as the primary technical contact for account managers to resolve data anomalies and customize reporting metrics.

Requirements

Candidates must have at least 2 years of experience in digital marketing analytics with strong proficiency in Looker Studio and SQL. A solid understanding of ad platform ecosystems and Google Cloud Platform is required to manage high-volume reporting deliverables.

Benefits

• Health insurance
• Flexible work schedule
• Work from home
• Casual dress
• Company events

Listed skills

• SQL · Preferred
• data management · Preferred
• Performance Reporting · Preferred
• Google Cloud · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Looker Studio
• Google BigQuery
• SQL
• Digital marketing analytics
• Data management
• Performance reporting
• GCP
• DevOps
• Data integrity
• Dashboard maintenance
• Reporting logic
• Data troubleshooting
• Meta
• Google Ads
• GA4
• TikTok
• Performance Reporting
• Google Cloud Platform (GCP)
• Technology Ecosystems
• Analytics
• Dashboard
• Communication
• Data Entry
• Data Integrity
• Data Management
• Data Structures
• Data Warehousing
• Digital Marketing
• E-Commerce Management
• Refining
• Safety Assurance
• SQL (Programming Language)
• Troubleshooting (Problem Solving)
• Templates
• Detail Oriented
• Looker Analytics

Job areas

• Data & Analytics
• Marketing
• Technology
• Software
• Consulting
• Business Intelligence Data Analyst
• Marketing Analytics Specialist
• Advertising and Marketing Professionals
• Market Research Analysts and Marketing Specialists

More jobs from Pilothouse Digital