Data Architect/Modeller - Senior
LanceSoft View all jobs
- Toronto, ON
- Permanent
- Full-time
Location: 5700 Yonge Street, Toronto, ON
Duration: 250 Business Days
Assignment Type: Onsite (5 Days per Week, 7.25 Hours/Day, 8:00 AM - 5:00 PM)Role DescriptionTechnical Skills and Experience7+ years developing conceptual, logical, and physical data modelsExperience with relational, star, and snowflake schemasProficiency with ERWIN, Visio, PowerDesignerExperience with master data management and common data modelsSchema design balancing governance, flexibility, and qualityData partitioning, clustering, and indexing strategiesMetadata management and governance implementationCreation of enterprise architecture artefacts4+ years designing data lake / lakehouse schemas3+ years implementing Medallion architectureHands-on experience with:Azure Data FactoryAzure Data Lake StorageAzure DatabricksCore Skills and Experience10+ years solutions development experienceExperience with complex data integrationMonitoring and enforcing modeling standardsExperience with privacy and security in health systemsKnowledge of security and recovery proceduresExperience with relational and hierarchical databasesExperience with information retrieval systemsProduction troubleshooting and performance tuningKnowledge of information management principlesPublic Sector Experience5+ years working with public-sector healthcare providersKnowledge of Public Sector Enterprise Architecture artifacts and practicesKnowledge of PMI and public-sector project methodologiesExperience with health-related public-sector projectsKnowledge of ministry policy and IT approval processesExperience with Unified I&IT Project Methodology and gating processesExperience with large, complex health IT projects