Business Intelligence Data and Reporting Specialist

This is a fully remote position, open to applicants in Canada.

📋 Description

• Take charge of the deployment, maintenance, and quality assurance of around 100 Looker Studio client dashboards that follow standardized agency templates.

• Address internal requests from account teams to tailor reports, incorporate new charts, or adjust metrics to meet specific client objectives.

• Operate within the established BigQuery framework to modify variables, manage client rosters, map new fields, and integrate additional ad platforms into existing pipelines.

• Act as the primary internal liaison for account managers concerning reporting logic, data discrepancies, and dashboard functionality.

• Proactively oversee report performance and data flows to identify and troubleshoot bugs, while continuously enhancing reporting efficiency.

• Identify and resolve issues with broken reports or data inconsistencies in BigQuery or Looker Studio without disrupting upstream processes.

• Detect anomalies early, rectify them, and keep account teams updated.

⛳️ Requirements

• Minimum of 2 years of experience in digital marketing analytics, performance reporting, or data management.

• Strong hands-on expertise in creating and maintaining dashboards in Looker Studio (formerly Google Data Studio).

• Comprehensive knowledge of Google BigQuery and SQL for updating mappings, managing variables, and troubleshooting data connections.

• Solid understanding of digital marketing metrics and the ad platform ecosystems (Meta, Google Ads, GA4, TikTok, Amazon, etc.).

• Practical experience with DevOps methodologies.

• Proven track record with Google Cloud Platform (GCP).

• Demonstrated capability to manage high-volume deliverables (over 100 reports) with meticulous attention to detail and accuracy.

• Excellent communication skills, with the ability to clearly articulate technical reporting concepts to non-technical account team members.

• Experience in an agency setting or managing multi-client reporting portfolios is highly desirable.

• Must be able to submit a resume, cover letter, and a brief explanation of interest in the role.

🏝️ Benefits

• Benefits package available through GroupSource after the completion of the 3-month probationary period (CANADA ONLY).

• Enjoy fun virtual events - we host company events that emphasize enjoyment and growth.

• Casual dress code.

• Opportunity to work from home.

• Flexible working hours.

• Commuter-friendly options, including bike storage inside our office.

• Dog-friendly workplace.

• Beer on tap - enjoy cold, local beer waiting for you.