Data Modeler

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

Qualifications

Skills

Behaviors

Motivations

Education

Experience

Licenses & Certifications