Senior Data Modeller (ID#5585)

New Value Solutions, a national IT consulting firm, is recruiting experienced Senior Data Modellers to support Government of Canada IT consulting engagements focused on enterprise data management, database design, systems modernization, data integration, and digital transformation.

We are seeking accomplished Data Modellers with demonstrated experience developing conceptual, logical, and physical data models, defining enterprise data structures, and supporting the design and implementation of complex information systems.

Responsibilities:

• Develop, maintain, and enhance conceptual, logical, and physical data models to support enterprise applications, databases, and information management initiatives.
• Analyze business requirements, data requirements, and existing information structures to develop comprehensive data models and design specifications.
• Define data entities, attributes, relationships, keys, constraints, and business rules in accordance with enterprise data modelling standards.
• Design relational database structures, including normalization, referential integrity, and physical database considerations.
• Collaborate with business analysts, data architects, database administrators, application developers, and business stakeholders to translate information requirements into effective data designs.
• Develop and maintain data dictionaries, metadata definitions, entity relationship diagrams, and supporting technical documentation.
• Review existing data models and database structures to identify inconsistencies, duplication, data quality issues, and opportunities for improvement.
• Support data integration, data migration, and application modernization initiatives by mapping source and target data structures.
• Develop and maintain source-to-target mappings, data transformation specifications, and data lineage documentation.
• Apply enterprise data modelling standards, naming conventions, metadata management practices, and data governance requirements.
• Participate in data design reviews, technical assessments, and quality assurance activities to ensure consistency and alignment with business requirements.
• Support database development, testing, implementation, and ongoing enhancements by providing data modelling expertise and technical guidance.

Requirements:

• Extensive professional experience in enterprise data modelling, relational database design, or related data management disciplines.
• Strong hands-on experience developing conceptual, logical, and physical data models for complex enterprise information systems.
• Demonstrated experience with entity relationship modelling, normalization, data structures, and relational database design principles.
• Experience using enterprise data modelling tools such as ERwin Data Modeler, ER/Studio, Oracle SQL Developer Data Modeler, or comparable platforms.
• Strong knowledge of SQL and relational database management systems such as Oracle, Microsoft SQL Server, PostgreSQL, or comparable technologies.
• Experience analyzing business and technical requirements and translating them into detailed data models and database design specifications.
• Experience developing data dictionaries, metadata documentation, data definitions, and entity relationship diagrams.
• Knowledge of data integration, data mapping, data transformation, and data migration practices.
• Understanding of data governance, data quality, master data management, and enterprise information management principles.
• Experience working with data architects, database administrators, business analysts, and application development teams.
• Strong analytical, problem-solving, communication, and technical documentation skills.
• Relevant post-secondary education in Computer Science, Information Technology, Data Management, or a related discipline, or an equivalent combination of education and experience.

Preferred Qualifications:

• Previous experience providing data modelling services to Government of Canada departments or agencies.
• Experience supporting large-scale public sector enterprise data management, database modernization, or digital transformation initiatives.
• Experience developing data models for enterprise data warehouses, reporting platforms, or business intelligence solutions.
• Experience with dimensional data modelling, including star schemas, snowflake schemas, fact tables, and dimension tables.
• Experience supporting cloud-based data platforms such as Microsoft Azure, Azure SQL, Microsoft Fabric, or comparable technologies.
• Experience with enterprise data architecture frameworks, information management standards, and data governance methodologies.
• Experience developing source-to-target mappings and supporting ETL or ELT data integration processes.
• Familiarity with data modelling approaches for structured, semi-structured, and unstructured data.
• Relevant certifications in data management, data modelling, database technologies, or enterprise architecture.
• Experience working within formal government information management, documentation, security, and change management frameworks.
• Existing Government of Canada Reliability Status or Secret security clearance.

About New Value Solutions

New Value Solutions is a Canadian IT consulting and professional services firm with extensive experience supporting public sector organizations across Canada. We specialize in connecting experienced technology and business professionals with consulting engagements involving enterprise systems, digital transformation, cybersecurity, and IT modernization.

Engagements are available across Canada, with remote, hybrid, and onsite arrangements, start dates, and assignment details determined by individual client requirements as contracts are secured.

If you have the necessary expertise and are legally authorized to work in Canada, please submit your resume. We thank all applicants for their interest; however, only those shortlisted will be contacted.

ID # 5585