Skip to main content

Search Jobs

Search

We're looking for people who are up for the challenge of honoring a seventy-five year legacy by making their own mark in new frontiers. If being part of a remarkable transformation energizes you, you're in the right place. We need pioneers, inventors, designers and entrepreneurs of all kinds.

Data Solution Architect

Mississauga, Ontario

Please turn off any pop up blockers before clicking apply now

Posting Title Data Solution Architect Requisition Number R228674 Company Mattel Canada, Inc. Location Mississauga, Ontario Address 6155 Freemont Blvd Zip Code L5R 3W2 Job Category Information Technology

*Full-time, permanent position*

Key Responsibilities:

  1. Data Architecture, Engineering, and Machine Learning:
  • Support existing Informatica PC and IICS flows and retransformation on PowerCenter and IICS
  • Establish and encode Patterns on GCP and associated data infrastructure for ETL/ELT, AIML
  • Develop data transformation and integration strategies for seamless data flow between sources and destinations.
  • Develop efficient and secure data transformation pipelines for analytics and
  • Maintain metadata management processes for effective data governance.
  • machine learning.
  • Architect, design, and optimize data solutions using GBQ, Ascend, Collibra DQ/DG, Vertex AI, and Python.

      2. Collaboration and Knowledge Sharing:

  • Work closely with cross-functional teams, including data engineers, analysts, and stakeholders, to deliver high-impact data solutions. 
  • Provide mentorship and guidance to team members, fostering continuous learning and skill development.

Education Required: (Type of degree and acceptable field(s) of study): Bachelor’s degreewith 8+ years of experience.

  1. Skilled at data warehousing/data lake architecture implementations for analytical reporting translating real world business needs at scale for data lake and warehousing needs. Competence in debugging, refactoring, and optimizing code, along with the ability to determine when and how to automate tasks with experience in being able to operate in an agile environment for delivery of data products.
  2. Hands-on experience with developing and deploying production data pipelines using orchestration tools like GCP Cloud Composer/Airflow, CA Scheduler, Informatica
  3. Strong verbal and written development, and troubleshooting large-scale, production-grade distributed systems on GCP, selecting the appropriate tools to Skills.
    • Must Have
      • Informatica, GCP, Airflow, Data Modeling, Python, GBQ, SQL
    • Preference Given to
      • Collibra, Ascend, Vertex AI, DBT, Docker, Gitlab, ML Modelling, Oracle, DB2
    • Nice To Have
      • Kubernetes, SAFe Certification
  4. Proven experience and track record as a Data Architect with expertise in GBQ, Ascend, Collibra, Python, AIML, and data patterns.
  5. Excellent problem-solving abilities and attention to detail. Solid understanding of data modeling, ETL processes, and data warehousing concepts.
  6. Exceptional communication skill with ability to describe complex concepts to a technical audience using UML based techniques.
  7. Strong programming skills in Python, SQL, Airflow

Language of work: English 

Salary: C$ 138,000 annual base salary. Performance based bonus may be available at target of 15% of base salary. 

Benefits provided as per Company Group Insurance Plan. This includes:

Life Insurance
Short Term Disability
Long Term Disability

Mattel Canada offers 15 days vacation, public holidays per the Employment Standards Act, private coverage for prescriptions, paramedical care, and dental, and company sponsored retirement plan.

Location:  Mattel Canada office in Mississauga Ontario, Canada. 6155 Freemont Blvd, Mississauga, Ontario, L5R 3W2

Contact: 

Aditya P Mishra

Telephone: 3104801070

Email: GlobalMobility@Mattel.com

Mailing address: 6155 Freemont Blvd, Mississauga, Ontario, L5R 3W2

AA/EEO and Accessibility Commitment

Mattel is an Affirmative Action/Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers including minorities, females, veterans, individuals with disabilities, and those of all sexual orientations and gender identities.

Mattel aims to make its Careers website accessible. It is Mattel’s Policy to provide reasonable accommodations to people with disabilities as required by law. If you’re interested in applying for employment with Mattel, and need assistance with this online system at any point during the application, screening or selection process, or if you believe you do not meet any of the required qualifications of a posted position due to a protected disability and would like to explore the possibility of an accommodation, please contact our Talent Acquisition team at: TalentAcquisition@mattel.com. It is Mattel's Policy to consider all qualified applicants for employment without regard to race, color, religion, national origin, ancestry, social origin, age, marital status, veteran and protected veteran status, disability, sex (including pregnancy, childbirth or related medical conditions), sexual orientation, genetic information, gender, gender identity or expression, or any other basis protected by applicable law. Mattel has also developed an Affirmative Action Program in compliance with federal regulations and to enhance Mattel's objectives of equal access to opportunities at all levels of employment.