Lead Data Architect
Posted: November 11, 2024
Hillsdale is an independent, employee-controlled, and client-aligned investment boutique managing more than $6 billion on behalf of a select group of sophisticated institutional and private wealth investors. We are renowned for designing systematic, bespoke investment strategies across diverse objectives, including over 15 investment strategies focusing on high alpha, ESG, customized, and smart beta. We are committed to producing the highest quality equity investment strategies and delivering client service excellence. Hillsdale is recognized for investment and service excellence – a reflection of our relentless pursuit of research and development and the dedication of our employees who invest alongside our clients.
Hillsdale has been recognized as a Great Place to Work for our industry and across Canada.
WHAT’S THE OPPORTUNITY?
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
Nice to Have (preferred but not required)
• CFA, FRM or related designation
• Prior work experience in the quantitative investment industry
• Experience with unstructured data
• Advanced Excel user
• Programming skills in other languages a plus: Python, VBA, Java, C/C++, etc.
WHAT’S IN IT FOR YOU?
• Competitive salary, performance bonus and paid vacation time.
• Health Care Spending Account.
• Professional Development, ongoing mentorship and growth opportunities/defined career pathing.
• Supportive amenities and initiatives: access to a fully stocked kitchen, catered lunches, ergonomic home office setup, complimentary gym membership, regular employee appreciation events, and retreats. We also support charities and provide you with paid time off for your volunteer interests.
• Flexible work environment and commuting reimbursement when you do work from the office.
• Centrally located office at King and Bay with remarkable views of Toronto and Lake Ontario.
Application Deadline: This job posting will remain open until the position is filled.
Hillsdale is an equal opportunity employer and as such does not discriminate based on race, colour, religion, sex, national origins, age, sexual orientation, disability or any other characteristic protected by applicable laws. We encourage applications from people of all abilities and will make reasonable accommodations upon request.
Not sure if you qualify? Apply anyway! Our workforce comes from diverse backgrounds and industries. Please forward a resume to careers@hillsdaleinv.com. Both full-time and contract arrangements will be considered.
We thank all interested applicants, however, only those selected for an interview and legally eligible to work in Canada will be contacted.