Information Architect / Data Modeler

Compunnel, Inc.; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading company in Toronto is seeking an experienced Information Architect/Data Modeler to support its global data strategy. This hands-on role involves designing enterprise-grade data models and collaborating with various stakeholders to enhance data insights and operational efficiency.

Qualifications

• 5-8 years IT experience, 4+ years in data model design.
• Hands-on experience with SQL, Azure, and Databricks.
• Strong knowledge of data warehousing and analytics.

Responsibilities

• Translate business needs into scalable data models.
• Collaborate with stakeholders on data model design.
• Maintain and optimize existing data models.

Skills

Data modeling

SQL

Azure solutions

Big data

Business intelligence

Communication skills

Attention to detail

Education

Bachelor’s degree in Computer Science

Tools

PowerDesigner

Erwin

Job description

Client division is seeking an experienced Information Architect / Data Modeler to support its global data strategy. This role focuses on the Investment Data Lake, enabling better insights, product development, and operational efficiency through robust data modeling and architecture. The position will report to the Director of Information Architecture and play a hands-on role in designing and implementing enterprise-grade data models.

• Translate business needs into scalable, long-term data models.
• Collaborate with stakeholders, analysts, and developers to design conceptual, logical, and physical data models and database schemas.
• Support data strategy implementation by building data flows and partnering with application development teams.
• Maintain and optimize existing data models and metadata documentation.
• Create and enforce best practices for naming conventions, data standardization, and modeling consistency.
• Ensure data model clarity across project teams and communicate interdependencies and constraints.
• Perform reverse engineering of data models from existing databases and SQL scripts.
• Evaluate data models and physical schemas for discrepancies and optimize as needed.
• Manage and document data definitions and data lineage for key data tables.
• Provide technical guidance to analysts, engineers, and developers on data-related initiatives.
• Analyze system integration issues and recommend data-driven solutions.
• Promote reuse of existing data models where applicable.

Required Qualifications

• 5–8 years of IT experience with a minimum of 4 years in data model design.
• Hands-on experience with business intelligence, data warehousing, and big data technologies.
• Expertise in data modeling using tools such as PowerDesigner or Erwin.
• Strong knowledge of SQL, Azure solutions, and Databricks.
• Experience working in RDBMS, Hadoop, and analytics environments.
• Proficient in developing and optimizing conceptual, logical, and physical data models.
• Solid understanding of OLAP, reporting, and analytics principles.
• Strong communication skills — both verbal and written.
• High attention to detail, strong work ethic, and a results-oriented mindset.

Preferred Qualifications

• Experience in wealth management or capital markets.
• Familiarity with Hortonworks or Cloudera Hadoop platforms.

Certification

• Relevant data or cloud certifications if available.

Education

• Bachelor’s degree in Computer Science, Information Systems, or a related field.