We have a lot to be proud of at Nicola Wealth. Our sophisticated financial planning, our diversified private investment funds and their exceptional performance, our 99% client retention rate and our award-winning culture, combine to position us as a national leader in wealth management. Recognized as a Best Managed Company and one of Canada’s Top Employers, we are dedicated to upholding our firm’s values through this phase of significant growth.
By bringing together smart, dedicated and supportive colleagues from diverse backgrounds, we deliver extraordinary client service in a values-driven work environment. The collaboration, creativity and entrepreneurial spirit we were founded on provides the opportunity for you to make a real impact and build a rewarding career. We are passionate about our business, our culture and investing deeply in your growth and development to build for the future. If you have this same drive, then let’s talk!
About the Team:
Our Technology Team is a dynamic group of innovators, problem-solvers, and tech enthusiasts. They drive digital transformation, elevate user experiences, and empower our company to thrive in the ever-evolving tech landscape. You will work closely with business analysts and stakeholders to understand their data needs and translate them into logical and physical data models.
Purpose of the Role:
We are looking for a Database Developer and schema designer to join our team and help us create and maintain high-performance, scalable, and reliable databases for our applications and reporting. You will be responsible for designing, developing, testing, and deploying database solutions that meet the business requirements and adhere to the best practices.
Core Responsibilities:
- Design and develop database models, schemas, tables, views, stored procedures, functions, triggers, and indexes using SQL and other tools.
- Optimize and tune database performance, security, availability, and backup/recovery strategies.
- Perform data analysis, validation, cleansing, and migration using ETL tools and scripts.
- Implement and enforce database standards, policies, and procedures.
- Document and maintain database specifications, diagrams, and code.
- Research and evaluate new technologies and trends in the database domain.
- Provide training and guidance to junior database developers.
Required Skills & Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or related field.
- At least 5 years of experience as a database developer.
- Proficient in SQL and relational database management systems (RDBMS) in general.
- Proficient with PostgreSQL and MS SQL Server.
- Proficient in PL/pgSQL, T-SQL, MDX, and DAX languages and query optimization techniques.
- Knowledge of database design principles, normalization, and data modeling techniques.
- Familiar with data warehouse concepts, such as dimensional modeling, star schema, snowflake schema, and OLAP cubes.
- Knowledge of data visualization tools, such as Power BI or Tableau.
- Experience working with MS Fabric or Snowflake is an asset.
Compensation & Benefits Package:
This position comes with a base salary range of $95,000 - $125,000 plus a competitive performance bonus, RRSP contribution and participation in our profit-sharing program. Base salary will be commensurate with experience, skills, and qualifications.
At Nicola Wealth, our people grow our business, delight our clients, and live our values every day. Our comprehensive compensation and benefits package reflects our appreciation for this commitment. Whether it’s participating in our profit sharing and benefit programs on day one, or the opportunity to participate in our share ownership program, our people are able to go beyond a conventional salary and bonus structure. To learn more about our complete package, visit: www.nicolawealth.com/total-rewards.
Please include both a cover letter and resume in support of your application. We are an inclusive, equal opportunity employer. For more information about this and other roles: www.nicolawealth.com/careers.
It is our priority to remove barriers to provide equal access to employment. Should you require reasonable accommodation during the recruitment process please contact us at [email protected] and we will work with you to meet your needs. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Nicola Wealth policies.
Thank you for your interest in a career with Nicola Wealth!
What We Do
Nicola Wealth is a full-service Wealth Management firm with offices across Canada. More than a financial planning firm, we offer sophisticated financial advice and investment management to affluent families, foundations and institutions across North America
