Government of Canada / Gouvernement du Canada

Data Modeller

NOC 21211 Data Management Employee Digital
Apply Build a Job Description

Overview

As a Data Modeller with the Department of National Defence, you will design, develop, and maintain data structures that support critical defence and security operations. You'll work with complex datasets to create logical and physical data models that enable effective data management, analysis, and decision-making across the organization. Your work ensures that data is organized, accessible, and optimized for various business applications and analytical needs. Your day-to-day responsibilities include analyzing business requirements and translating them into comprehensive data models, collaborating with stakeholders across different departments to understand their data needs, and documenting data architectures and standards. You'll use specialized tools and methodologies to design databases, data warehouses, and data lakes that support both operational systems and advanced analytics. You may also conduct data quality assessments, provide technical guidance on data structure implementation, and stay current with emerging data management technologies and best practices. You'll work in a collaborative environment alongside data architects, software developers, business analysts, and other IT professionals. The role offers the opportunity to contribute to national security initiatives while working with modern technology and innovative solutions. You may work in an office setting, with increasing flexibility for remote work arrangements depending on project requirements and departmental guidelines.

Key Responsibilities

Perform data management activities per GC IM policies, Manage information assets through their lifecycle, Ensure compliance with access to information and privacy requirements, Support information governance and standards

Required Skills

Records management, ATIP legislation, Information governance, Classification systems, Digital literacy, Technical proficiency, Attention to detail, Collaboration, Continuous learning

Typical Education

Post-secondary education or equivalent experience relevant to the position

Training

A bachelor's degree in computer science, information systems, mathematics, engineering, or a related field is typically required. Some positions may accept candidates with extensive relevant experience and demonstrated expertise in data modelling. You should have strong foundational knowledge in database design, SQL, and data management principles. Useful certifications and professional credentials include: Data Modelling certifications (such as those offered through DAMA International), cloud platform certifications (AWS, Azure, or Google Cloud data services), and professional designations in business analysis or data architecture. Government of Canada employees have access to professional development funds and training opportunities to maintain and upgrade certifications throughout their careers. Continuing professional development is encouraged and supported. DND offers access to training programs, online learning platforms, and opportunities to attend relevant conferences and workshops. Many employees pursue advanced certifications in specialized areas such as big data technologies, advanced analytics, or enterprise data governance. Networking through professional associations like DAMA International or the Canadian Information Processing Society can also enhance your career development.

Entry Plans

Entry into a Data Modeller position with DND typically occurs through advertised Public Service Commission (PSC) competitions. These competitions are open to Canadian citizens and permanent residents and are posted on the Government of Canada's Job Bank and DND's careers website. You may enter as a recent graduate through the Federal Student Work Experience Program (FSWEP) or the Post-Secondary Recruitment (PSR) program, which can lead to permanent positions. Some candidates transition into Data Modeller roles from related positions such as Database Administrator, Business Analyst, or Systems Analyst through internal competitions or lateral moves. Lateral transfers from other federal departments are also possible if you hold an equivalent position and meet the requirements. The Canadian Armed Forces and other government departments occasionally use talent pools for Data Management positions, which can expedite the hiring process for qualified candidates. Networking with DND's recruitment team and staying informed about vacancies on the careers website will help you identify opportunities that match your qualifications.

Part-Time Options

Data Modeller positions at DND can often be structured with flexible work arrangements, though this depends on specific project requirements and team needs. Many data modelling tasks can be performed remotely, making telecommuting a viable option for several days per week. Some positions may offer part-time or job-sharing opportunities, particularly for experienced professionals seeking work-life balance. Remote work capabilities have expanded significantly across the Public Service. You may be able to work from home for portions of your week, with in-office time for collaborative meetings, stakeholder engagement, and training. The extent of flexibility varies by directorate and project phase—intensive design phases may require more in-person collaboration, while documentation and analysis work can often be done remotely. DND is committed to supporting work-life balance and recognizes that flexible arrangements can enhance retention and employee well-being. Discuss specific flexibility options during the hiring process and with your manager once hired. All arrangements must align with operational needs and departmental policies.