Data Architect (BigQuery / GCP)

• Location:  25 York Street, Toronto, Canada
• Vacancy:  This posting is for an existing open role at WildBrain’s Toronto office.   

Hybrid work: Employees work in a hybrid model balancing collaboration in our office and remote work. 

Find a job that lets your imagination run wild!  
WildBrain is made up of a team of innovators and creators who bring industry-leading kids’ content and brands to families globally. We inspire imagination, put creativity first and believe in the power of storytelling. We are constantly connecting the powers of our global team, making WildBrain a collaborative, openminded and passionate environment to work in. To work at WildBrain means you get to create stories that lets imaginations run wild. Join our team today and make us part of your story! 

About the program 

WildBrain is building an enterprise data warehouse on Google BigQuery as the single source of truth for financial and operational reporting across the business. The warehouse sits at the centre of our digital transformation, alongside a global ERP rollout (Microsoft Dynamics 365 Business Central with Binary Stream), a modern data pipeline stack, and an AI enablement agenda. The data platform is the foundation that the rest of the program depends on. 

About the Role  
We are looking for a hands-on BigQuery / GCP Architect — someone who will both design the enterprise data warehouse and write the code to bring it to life. This is explicitly not a "manager who reviews other people’s code" role. You will be in the platform every day — designing models, writing SQL and Python, building pipelines, setting the engineering standards others will follow, and lifting the bar on the platform team. 

Job Description

• Architect and build the enterprise data warehouse on BigQuery to support financial, operational, and management reporting. 
• Design the data model — raw, staging, curated, and semantic layers — and the standards that govern how new data lands and is transformed. 
• Hands-on build of pipelines from source systems (ERP, billing, HR, operational sources) into BigQuery. 
• Select and operate the right GCP services across the stack —Dataflow, Pub/Sub, Cloud Functions, Cloud Storage, Dataform / dbt. 
• Establish engineering standards — version control, CI/CD, testing, documentation, monitoring, lineage — and enforce them through code review. 
• Own data quality, freshness, observability, and cost optimization on BigQuery (partitioning, clustering, slot management). 
• Partner with finance and business stakeholders to translate reporting needs into durable models, not one-off extracts. 
• Lead by example — code reviews, architectural decision records, pairing, and lifting the team’s bar without becoming a bottleneck. 
• Establish data governance practices — IAM, access controls, PII handling, data classification, and audit. 
• Provide thought leadership on the path from a reporting warehouse to an AI-ready data foundation (feature stores, BigQuery ML, Vertex AI integration). 

Qualifications

What you’ll bring 

• Strong track record of building data platforms, with deep BigQuery and GCP in a hands-on capacity. 
• Expert-level SQL — you can write, optimize, debug, and explain anything in BigQuery, including window functions, complex joins, and cost-sensitive query patterns. 
• Strong Python for data engineering — pipelines, orchestration, testing, packaging. 
• Production experience with the modern GCP data stack — Cloud Composer (Airflow), Dataflow, Pub/Sub, Cloud Storage, Cloud Functions. 
• Production experience with dbt or Dataform for modelling and transformation. 
• Strong dimensional modelling background; data vault experience is a plus. 
• Experience designing warehouses for financial reporting — GL, sub-ledger, intercompany, consolidation. 
• Strong CI/CD discipline — Git, automated testing, deployment pipelines. 
• Ability to operate at architect altitude while still shipping code every week. 

Nice to have 

• Experience integrating Microsoft Dynamics 365 Business Central data into BigQuery. 
• Streaming pipeline experience (Pub/Sub, Dataflow streaming). 
• Looker, Power BI, or other semantic-layer experience. 
• Exposure to ML / GenAI on GCP — Vertex AI, BigQuery ML, embeddings 
• Experience standing up a brand new enterprise data platform from greenfield. 

Additional Information

What We Offer  

Working at WildBrain is more than a job — it’s the opportunity to join forces with extraordinary, insightful and imaginative people who will recognize your talents and encourage your professional growth and development in a work environment that promotes creativity and individuality.

Our Commitment  

Diversity and Inclusion are in our DNA. As a global leader in kids and family entertainment, we strive to reflect and honour the diversity of our audiences around the world. We believe that creating diverse and inclusive content & brands begins with fostering a culture of belonging at WildBrain. To us, a culture of belonging is one where we celebrate and welcome the diversity of all employees, stakeholders, and external partners and strive to create an environment where every individual feels valued, respected, and brings their authentic self to work.

We demonstrate our commitment to this by striving to provide a supportive work environment and a corporate culture that welcomes and encourages equal opportunities for all employees. We recognize that people bring experience and talent that goes beyond the technical skills and requirements of a job. If you possess similar experience that is close to what we’ve listed here, we encourage you to please still consider applying. We strongly believe that diverse experience, transferable skills, and passion are key! WildBrain accommodates people with disabilities throughout the recruitment and selection process. Applicants are encouraged to make their needs known in advance if accommodation is required. 

About WildBrain

At WildBrain, we build and grow beloved family brands through exceptional entertainment experiences. Home to franchises such as Strawberry Shortcake, Teletubbies, Yo Gabba Gabba!, Inspector Gadget and Degrassi, we are a global leader in franchise management—bringing stories to life through content production, audience reach and consumer products. Our award-winning studio has partnered with top global platforms such as Apple TV, Netflix and the BBC, producing acclaimed series such as The Snoopy Show, Strawberry Shortcake: Berry in the Big City, Teletubbies (2015), Yo Gabba GabbaLand! and Finding Her Edge . The WildBrain Network, offering more than 1,000 channels across YouTube, FAST and AVOD, delivers premium-quality content to today’s kids and families wherever they’re watching—connecting advertisers to audiences at scale through brand-safe media solutions. WildBrain CPLG, our global licensing and consumer products arm, represents our own and partner brands across major territories worldwide. Headquartered in Toronto, WildBrain trades on the Toronto Stock Exchange (TSX: WILD). Visit us at wildbrain.com. 

Attention: We have been made aware of individuals and recruitment agencies falsely claiming to represent WildBrain and offering employment opportunities on our behalf.

All legitimate opportunities are managed through our internal Talent Acquisition team and verified partners, and are posted on our official careers page and LinkedIn. If you are unsure about the legitimacy of any outreach, please verify by contacting us directly.