Business Intelligence Data and Reporting Specialist

🔥 36 minutes ago

🇨🇦 Canada – Remote

💵 $75k - $95k / year

⏰ Full Time

🟢 Junior

🟡 Mid-level

📚 Business Intelligence Analyst

🚫👨‍🎓 No degree required

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Pilothouse Digital

WebsiteLinkedInAll Job Openings

51 - 200 employees

📣 Marketing

🛍️ eCommerce

📱 Media

Marketing • eCommerce • Media

Pilothouse Digital is a full‑funnel performance marketing agency that partners with direct‑to‑consumer (DTC) and e‑commerce brands to scale acquisition and retention. They integrate strategy, creative production, media buying, and data/attribution to run omnichannel campaigns across Meta, Google, TikTok, YouTube, and Amazon, and provide email/SMS lifecycle marketing, conversion rate optimization, landing page design, and creative studios. Pilothouse positions itself as a growth partner that builds connected systems (not siloed tactics) to drive measurable revenue and lifetime value for established DTC businesses.

📋 Description

• Own the deployment, maintenance, and QA of approximately 100 Looker Studio client dashboards based on standardized agency templates • Action internal requests from account teams to customize reports, add new charts, or adapt metrics to specific client goals • Work within the 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 • Diagnose and resolve broken reports or data mismatches in BigQuery or Looker Studio without disrupting upstream processes • Spot anomalies early, fix them, and keep account teams informed

🎯 Requirements

• 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 • Ability to submit a resume, cover letter, and brief explanation of interest in the position

🏖️ Benefits

• 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 • Commuter-friendly - we have bike storage inside our office • Dog friendly • Beer on tap - cold, local beer waiting for you