Senior Data Architecture Specialist (hybrid)

Morgan Stanley

Montreal, Quebec, Canada
On-site
Data modeling (conceptual, logical, physical)
Enterprise data architecture design
Data warehouses and data lakes
Play a key role in designing, implementing, and maintaining data integration solutions and support both new and existing systems, encompassing data warehouses and extraction processes within Source to Pay functional areas

Job Summary

  • Play a key role in designing, implementing, and maintaining data integration solutions and support both new and existing systems, encompassing data warehouses and extraction processes within Source to Pay functional areas.
  • Develop conceptual, logical, and physical data models and design enterprise data architecture, including data warehouses, data lakes, and integration pipelines (ETL/ELT).
  • Lead Integration solution between SaaS applications and Morgan Stanley, and represent the technology team at fleet ceremonies.

Matching Summary

Play a key role in designing, implementing, and maintaining data integration solutions and support both new and existing systems, encompassing data warehouses and extraction processes within Source to Pay functional areas.

Skills & Requirements

Must-have

  • Data modeling (conceptual, logical, physical)
  • Enterprise data architecture design
  • Data warehouses and data lakes
  • ETL/ELT integration pipelines
  • Data governance frameworks
  • Database technologies (SQL, NoSQL, Snowflake, AWS)
  • Python, Pandas, PySpark libraries
  • Source to Pay functional areas

Nice-to-have

  • Emerging data technologies and trends
  • AI-driven insights and automation
  • Agile frameworks and principles
  • Stakeholder management and communication
  • Enablement or transformation programs

Key Requirements

  • 10+ years of experience
  • Hands-on developer in databases
  • Python, Postgres, DB2, shell scripting
  • ETL technologies
  • Data integration and reusable interfaces
  • Python libraries (Pandas, PySpark)
  • Leading large, complex engagements
  • Agile frameworks
  • Stakeholder management
  • Analytical and strategic thinking
  • Working knowledge of AI
  • Knowledge of French and English

Work Rights

Not specified

Tailored Resume

Cover Letter