Design and Develop Data Solutions
- Design, develop, maintain, and enhance database applications that support examination data collection, validation, processing, and reporting.
- Develop and optimize relational databases, data models, stored procedures, and automated workflows.
- Build and maintain data integrations across multiple internal and external systems.
- Implement data quality controls, validation processes, and audit procedures to ensure data integrity.
- Troubleshoot technical issues and identify opportunities for continuous improvement.
Lead Data Engineering and Automation Initiatives
- Design, develop, and maintain automated data pipelines using SQL, Python, and related technologies.
- Build scalable ETL processes to support examination and assessment data management.
- Streamline manual processes through automation and workflow enhancements.
- Develop reusable scripts, code libraries, and technical documentation.
- Monitor and optimize data processing performance, reliability, and scalability.
Deliver Reporting, Analytics, and Business Insights
- Create and maintain dashboards, reports, and analytical tools that support operational and strategic decision-making.
- Conduct complex analyses and communicate findings to both technical and non-technical audiences.
- Support the timely and accurate processing and distribution of examination results.
- Develop meaningful visualizations that communicate trends and performance outcomes.
- Collaborate with psychometric and assessment professionals to support scoring, equating, standard setting, and other measurement-related activities.
- Produce candidate-facing reports, transcripts, performance reports, and related communications.
Support Data Governance and Compliance
- Ensure compliance with privacy legislation, organizational policies, security standards, and data governance requirements.
- Maintain controls that protect confidential candidate and examination information.
- Support audit, quality assurance, risk management, and regulatory compliance initiatives.
- Promote best practices in data stewardship, security, and data quality management.
Collaborate Across Teams and Projects
- Partner with examination operations, psychometric, reporting, and technology teams to achieve business objectives.
- Lead or contribute to projects involving technology implementations, reporting improvements, and process modernization.
- Provide technical expertise, guidance, and training to colleagues and stakeholders.
- Develop technical documentation, process maps, and user resources.
- Build strong relationships with internal and external partners to support successful project outcomes.
Design and Develop Data Solutions
- Design, develop, maintain, and enhance database applications that support examination data collection, validation, processing, and reporting.
- Develop and optimize relational databases, data models, stored procedures, and automated workflows.
- Build and maintain data integrations across multiple internal and external systems.
- Implement data quality controls, validation processes, and audit procedures to ensure data integrity.
- Troubleshoot technical issues and identify opportunities for continuous improvement.
Lead Data Engineering and Automation Initiatives
- Design, develop, and maintain automated data pipelines using SQL, Python, and related technologies.
- Build scalable ETL processes to support examination and assessment data management.
- Streamline manual processes through automation and workflow enhancements.
- Develop reusable scripts, code libraries, and technical documentation.
- Monitor and optimize data processing performance, reliability, and scalability.
Deliver Reporting, Analytics, and Business Insights
- Create and maintain dashboards, reports, and analytical tools that support operational and strategic decision-making.
- Conduct complex analyses and communicate findings to both technical and non-technical audiences.
- Support the timely and accurate processing and distribution of examination results.
- Develop meaningful visualizations that communicate trends and performance outcomes.
- Collaborate with psychometric and assessment professionals to support scoring, equating, standard setting, and other measurement-related activities.
- Produce candidate-facing reports, transcripts, performance reports, and related communications.
Support Data Governance and Compliance
- Ensure compliance with privacy legislation, organizational policies, security standards, and data governance requirements.
- Maintain controls that protect confidential candidate and examination information.
- Support audit, quality assurance, risk management, and regulatory compliance initiatives.
- Promote best practices in data stewardship, security, and data quality management.
Collaborate Across Teams and Projects
- Partner with examination operations, psychometric, reporting, and technology teams to achieve business objectives.
- Lead or contribute to projects involving technology implementations, reporting improvements, and process modernization.
- Provide technical expertise, guidance, and training to colleagues and stakeholders.
- Develop technical documentation, process maps, and user resources.
- Build strong relationships with internal and external partners to support successful project outcomes.
Education and Experience
- Bachelor's degree in Computer Science, Software Engineering, Information Systems, Data Science, or a related discipline.
- Minimum five years of progressively responsible experience in database development, data engineering, business intelligence, reporting, analytics, or related technical disciplines.
- Experience designing and maintaining enterprise-scale database applications and reporting solutions.
- Experience supporting data-intensive, highly regulated, or high-stakes operational environments.
- Experience working with examination, assessment, certification, or educational data is considered an asset.
- Knowledge of privacy legislation and data governance practices is an asset.
- French language proficiency is considered an asset.
Skills and Competencies
- Advanced SQL expertise, including database design, query optimization, stored procedures, and performance tuning.
- Strong Python programming skills for automation, analytics, data integration, and data processing.
- Experience with relational database platforms such as Microsoft SQL Server, PostgreSQL, Oracle, or similar technologies.
- Experience developing ETL processes, automated workflows, and data pipelines.
- Experience with business intelligence and visualization tools such as Power BI or Tableau.
- Strong understanding of data architecture, data modelling, governance, and information management principles.
Education and Experience
- Bachelor's degree in Computer Science, Software Engineering, Information Systems, Data Science, or a related discipline.
- Minimum five years of progressively responsible experience in database development, data engineering, business intelligence, reporting, analytics, or related technical disciplines.
- Experience designing and maintaining enterprise-scale database applications and reporting solutions.
- Experience supporting data-intensive, highly regulated, or high-stakes operational environments.
- Experience working with examination, assessment, certification, or educational data is considered an asset.
- Knowledge of privacy legislation and data governance practices is an asset.
- French language proficiency is considered an asset.
Skills and Competencies
- Advanced SQL expertise, including database design, query optimization, stored procedures, and performance tuning.
- Strong Python programming skills for automation, analytics, data integration, and data processing.
- Experience with relational database platforms such as Microsoft SQL Server, PostgreSQL, Oracle, or similar technologies.
- Experience developing ETL processes, automated workflows, and data pipelines.
- Experience with business intelligence and visualization tools such as Power BI or Tableau.
- Strong understanding of data architecture, data modelling, governance, and information management principles.