Cloud Data Architect

ALLTECH CONSULTING SVC INC; Quebec; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading company in consulting is seeking a Data Architect with extensive experience in creating data architectures and models. This role involves collaboration with data engineers and analysts to deliver data solutions that support business goals. The ideal candidate will have a minimum of 7-10 years in data architecture, strong SQL skills, and proficiency in modern data technologies including Snowflake, AWS, and big data tools.

Qualifications

• Minimum of 7-10 years in Data Warehouse Architecture or modeling role.
• Expert SQL knowledge; proficiency in data modeling tools and big data technologies.

Responsibilities

• Develop comprehensive data architecture strategies for Snowflake Cloud.
• Create scalable data models for business intelligence and AI tools.
• Enhance data quality and establish governance frameworks.

Skills

Data Architecture Design

Data Modeling

Data Governance

SQL

Big Data Technologies

Problem Solving

Communication

Tools

Snowflake

ERwin

PowerDesigner

AWS

Azure

Google Cloud

Job description

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.