Data Architect (BigQuery GCP)

• 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 teams 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 youll 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 its 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 weve 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 managementbringing 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 1000 channels across YouTube FAST and AVOD delivers premium-quality content to todays kids and families wherever theyre watchingconnecting 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 . 

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.

Remote Work :

No

Employment Type :

Full-time