Database Developer

at  Nicola Wealth

ABOUT NICOLA WEALTH:

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!

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.

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.