About the Role

We are seeking an experienced Data Modeler – 3NF & Analytical RDBMS to join our data and analytics team. The ideal candidate will have strong expertise in relational data modeling, Third Normal Form (3NF), dimensional modeling, analytical databases, data warehousing, and enterprise data architecture.

The Data Modeler will be responsible for designing scalable, consistent, and high-performing data models that support operational systems, analytics, reporting, and enterprise data platforms. This role requires strong analytical skills, deep knowledge of relational database concepts, and the ability to translate complex business requirements into well-structured conceptual, logical, and physical data models.

Key Responsibilities

- Design, develop, and maintain conceptual, logical, and physical data models for enterprise applications, analytical platforms, and data warehouses.
- Create normalized relational models using Third Normal Form (3NF) principles for operational and enterprise data stores.
- Design analytical models using Star Schema, Snowflake Schema, dimensional modeling, and fact/dimension structures.
- Translate business requirements, data requirements, and reporting needs into scalable and maintainable data models.
- Work closely with Data Architects, Data Engineers, Business Analysts, Developers, BI Developers, and business stakeholders.
- Define entities, attributes, primary keys, foreign keys, relationships, constraints, and referential integrity rules.
- Analyze existing database structures and recommend improvements for data quality, consistency, scalability, and performance.
- Develop and maintain enterprise data standards, naming conventions, metadata definitions, and data modeling guidelines.
- Design normalized models to eliminate redundancy and maintain data integrity across transactional systems.
- Perform normalization and denormalization based on application, reporting, and performance requirements.
- Design analytical data models optimized for reporting, business intelligence, and large-scale analytical queries.
- Define fact tables, dimension tables, surrogate keys, hierarchies, measures, and Slowly Changing Dimensions (SCD).
- Support data warehouse and data mart design for reporting and analytics platforms.
- Work with relational database technologies such as Oracle, SQL Server, PostgreSQL, Azure SQL Database, or similar RDBMS platforms.
- Review SQL queries, table structures, indexes, and relationships to ensure data models support productive access patterns.




- Collaborate with database and engineering teams on indexing, partitioning, constraints, query optimization, and physical database design.
- Perform source-to-target data mapping and support ETL/ELT pipeline design and implementation.
- Support integration of data from multiple operational systems into centralized enterprise analytical platforms.
- Analyze source systems and identify data relationships, dependencies, inconsistencies, and transformation requirements.
- Support data migration, data conversion, modernization, and system integration initiatives.
- Define data lineage, metadata, business definitions, and data ownership requirements.
- Collaborate with governance teams to implement data quality, security, privacy, and governance standards.
- Support Master Data Management and reference data modeling where applicable.
- Participate in data architecture reviews and ensure data models align with enterprise architecture standards.
- Maintain model documentation using tools such as ERwin, ER/Studio, Visio, Sparx Enterprise Architect, or similar data modeling platforms.
- Conduct data model walkthroughs and design reviews with technical and business stakeholders.
- Support developers and data engineers by providing clear data model specifications and clarifying model-related requirements.
- Analyze data volume, usage patterns, and query requirements to support scalable physical data design.
- Ensure data models support both current requirements and future business growth.
- Participate in Agile/Scrum ceremonies including sprint planning, backlog refinement, reviews, and technical discussions.
- Identify opportunities to simplify data structures, improve data reuse, and reduce duplication across enterprise systems.

Qualifications
- 7+ years of experience in Data Modeling, Data Architecture, Database Design, Data Engineering, or a related role.
- Strong hands-on experience designing 3NF relational data models.
- Strong understanding of database normalization principles, including 1NF, 2NF, 3NF, and normalization trade-offs.
- Strong experience with conceptual, logical, and physical data modeling.
- Strong knowledge of analytical RDBMS and enterprise data warehouse architectures.




- Experience designing Star Schema, Snowflake Schema, fact tables, dimension tables, and dimensional models.
- Robust understanding of Slowly Changing Dimensions (SCD Type 1, Type 2, and related techniques).
- Experience with relational databases such as Oracle, Microsoft SQL Server, PostgreSQL, Azure SQL, or similar platforms.
- Strong SQL skills, including complex joins, aggregations, window functions, subqueries, and analytical queries.
- Experience with database design, constraints, primary and foreign keys, indexes, partitions, and referential integrity.
- Strong understanding of transactional versus analytical data modeling patterns.
- Experience with enterprise data warehouses, data marts, operational data stores, and analytical databases.
- Experience with source-to-target mapping, data transformation, ETL/ELT processes, and data integration.
- Experience working with large-scale enterprise datasets and complex relational structures.
- Knowledge of data lineage, metadata management, data dictionaries, and business glossaries.
- Experience with data modeling tools such as ERwin Data Modeler, ER/Studio, Visio, Sparx Enterprise Architect, or similar tools.
- Understanding of data governance, data quality, security, privacy, and compliance principles.
- Experience collaborating with Business Analysts and stakeholders to gather and validate data requirements.
- Ability to analyze business processes and translate them into structured data entities and relationships.
- Strong understanding of query performance, indexing, partitioning, and physical database optimization.
- Experience with cloud-based data platforms such as Azure Synapse Analytics, Microsoft Fabric, Databricks, Snowflake, or similar technologies is considered an asset.
- Familiarity with Data Vault 2.0, Lakehouse architecture, Delta Lake, and Parquet formats is considered an asset.
- Familiarity with BI and reporting platforms such as Power BI is considered an asset.
- Robust analytical, documentation, communication, and problem-solving skills.
- Ability to work effectively with Data Architects, Data Engineers, Developers, DBAs, BI teams, and business stakeholders.
- Strong understanding of the Software Development Life Cycle (SDLC) and Agile delivery methodologies.
- Experience working in large enterprise, government, financial services, healthcare, or other complex data environments is considered an asset.

Pay: $50.00-$75.00 per hour Work Location: Hybrid remote in Brampton, ON L6Y 2Y2

📌 Data Modeler - 3NF & Analytical RDBMS (Brampton)
🏢 Axella Compusoft
📍 Brampton