Description
Your career is an investment that grows over time!
Wealthsimple is on a mission to help everyone achieve financial freedom by reimagining what it means to manage your money. Using smart technology, we take financial services that are often confusing, opaque and expensive and make them transparent and low-cost for everyone. We’re the largest fintech company in Canada, with over 3+ million users who trust us with more than $100 billion in assets.
Our teams ship often and make an impact with groundbreaking ideas. We're looking for talented people who keep it simple and value collaboration and humility as we continue to create inclusive and high-performing teams where people can be inspired to do their best work.
The Data Foundation team is part of Platform Engineering org in Wealthsimple. The team consists of talented software developers and database admins/developers and is divided into three sub-teams: Data Stores, Data Integrations, and Data Streaming.
We're seeking an experienced Data Engineer/Database Administrator to join our Data Stores team. In this role, you'll be responsible for architecting, maintaining, and administrating our primary analytics data warehouses on Redshift & Snowflake. In addition, you will collaborate with key stakeholders to ensure excellence of operation for our fleet of RDS Aurora Postgres DBs.
These data stores collectively power critical financial operations and client data, and a successful candidate will work closely with our Data Science, Engineering, and Product teams to optimize database performance, ensure data integrity, and implement scalable solutions as we continue to grow.
A successful candidate is expected to have deep technical expertise in at least one of these Database technologies and the aptitude and inclination to learn the rest.
In this role you’ll have the opportunity to:
Design, implement, and maintain database infrastructure across development, testing, and production environmentsMonitor database performance and implement optimizations to improve query efficiencyDevelop and maintain backup/recovery procedures and ensure data integrityImplement and manage database security measures, including access controls and encryptionCreate Python scripts for database automation, monitoring, and maintenance tasksCollaborate with engineering teams to optimize database schemas and queriesProvide guidance on database best practices and participate in code reviewsPlan and execute database upgrades and migrations with minimal downtimeCreate and maintain comprehensive documentation for database architecture and proceduresParticipate in on-call rotation for database-related issues
What you’ll bring:
5+ years of hands-on administration experience in production environments for at least one of: Redshift, Snowflake, PostgreSQL. Proficient in Python scripting for database automation and management tasksStrong understanding of database internals, optimization, and performance tuningExperience with high-availability deployments and disaster recovery strategiesKnowledge of database security best practices and compliance requirementsExperience with database monitoring, alerting, and troubleshootingSolid understanding of indexing strategies, query optimization, and execution plansFamiliarity with Terraform and GitHubExperience with infrastructure-as-code and database change management toolsStrong problem-solving skills and attention to detailStrong communication skills and the ability to work with a diverse group of stakeholders
Bonus skills:
Experience with cost optimization operations, especially within AWSExperience with financial technology systems and related compliance requirementsExperience with container orchestration platforms like KubernetesKnowledge of additional databases beyond the ones listed aboveContributions to open-source database projects or toolsFamiliarity with data observability and visualization tools (Preset, Datadog, etc.)
Additional Information
Why Wealthsimple?
🤑 Competitive salary with top-tier health benefits and life insurance
📈 Retirement savings matching plan using Wealthsimple for Business
🌴 20 vacation days per year and unlimited sick and mental health days
📚 Up to $1,500 per year towards wellness and professional development budgets respectively
🌎 A wide variety of peer and company-led Employee Resource Groups (ie. Rainbow, Women of Wealthsimple, Black @ WS)
💖 Company-wide wellness days off scheduled throughout the year
We’re a remote-first team, with over 1,000 employees coast to coast in North America. Be a part of our Canadian success story and help shape the financial future of millions — join us!
Technology & Innovation at Wealthsimple
We believe the future belongs to those who innovate boldly. At Wealthsimple, every team member is expected to lean into new technologies, including AI, and tooling to rethink how we work, solve problems faster, and create even greater value. We're looking for people who are not just comfortable with change but energized by it. Our commitment is to build a company that evolves at the pace of the world around us, and we want you to help lead that future.
DEI Statement
At Wealthsimple, we are building products for a diverse world and we need a diverse team to do that successfully. We strongly encourage applications from everyone regardless of race, religion, colour, national origin, gender, sexual orientation, age, marital status, or disability status.
Accessibility Statement
Wealthsimple provides an accessible candidate experience. If you need any accommodations or adjustments throughout the interview process and beyond, please let us know, and we will work with you to provide the necessary support and make reasonable accommodations to facilitate your participation. We are continuously working to improve our accessibility practices and welcome any feedback or suggestions on how we can better accommodate candidates with accessibility needs.