+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445

rosewater33

Member
May 5, 2026
12
0
hi everyone, I am really confused about my noc code, it matches data administrator duties under 21223, but not the database analyst. please help:

JOB DUTIES:


• Conduct data research and investigations using internal databases, external data sources, and business applications to verify client information, identify discrepancies, and determine appropriate data maintenance actions.

• Collect and document data requirements for Asset Managers, Investment Managers, Funds, and Capital Markets products to support accurate client classification, data administration, and reporting activities.

• Performed data cleansing, validation, and transformation activities using Microsoft Excel to ensure data accuracy, integrity, and consistency across large enterprise datasets.

• Developed and applied data validation rules, data quality standards, and control measures to support effective data governance practices and resolve data inconsistencies

• Collaborate with business stakeholders and cross-functional teams to investigate data exceptions, recommend corrective actions, and support data remediation initiatives.

• Monitor and maintain data accuracy by auditing, validating, and administering client information within enterprise databases and data management applications.

• Prepare and maintain documentation related to data definitions, validation procedures, data quality findings, and data administration processes to support governance and audit requirements.

• Provide recommendations regarding the availability, quality, integrity, and suitability of data used for operational, regulatory, and business reporting purposes.

• Utilize analytical and problem-solving techniques to assess data issues, evaluate impacts, and determine appropriate resolution or escalation actions.
 
hi everyone, I am really confused about my noc code, it matches data administrator duties under 21223, but not the database analyst. please help:

JOB DUTIES:


• Conduct data research and investigations using internal databases, external data sources, and business applications to verify client information, identify discrepancies, and determine appropriate data maintenance actions.

• Collect and document data requirements for Asset Managers, Investment Managers, Funds, and Capital Markets products to support accurate client classification, data administration, and reporting activities.

• Performed data cleansing, validation, and transformation activities using Microsoft Excel to ensure data accuracy, integrity, and consistency across large enterprise datasets.

• Developed and applied data validation rules, data quality standards, and control measures to support effective data governance practices and resolve data inconsistencies

• Collaborate with business stakeholders and cross-functional teams to investigate data exceptions, recommend corrective actions, and support data remediation initiatives.

• Monitor and maintain data accuracy by auditing, validating, and administering client information within enterprise databases and data management applications.

• Prepare and maintain documentation related to data definitions, validation procedures, data quality findings, and data administration processes to support governance and audit requirements.

• Provide recommendations regarding the availability, quality, integrity, and suitability of data used for operational, regulatory, and business reporting purposes.

• Utilize analytical and problem-solving techniques to assess data issues, evaluate impacts, and determine appropriate resolution or escalation actions.
You are right that it does not match the database analyst side, and that is not a problem. 21223 is a single unit group covering two distinct roles, database analysts and data administrators, with separate duty lists for each. You only need to match one of them, and yours sits squarely on the data administrator side.
Four of your duties map closely to the published list.
Your second bullet, collecting and documenting data requirements, is close to verbatim against "research and document data requirements, data collection and administration policy, data access rules and security".
Your fourth, developing and applying data validation rules, data quality standards and control measures, maps to "develop and implement data administration policy, standards and models".
Your seventh, maintaining documentation on data definitions and validation procedures, supports the same one and reflects the data dictionary administrator title within the group.
And your last bullet is the strongest of all. Providing recommendations regarding the availability, quality, integrity, and suitability of data is almost word for word the NOC duty "conduct research and provide advice to other information systems professionals regarding the collection, availability, security, and suitability of data".
Worth knowing that the job titles listed under 21223 include data quality analyst, data steward, data management specialist, and data custodian, which sound closer to your actual work than database analyst does.
One line I would look at, because it is the only thing in your list that points elsewhere.
"Performed data cleansing, validation and transformation activities using Microsoft Excel."
Excel is the weak point. An officer reading that may see data processing rather than data administration, and processing roles sit lower. If you also work in enterprise database systems or data management applications, which your sixth bullet suggests, name those specifically rather than leading with Excel. If Excel genuinely is the main tool, keep it but put it after the governance and standards work rather than in its own bullet.
The rest reads as 21223. That one line is what an officer could pull on.
What is your actual job title on the employment letter?