Database Engineer - PriceMetrix
McKinsey & Company
Toronto, ON, Canada
Posted on Friday, February 3, 2023
Database Engineer - PriceMetrix
Who You'll Work With
You will be based in our Toronto office as a member of the product development team at PriceMetrix. You will collaborate with a talented team of data engineers, web engineers, product managers and others.
PriceMetrix is the first choice in practice management software for North American wealth managers. Our solutions use analytics and industry benchmarking to help advisers and their firms better serve their clients and grow their businesses. PriceMetrix directly measures aggregated data representing 10 million investors, $4 trillion in investment assets, 500 million transactions, and 2.5 million fee-based accounts. PriceMetrix combines its patented process for collecting and classifying data with proprietary measures of revenue, assets, and households to create the largest and most insightful retail wealth management data set available today.
What You'll Do
You will develop and deploy enhancements to the PriceMetrix data platform and database infrastructure.
As a member of an Agile team, you will participate in the complete software development lifecycle. You will translate business requirements into technical design as well as break down development tasks and estimate effort. You will apply current technology to evolve and scale our data platform so it can best enable business needs. You will develop high-quality code that satisfies functional, performance and scalability requirements, and collaborate on the review and testing of code changes. You will also create and maintain technical documentation.
As a Database engineer you will support the maintenance and enhancement of the data platform’s infrastructure. You will advise the development team around best practices for performance and scalability. Also, you’ll collaborate with and guide IT and platform operations teams to enable deployment, configuration and troubleshooting.
Qualifications
• Post-secondary education in computer science, information technology, or a similar discipline
• Software development experience using Agile methods, especially Scrum
• Experience in optimizing the physical aspects of RDBMS and knowledge of cloud and on-premise infrastructure is a requirement
• Strong in SQL coding, debugging, and optimization
• Experience in databases for analytics, especially using Microsoft SQL Server and Azure database services
• Knowledge of data warehousing is desirable, including ETL/ELT patterns
• Highly numerate, detail-oriented, and able to use complex data sets
• Experience applying DevOps practices, automated deployment and testing is desirable
• Ability to work collaboratively in a team environment
• Excellent communication skills
Industries
Capabilities
FOR U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by applicable law.
FOR NON-U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity employer. For additional details regarding our global EEO policy and diversity initiatives, please visit our McKinsey Careers and Diversity & Inclusion sites.
share this job
Job Skill Group - N/A
Job Skill Code - GCOB - Data Engineer II
Function - Technology
Industry - Financial Services;Infrastructure
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Mar 30 00:00:00 GMT 2022
LinkedIn Posting City - Toronto
LinkedIn Posting State/Province - Ontario
LinkedIn Posting Country - Canada
LinkedIn Job Title - Database Engineer - PriceMetrix
LinkedIn Function - Consulting;Information Technology
LinkedIn Industry - Computer Software;Financial Services
LinkedIn Seniority Level - Entry level
Job Skill Code - GCOB - Data Engineer II
Function - Technology
Industry - Financial Services;Infrastructure
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Mar 30 00:00:00 GMT 2022
LinkedIn Posting City - Toronto
LinkedIn Posting State/Province - Ontario
LinkedIn Posting Country - Canada
LinkedIn Job Title - Database Engineer - PriceMetrix
LinkedIn Function - Consulting;Information Technology
LinkedIn Industry - Computer Software;Financial Services
LinkedIn Seniority Level - Entry level