Data Modeler/Information Architect

Compunnel Inc.; Toronto; On-site; CAD 40,000 - 55,000; Full time

Job summary

A leading company in IT services seeks a Data Modeler to translate business needs into effective data models. The ideal candidate will apply their extensive knowledge in data warehousing and business intelligence to architect and optimize data frameworks, ensuring data integrity and quality. This contract role demands strong communication and analytical skills, alongside hands-on data modeling expertise. It offers competitive compensation commensurate with experience, emphasizing the importance of attention to detail.

Qualifications

• Minimum of 5 to 8 years of IT experience.
• 4+ years in Data Model design.
• Experience with Azure Solutions and SQL.

Responsibilities

• Translate business needs into data models.
• Develop standard methodologies for data models.
• Analyze data integration challenges.

Skills

Data Modeling

Business Intelligence

Data Warehousing

Analytics

Communication

Attention to Detail

Education

Bachelor’s degree in computer science

Tools

Power Designer

Erwin Data Modeling tool

Job description

Get AI-powered advice on this job and more exclusive features.

• Understand and translate business needs into data models supporting long-term solutions.
• Closely interact with business partners, stakeholders, functional experts, business analysts, contractors, and developers to understand the system requirements and architect and design the data model and database schema based on the requirements.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using standard methodologies to ensure high data quality and reduced redundancy.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop standard methodologies for standard naming conventions and coding practices to ensure consistency of data models.
• Communicate effectively with no ambiguity during project execution on data model
• Understand and articulate interdependencies, constraints of the data model to Data Engineers, project teams and business teams
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Understanding and experience in OLAP, reporting and analytics principles.
• Own the data definitions for all data tables and maintain data lineage
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards.
• Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.

Candidate Requirements/Must Have Skills:

• Solid experience with business intelligence and data warehousing development technologies, RDBMS, Hadoop and Analytics Environments.
• Minimum 5 to 8 years of experience in IT with a minimum of 4+ years in Data Model design.
• Expertise with Big data technologies and data bricks as well as BI and data warehousing development technologies.
• Strong Data Modeling skills. Take ownership and do data modelling work themselves and do hands on work.
• Experience with Azure Solutions and SQL
• Expertise with Power Designer/Erwin Data Modeling tool
• Familiarity with Capital Markets data
• Able to communicate clearly, both verbally and in written form
• Good work ethic, results oriented, and accuracy / attention to detail are critical

Nice-To-Have Skills:

• Wealth management/capital markets industry
• Hortonworks/Cloudera HADOOP platform

Education:

• Bachelor’s degree in computer science, information systems or related.

Seniority level

• Seniority level

  Director

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Compunnel Inc. by 2x

Get notified about new Data Modeler jobs in Toronto, Ontario, Canada.

Data Labeling Associate - 6 Month Contract

Data Quality Analyst (Fraud Investigation)

Part-time Data Quality Analyst (Fraud Investigation)

Toronto, Ontario, Canada CA$40.00-CA$55.00 2 weeks ago

Freelance Data Analyst (Python) - AI Trainer

Toronto, Ontario, Canada $150,000.00-$600,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.