Job Senior Database Architect in Toronto

Our Company

Picton Mahoney Asset Management (“PMAM”) was founded in 2004 to provide unique investment solutions to institutional, retail and high net worth investors in Canada and around the world. We are proud to say that we are 100% employee-owned and manage approximately $10 billion in sub-advisory, pension plan and hedge fund assets on behalf of our clients. We are honoured to make the ranks as one of Canada’s Top-8 Employers as recognized through Great Place to Work™ in 2020 and 2021, Canada’s 2020 and 2021 Best Workplaces™ in Financial Services & Insurance, 2021 Best Workplaces™ for Women, 2021 Best Workplaces for Inclusion, and 2020 and 2021 Best Workplace™ in Ontario. The core values at Picton Mahoney guide the employee experience and contribute to the culture which fosters strong, transparent relationships.

Why Work at Picton Mahoney?

Picton Mahoney Asset Management is a place where employees can be proud of building a rewarding career that offers growth and the opportunity to evolve within a supportive culture that focuses on professional development. Over the past 15 years, we have learned from feedback and have developed strategies and programs that enhance employee engagement and improve the employee experience. As our values state: We work together; fully engaged and aligned. We support each other, and our actions contribute to the strategic goals of our firm. We are highly focused on continuous improvement while driving positive change and stronger results across our team and the firm. We believe in integrity and always “doing the right thing” for our clients, colleagues and the firm. We are committed to performance, excellence and winning. At Picton Mahoney, “stepping up” is an action, not a thought, which results in the development and implementation of those ideas. We accept full responsibility for personal performance and results. We believe in being open when providing and receiving feedback, because it makes us better at what we do best.

The Opportunity

Picton Mahoney Asset Management is presently seeking a Senior Data Architect to lead the newly formed Data team. Using your excellent communication skills, you are capable of conversing with both technical and non-technical colleagues and are comfortable contributing to a highly multidisciplinary team. If you believe that you are a true techie at heart and feel empowered working on innovative technology that makes a difference, this could be the opportunity for you!

Your core responsibility will be to develop, optimize, and oversee our company’s conceptual and logical data systems. Your duties may include preparing architect reports, monitoring the system, and supervising system migrations.

You will work with agency partners and other stakeholders to build and maintain the company’s databases, identifying the optimal structural and installation solutions. This includes creating database solutions, evaluating requirements, and preparing design reports.

To succeed in this role, you should know how to examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.

Responsibilities of the Role

• Design and implement effective database solutions and models to store and retrieve company data.
• Examine and identify database structural necessities by evaluating client operations, applications, and programming.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Work with agency partners to install and organize information systems to guarantee company functionality.
• Prepare accurate database design and architecture reports for stakeholders and executive teams.
• Oversee the migration of data from on prem. systems to cloud solutions.
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
• Recommend solutions to improve new and existing database systems.
• Educate staff members through training and individual support.
• Research and properly evaluate sources of information to determine possible limitations in reliability or usability
• Install and configure information systems to ensure functionality
• Analyze structural requirements for new software and applications
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements
• Optimize new and current database systems
• Define security and backup procedures

The Qualifications and Experience Required

• Bachelor’s degree in computer science, computer engineering, or relevant field.
• A minimum of 5 years’ experience in a similar role.
• Strong knowledge of database structure systems and data mining.
• Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
• Solid understanding of star schema data modeling and slowly changing dimensions
• Azure-based data platform maintenance experience
• Expertise in deploying and managing Azure Databricks workspaces, clusters, hive metastores
• Familiarity with ‘Databricks SQL’ persona, SQL Warehouses, schemas/tables/permissions etc.
• Expertise in building and deploying pipelines using Azure Data Factory
• Data Lake Management (Azure Data Lake Storage)
• Familiarity with Infrastructure, e.g., Databricks networking requirements, Azure Infrastructure components, CICD pipelines, YAML
• Experience gathering and analyzing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in MS SQL
• Expertise in MS Excel
• Familiarity with data visualization tools (e.g. Power BI, Tableau, D3.js and R)
• Experience working with private and sensitive personal information
• Certifications: Azure Certifications preferred

Competencies of a Successful Leader at Picton Mahoney

• Results-Oriented: Does everything to be as productive as possible; keeps 100% focused on work; takes initiative to start and complete tasks.
• Collaboration: Relates well to all kinds of people, up, down and sideways, inside and outside the organization. Builds appropriate rapport; Builds constructive and effective relationships using diplomacy and tact; Can diffuse even high-tension situations comfortably.
• Critical Thinking: Able to objectively examine assumptions and beliefs; Makes decisions that impact problems at their cause rather than just the symptom; Uses a decision-making approach that is fair and accurate; Demonstrates insightful understanding of the organizational context and priorities; Foresees long-term implications of proposed positions.
• Customer Focus: Communicates in a positive manner, especially when handling complaints or conflict; efficiently obtains additional resources as needed to satisfy customer needs. Can refer internal or external people to the correct person in the organization
• Cultivates Innovation: Total understanding of the marketplace for products and services (what are the benefits to your customer and why do they buy your product); Is able to select from among many possible creative ideas for new products and services, those which would have the highest likelihood of success in the marketplace; Taking the raw idea and managing the transition to a successful product or process in the marketplace.
• Functional/Technical Skills: Understands technical expectations of the job and uses all resources available to improve effectiveness within the organization.
• Passion for Results: Can be counted on to exceed expectations on a regular basis; Is constantly and consistently one of the top performers; Very bottom-line oriented; Steadfastly pushes self and others for results
• Personal Learning or Self-Development: Engages in continuous self-development; Tackles challenges with enthusiasm and determination; Admits mistakes and openly identifies opportunities for personal growth; Knows personal strengths, weaknesses, opportunities, and limits

Above all, we’re looking for individuals with a mindset to think differently and who are inspired to make BIG impact. If you think that you will excel in this multi-faceted role, we want to hear from you!

Our Commitment to Employees

Picton Mahoney Asset Management is proud to offer our employees with generous perks and programs that enhance the career experience with our firm, including: Corporate Wellness & Fitness Reimbursement, Maternity and Parental Leave Top-Up, Peer Performance Recognition Awards, Semi-Annual Performance Bonuses, Generous Annual Vacation Entitlement (minimum of 15 days/year), Tuition Reimbursement, Extensive Medical & Dental Benefits, Healthcare Spending Account and more.

Health and Safety

We are doing our part to ensure the health and safety of all of our employees and visitors and to reduce the spread of COVID-19. Our office will allow for social distancing and ensuring new routines are followed, such as hand sanitizing, thorough disinfection and cleaning, mask wearing, and other protective equipment. In addition, all employees and visitors who visit our office will be mandated to be fully vaccinated against COVID-19.

Picton Mahoney Asset Management is proud to be recognized by Great Place to Work® as a 2021 “Best Workplaces for Inclusion” and 2021 “Best Workplaces for Women”. We are committed to providing an equitable and fair work environment for everyone and all hiring and other personnel actions will be taken without regard to race, colour, creed, religion, sex, disability, gender identity, gender expression, family status, age, language or national origin. If you require an accommodation at any point in time throughout the application and hiring process, please contact Human Resources at (416) 955-4108 or at accessibility@pictonmahoney.com.