Database Architecture Specialist, Data Governance

Summary

Join MEDFAR Clinical Solutions as a Database Architecture Specialist & Data Governance expert. You will be responsible for establishing and reviewing database structure and architecture, optimizing query performance, and enforcing governance standards. Lead data governance initiatives, enable data accessibility, define access policies, and maintain legal and regulatory compliance. Promote a culture of responsible data use and collaborate with cross-functional teams. This role requires 10+ years of experience in data governance or a related field, expertise in relational databases, and hands-on experience with NoSQL databases. The position offers a permanent, full-time contract with hybrid or remote work options (Quebec region only), performance-based bonuses, generous group insurance, paid time off between Christmas and New Year, and a training allowance.

Requirements

• 10+ years of experience in data governance, data architecture, or equivalent experience in a related data management role
• Demonstrated expertise designing and optimizing relational databases
• Hands-on experience with no-sql databases
• Exposure and understanding of data privacy and compliance frameworks in healthcare for Canada and the US
• Proven ability to develop and implement data governance policies, metadata standards, and access controls
• Strong communication and advisory skills, with a track record of partnering effectively with developers, analysts, security, and product teams
• A methodical and pragmatic mindset, capable of balancing data accessibility, quality, and protection

Responsibilities

• Review and establish database structure and architecture while ensuring performance and scalability across all platforms
• Reviewing and approving database schema changes across teams, with a focus on minimizing long-term risk and maintaining consistency across shared models
• Optimizing query performance and tuning database configurations to ensure reliable, low-latency access to critical data
• Profiling and resolving performance bottlenecks in collaboration with engineering teams—this includes slow queries, locking issues, indexing problems, and inefficient data access patterns
• Monitoring database health and usage patterns, proactively identifying areas for refactoring or architectural improvements
• Enforcing governance standards around data ownership, versioning, and change control to prevent data sprawl and maintain integrity
• Supporting infrastructure and SRE teams in capacity planning, replication strategy, and backup/recovery policies for critical databases
• Lead Data Governance Initiatives: Develop, maintain, and evolve governance policies to support data accessibility, integrity, quality, security and compliance across systems
• Enable Data Accessibility with Guardrails: Partner closely with Analytics and Interoperability teams to enable access to data that is consistent, governed, and performant
• Define Access Policies with the Application Security & SRE teams: Work with the security and site reliability engineering teams to define access roles and levels, ensuring appropriate controls based on users’ roles and responsibilities
• Maintain Legal & Regulatory Compliance: Review and adjust governance policies to align with evolving compliance requirements, internal standards and provincial laws. (e.g., HIPAA, PIPEDA, PHIPA, QC-Law 25, etc.)
• Promote a Culture of Responsible Data Use: Help embed governance practices into development workflows, promote shared accountability for data quality, and foster alignment across cross-functional teams

Preferred Qualifications

• Experience working with health interoperability standards (HL7 / FHIR, etc.)
• Experience working in a SaaS or regulated environment with cross-team data dependencies

Benefits

• Hybrid or remote (from Quebec region only)
• Performance-based bonus for all employees
• Generous group insurance coverage as of day 1 of employment
• Break paid between Christmas and New Years
• Annual $ 1,500 training allowance for your professional development