Job Role: Senior Cloud Data Architect

Location: Montreal

Duration: 12 months

Key Responsibilities:

1. Data Architecture Design:

• Develop and implement comprehensive data architecture strategies that support the needs of our Data on Snowflake Cloud Architecture.
• Design scalable data models that facilitate efficient data procurement, storage, processing, and analysis.

2. Data Modeling:

• Create logical and physical data models, that reflect business data consumption needs.
• Ensure data models to support data mining, business intelligence, and analytics activities and AI tools.
• Semantic models to facilitate self-service operations and AI tools.

3. Data Governance and Quality:

• Help establish and facilitate management of data definitions, standards, policies, and procedures.
• Enhance data quality by setting up frameworks for data consistency, accuracy, and completeness.
• Lead efforts in data cataloging for improved data discovery and understanding.

4. Collaboration:

• Work closely with data engineers, analysts, product owners, and other stakeholders to deliver data products that align with business objectives.
• Facilitate cross-functional team efforts to ensure data architecture supports all aspects of the business.

5. Tool Utilization and Expertise:

• Utilize advanced data modeling tools to design and optimize data architectures.
• Stay updated with the latest trends in data technology and methodologies.
• Familiarity with business intelligence tool set ecosystem, and strong experience with some.

6. Experience:

• Minimum of 7-10 years in a Data Warehouse Architecture and Development or data modeling role.
• Proven experience with data warehousing solutions, ELT processes, and data integration techniques.
• Expert level knowledge of SQL and experience with database management systems (e.g.,Snowflake,Teradata, PostgreSQL, Sybase, DB2, etc.).
• Proficiency in data modeling tools like ERwin, PowerDesigner, or equivalent tools.
• Proficiency in AI-enabled toolsets for data management and analytics.
• Proficiency in big data technologies and cloud services (AWS, Azure, Google Cloud).

7. Soft Skills:

• Exceptional analytical and problem-solving capabilities.
• Strong communication skills to articulate complex data concepts to non-technical stakeholders.
• Ability to work in a collaborative, agile environment.