Lead Data Architect

 

Description:

We have an opportunity for a Lead Data Architect to join our Data Engineering team. Reporting to the Director of Data Engineering, you will:

 

  • Lead a team of Data Engineers to redesign and to refactor the layers in our ETL function and financial database calculations.
  • Ensure a robust and flexible data ingestion pipeline drawing from a wide range of global data vendors.
  • Research and recommend best practices for data management, ensuring the architecture aligns with overall technology and business needs.
  • Implement and maintain a rich catalogue of quantitative factor formulas.
  • Be hands-on in implementing core components and refactoring the required databases and processes.
  • Ensure timely completion of daily as well as intraday production jobs, providing occasional off-hours support.
  • Identify bottlenecks and resolve concurrency deadlocks in high-traffic databases or tables.
  • Improve and optimize the speed of complex SQL stored procedures and functions.

 

You'll play a pivotal role at our firm, making significant contributions to our hyper-innovative culture. Your work will be highly valued and recognized, driving our data architecture forward.

 

WHAT WILL YOU BRING?

 

  • A minimum of 8 years of experience architecting databases in a financial industry
  • Degree(s) in Computer Science, Engineering, Math, or a related discipline
  • Experience working with financial datasets and data vendors (e.g. Capital IQ, FactSet, Refinitiv, etc.)
  • Demonstrated experience in data architecture design and database administration
  • Proficiency with large dataset extraction and manipulation in SQL
  • Basic understanding of financial statements, ratios, and investment concepts
  • Advanced programming skills in SQL and data schema design
  • Attention to detail with a high level of accuracy in analysis
  • Ability to communicate across investment and technical teams
  • Motivated quick learner with ability to work in a fast-paced environment and meet deadlines

Apply Now
You'll sign in or register, then come back to this job.
No resume yet? Make one free and apply.
Organization Hillsdale Investment Management Inc.
Industry Architect / Interior Design Jobs
Occupational Category Lead Data Architect
Job Location Toronto, ON, Canada
Shift Type Morning
Job Type Full Time
Gender No Preference
Career Level Experienced Professional
Experience 8 Years
Posted at 2024-12-04 3:35 pm
Expires on 2026-12-21