Data Modeling Specialist

Senior Consultant, Talent Acquisition Partner @ CGI | MBA, Tech Recruitment

Position Description
This role is hybrid and requires you to be at our client office at a minimum 2 days per week - subject to change at any time.

Data Modeling Specialist
One of our senior consultancy positions is focused on designing and implementing data models for enterprise data platforms, translating business concepts into logical and physical data structures, and ensuring scalability and alignment with modern data architecture principles.

• Design conceptual, logical, and physical data models for data warehouses, analytics platforms, and data lake houses.
• Translate business requirements into logical models and physical structures in databases, data warehouses, and lake houses.
• Develop and maintain ERDs, data dictionaries, metadata catalogs, and data lineage documentation.

• Apply best practices in data warehouse design, including star schema and snowflake schema.
• Implement Data Mesh architecture principles for creating data products.
• Ensure compliance with Data Pattern 5.0 and other modeling standards.

• Work closely with business analysts, data engineers, and stakeholders to ensure models meet business needs.
• Establish and enforce data modeling standards and governance practices.

• Strong experience in conceptual, logical, and physical data modeling.
• Hands‑on experience with ERDs, data dictionaries, metadata catalogs, and data lineage tools.
• Solid understanding of data warehousing concepts and design patterns (Star Schema, Snowflake Schema).
• Familiarity with Data Mesh architecture and Data Pattern 5.0.

• Ability to translate complex business concepts into scalable data models.
• Strong documentation and stakeholder communication skills.

• Experience with data modeling tools (e.g., ERwin, Power Designer, or similar).
• Knowledge of modern data platforms and cloud‑based data architectures.

Compensation
CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. A reasonable estimate of the current range is $95,000–$145,000.

Location
Vaughan, Ontario, Canada – CA $79,538 – CA $93,047

Benefits and Culture
Life at CGI is rooted in ownership, teamwork, respect and belonging. You’ll develop innovative solutions, build relationships with teammates and clients, and access global capabilities to scale your ideas and advance your career. CGI is an equal‑opportunity employer; we are committed to fostering a workplace where everyone belongs.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Referrals increase your chances of interviewing at CGI by 2x.