Data Quality Analyst - Business Intelligence
CAMH
- Toronto, ON
- Permanent
- Full-time
- Apply the CIHI data quality framework to assess data quality across CAMH Measurement Based Care implementations.
- Implement data quality improvement initiatives, including data cleansing, validation, and enrichment.
- Creation and iterative refinement of data mappings to standard interoperable data models and ontologies
- Managing data assets, data lineage and data access, supporting sound data analysis
- Defining data quality dimensions and metrics to measure adherence to organizational data quality standards
- Coordinating end-to-end data flows and identifying data dependencies in support of delivery, release, and change management and ensuring long-term data reusability.
- Developing data visualizations (e.g. Dashboards) to support stakeholders, and iterating to account for new data and requirements.
- Collaborate with clinicians and data experts to understand data requirements and standards.
- Identify data quality issues and anomalies and develop strategies to address them.
- Create and maintain data quality reports and documentation.
- Monitor and track data quality metrics, trends, and performance.
- Provide guidance and training to staff on data quality best practices.
- Work closely with the Director of Strategy and Business Intelligence to ensure data quality aligns with organizational goals.
- Participate in cross-functional projects related to data governance and data management.
- Bachelor's degree in a relevant field (e.g., Data Science, Health Informatics, Statistics).
- Proven experience in data quality assessment and improvement.
- Expertise in the CIHI data quality framework
- Experience processing and reviewing large amounts of data and practice of matching/merging datasets
- Strong data transformation and data analysis experience with Python
- Strong experience with Structured Query Language (SQL)
- Experience creating and maintaining metadata and applying best practices to managed content.
- Strong knowledge of data engineering systems, data models, and data structures.
- Experience with creating data flows (Apache NiFi).
- Expertise working with versioning control systems, package management software and software development life cycles.
- Solid understanding of key DBMS platforms like SQL Server, Oracle and DB2, including technical expertise in data architecture principles and design aspects of various DBMS and reporting concepts.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and data accuracy.
- Experience with healthcare data or mental health data is preferred.
- Strong communication and collaboration skills.
- Ability to work independently and as part of a team.
- Excellent organizational and planning skills
- Strong problem-solving and analytical skills
- Excellent client-relations skills
- Strong oral and written communication skills
- Ability to effectively prioritize and execute tasks in a high-pressure environment
- Experience working in a team-oriented, collaborative environment
- Able to deal with conflict in a professional manner
- Bilingualism (French/English) and/or proficiency in another language are considered an asset
- Domain knowledge in medical data preferred (integrated healthcare and ontological schema)
- Proficiency and proven experience with ontology engineering and semantic technologies
- Experience with RDF, OWL, JSON-LD, SHACL and SPARQL
- Experience with search technologies (e.g., Elasticsearch), graph databases, graph traversal and NoSQL databases