Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Hamilton ETFs is building a modern, cloud-native, ML-ready data platform to support transactional workloads, analytics, regulatory reporting, and future AI capabilities. This role offers the opportunity to design and build this platform from the ground up, shaping the future of data and AI at a growing investment firm.

Responsibilities

• Design and manage the core relational database architecture serving as the shared foundation for the platform's applications.
• Design scalable data models supporting advisor intelligence, CRM, marketing, compliance, reporting, and customer-facing applications.
• Own database performance, including indexing, partitioning, query optimization, replication, backups, recovery, and high availability.
• Establish robust data governance practices, including role-based access control, audit logging, encryption, data lineage, and retention policies aligned with Canadian regulatory requirements.
• Support secure ingestion, normalization, and deduplication of large financial-industry datasets.
• Design structures that support ML features such as lead scoring, intent detection, advisor similarity, anomaly detection, and natural-language reporting.
• Work with Full Stack Developers to define API-ready patterns, stored procedures, and efficient service-layer access.
• Ensure clean, governed data flows into HubSpot as the commercial source of truth.
• Help design future infrastructure, including data warehouse, event streaming, vector database, semantic search, and analytics layers.
• Document standards, naming conventions, backup procedures, security controls, and data lifecycle policies.
• Undertake other work or special projects assigned for the overall benefit of Hamilton ETFs.

Requirements

• Strong understanding that the database is the foundation of the product, with a passion for performance, security, clean data models, maintainability, and future flexibility.
• Comfort in an early-stage environment and energized by creating a strong foundation.
• Ability to work closely with application developers and product leadership.
• Strong documentation and operational discipline.
• Architectural mindset with the ability to design systems that will scale as products, data volumes, and AI capabilities evolve.
• Post secondary diploma in computer science, computer engineering or other relevant programs.
• 5+ years designing and supporting relational databases as a Database Engineer, Data Engineer, Database Developer, or similar role.
• Strong PostgreSQL experience: performance tuning, indexing strategies, schema design, and database security.
• Experience designing databases for SaaS, CRM, workflow, reporting, or financial services platforms.
• Strong grasp of data privacy, auditability, role-based access control, encryption, backup, and disaster recovery.
• Experience with ETL/ELT pipelines, data imports, deduplication, validation, and large structured datasets.
• PostgreSQL at scale: partitioning, replication, read replicas, materialized views, and query profiling.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Experience with data warehouse or analytics tooling.
• Experience with vector databases such as pgvector, Qdrant, Pinecone, Weaviate, or similar.
• Experience supporting ML workflows, semantic search, embeddings, or LLM-backed applications.
• Experience in financial services, wealth management, asset management, capital markets, or regulated environments.
• Familiarity with SOC 2, ISO 27001, audit controls, data retention, and compliance reporting.
• Experience with event-driven architectures, message queues, or streaming pipelines.

Skills

• PostgreSQL
• Performance tuning
• Indexing strategies
• Schema design
• Database security
• SaaS database design
• CRM database design
• Workflow database design
• Reporting database design
• Financial services database design
• Data privacy
• Auditability
• Role-based access control
• Encryption
• Backup
• Disaster recovery
• ETL/ELT pipelines
• Data imports
• Deduplication
• Data validation
• Large structured datasets
• Cloud platforms (AWS, Azure, GCP)
• Data warehouse tooling
• Analytics tooling
• Vector databases
• ML workflows
• Semantic search
• Embeddings
• LLM-backed applications
• Event-driven architectures
• Message queues
• Streaming pipelines

Location

• Toronto, ON

Work Type

• 100% onsite
• Full-Time Permanent

Experience Level

• 5+ years designing and supporting relational databases
• Depending on experience

Education Level

• Post secondary diploma in computer science, computer engineering or other relevant programs
• Masters Degree an asset

Salary/Compensations

• $110,000 - $125,000 plus incentive compensation

Benefits

• Competitive compensation package
• Comprehensive health and wellness benefits

About the Company

• Hamilton ETFs is one of Canada’s fastest growing exchange traded fund (“ETF”) providers.
• Based in Toronto’s financial district with ~$17 billion in ETF assets under management.
• Seeking a motivated individual to join an entrepreneurial team of experienced and talented professionals.

Equal Opportunity

• Hamilton ETFs is committed to meeting the accessibility needs of all applicants throughout the recruiting and selection process. Please let us know about any accommodation and/or support requirements.
• Please note only those candidates selected for an interview will be contacted.
• Hamilton ETFs is working in partnership with HR à la carte for our recruitment efforts.
• Please note: we are only accepting applications from those authorized to work in Canada and we are not currently sponsoring any temporary or permanent work visas.
• Some stages of our recruitment process may use AI-assisted tools to support recruitment efforts; however, all applications are screened and assessed by human reviewers. In addition, all final hiring decisions are made by humans.