Principal Data Architect
PointClickCare View all jobs
- Mississauga, ON
- Permanent
- Full-time
- Establish Product & Engineering-wide standards for schemas, naming conventions, event patterns, canonical models, and data representation.
- Define how data persists across multiple layers (OLTP, OLAP, lakehouse, vector stores, feature stores) based on scale, performance, access patterns, governance, and compliance requirements.
- Set best practices for partitioning, sharding, indexing, storage tiering, lifecycle management, and performance optimization.
- Drive reduction of storage and compute costs through architectural optimization, compression, deduplication, and workload rationalization.
- Lead technology evaluations and define decision frameworks (e.g., Databricks vs Snowflake, Hudi vs Delta vs Iceberg, lakehouse vs warehouse, batch vs streaming).
- Define when to use batch, micro-batch, streaming, and event-driven architectures across domains.
- Architect data foundations that power AI/ML and GenAI use cases, including semantic layers, feature stores, and vector-based retrieval (RAG).
- Establish governance guardrails for PHI/PII, interoperability standards (FHIR, USCDI), and data contracts.
- Bridge Product and Engineering toward a common data language, replacing fragmented local conventions with standards.
- Drive architectural decisions when teams are misaligned; balance long-term integrity with near-term delivery pressure.
- Protect PCC's ability to own, leverage, and commercialize its data assets while meeting interoperability obligations.