Senior Data Engineer

Senior Data Engineer – PriceMetrix

About Coalition Greenwich and PriceMetrix

PriceMetrix is a prominent entity within Coalition Greenwich, and the premier provider of practice management software for wealth management firms across North America.

Leveraging advanced analytics and industry benchmarking, PriceMetrix empowers financial advisors and their firms to enhance their client experience and effectively drive business growth.

Coalition Greenwich builds analytics and business intelligence products that are integral to how the world’s largest corporate and investment banks and fintechs measure, plan and improve their businesses.

These products include market analysis and benchmarking against peers on market share, technology, revenue performance, client relationship share and quality, operational excellence, return on equity, brand perception, behavioural drivers, and analysis on industry evolution.

Our customers include all of the largest financial institutions, and we are the market leader in our space.

Coalition Greenwich is a division of CRISIL, a $5bn market cap global analytics company which is majority owned by S&P Global.

About The Role

Crisil is seeking a seasoned data engineer to join the team that develops the PriceMetrix SaaS products.

As an Agile team member, you will lead the technical design and implementation of product enhancements. You will drive innovation, help define the future state architecture, and apprentice other engineers. An industry leader in data analytics, Crisil provides opportunities to develop your leadership and technical skills. We offer a combination of working in our office in downtown Toronto and at home.

Key Responsibilities

• Lead technical design, planning, and implementation of major product enhancements
• Collaborate with cross-functional team to translate business requirements into pragmatic technical solutions
• Facilitate collaborative problem-solving sessions to determine technical design, engineering tasks, and estimate effort
• Design and optimize solutions to satisfy demanding performance, scalability, and security requirements
• Contribute to coding standards and conduct code reviews
• Partner with Infrastructure/IT and Platform Operations teams to improve deployment, configuration, operation, and troubleshooting
• Proactively identify and advocate for improvements to technology and engineering methods
• Effectively communicate business benefits and implications of technical initiatives to non-technical and more senior colleagues
• Contribute to professional development of colleagues by coaching and structured training
• Maintain related documentation

Knowledge and Skills

• Expertise in developing complex business intelligence (BI) and data warehousing solutions
• Advanced SQL coding and applied knowledge of relational database engines: Microsoft SQL Server, MySQL, or PostgreSQL
• Applied knowledge of modern data platforms: Databricks, Fabric, or Snowflake
• Strong knowledge of data architecture: dimensional modeling, lakehouse/medallion, and advanced ETL/ELT design
• Expertise in physical design and optimization of infrastructure for databases and data processing: on-premises/IaaS and PaaS in Azure or AWS
• Experienced in database maintenance, performance monitoring, and debugging
• Objectively assess potential solutions by balancing business value and technical complexity
• Keen practitioner of Agile methods, especially Scrum
• Apply DevOps practices to automate deployment and testing of databases, ETL/ELT processes, and statistical calculations
• Highly organized and able to balance multiple parallel projects
• Effectively communicate complex topics to technical and non-technical colleagues
• Experience as a people manager is desirable

Qualifications

• Proven success in leading the engineering of large-scale databases and data processes
• 8+ years of professional data engineering experience
• Post-secondary education in Computer Science or a similar discipline

What we can offer

• A competitive base salary and variable annual bonus
• A flexible hybrid working policy. Most people come into the office 2-3 days/week.
• A healthy work-life balance. Most people have been here over 6 years.
• A low-politics working environment. Everyone gets on, but we’re not a “family”. We’re all interested in getting good work done.
• 25 days annual leave, plus public holidays
• Group insurance benefits
• Generous employer pension contribution
• An annual personal development allowance

Application process

1. Apply with your latest CV/resume. We receive a lot of applications and are only able to contact shortlisted candidates. If you have not heard from us within two-weeks, we’ve likely moved forward with other applicants this time.

2. An initial ~30-minute screening call with someone from our recruitment team to cover your most relevant experience and basic information.

3. Round 1: 1-hour interview via Teams with hiring manager from the Engineering team.

4. Round 2 Part 1: 75-minute technical interview via Teams with two senior members of the Engineering team.

Round 2 Part 2: 45-minute leadership interview via Teams with Product team leader.

5. Final round: A take-home challenge/case study. This will be delivered in a collaborative 60-minute in-person session with a small, cross-functional group.