Job Title Cloud Data Architect

Location : Montreal, Quebec - Hybrid - 3 days office, 2 days Remote

Key Responsibilities:

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.

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.

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.

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.

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.

Experience Required:

• 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, Power Designer, 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).

Soft Skills:

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