Data Modeler

Sekure Merchants; Montreal; On-site; CAD 80,000 - 110,000; Full time

Job summary

A data management firm in Canada is seeking a Data Architect to develop and implement data models, assess data architecture components, and collaborate with cross-functional teams. Candidates should have at least 3 years of experience in data warehousing, strong data modeling skills, and excellent communication abilities. This role offers a dynamic environment working with modern data technologies, including Azure and ETL tools.

Qualifications

• 3+ years of experience with data warehousing and BI in large-scale systems.
• Strong understanding of data modelling and design principles.
• Hands-on experience in relational and dimensional data modelling.

Responsibilities

• Develop conceptual, logical, and physical data models.
• Assess and design data architecture components.
• Work with cross-functional teams to translate requirements into data models.

Skills

Data warehousing

Data management

Business intelligence

Data modeling

SQL

Communication

Tools

Azure Data Factory

ETL tools

SQL Server

Job description

Job Details

Description

Work with Data Architect and partners to understand business requirements, create data definitions, business rules, data quality requirements, and logical and physical models, then support implementation within the data platform by working with the data solution architect, other data modelers and data engineers.

Job description

• Be responsible for the development of the conceptual, logical, and physical data models.
• Assess and design of data architecture components (data model, mapping, data flows, transformations, interfaces) to make sure they are well integrated and aligned with the data and technical architecture.
• Map data from source to target; prepare and manage data models for multiple components of the data platform.
• Develop a detailed knowledge of the underlying data assets and data products and provide subject matter expertise on content, current and potential future uses of data.
• Work with cross-functional teams to understand and translate analytical and reporting requirements into curated data models and drive to completion with data engineers.
• Participate in building a modern approach to Data Warehousing and the BI Platform to support self‑service, machine learning and model development.
• Be aware of security requirements, implications, and the need to enforce standards.
• Identify, communicate, and mitigate Risks, Assumptions, Issues and Decisions throughout full lifecycle.

Job qualifications

• 3 or more years of experience with data warehousing, data management and business intelligence, within large‑scale data management systems.
• Strong technical understanding of data modelling, design and architecture principles and techniques across master data, transaction data and derived data.
• Strong Data Modeling Skills in designing, creating and maintaining conceptual, logical, and physical data models.
• Should have strong knowledge in creating the data model for OLAP and OLTP systems.
• Good knowledge of data profiling, integrating, and modeling data from different source systems including Web APIs.
• Should have hands‑on experience in relational, dimensional, analytic data modelling using RDBMS, dimensional and ETL and data ingestion protocols.
• Experience working with extracting business rules to develop transformations, data lineage, metadata, data catalogue
• Working knowledge with data integration from different data sources including MySQL, SQL Server and Web APIs.
• Experience in and eagerness to document all design decisions, with data modelling tools.

Preferred Experience

• Excellent communication skills (in‑person and remotely) with the ability to describe complex information and designs.
• Willingness to work with remote teams in different time zones around the world.

Preferred Technical & Professional Expertise

• Exposure to Azure (Azure MySQL, Azure SQL, Azure Data Factory)
• Exposure to an orchestration tool (e.g., Data Factory)
• Logical and physical modeling on SQL Server databases
• ETL knowledge background
• Experience with DevOps
• Exposure to Python an asset