Lead Data Architect

4 months ago


Canada Hillsdale Investment Management Inc. Full time

LEAD DATA ARCHITECT


Hillsdale Investment Management Inc. (Hillsdale) is an independent, employee-controlled, and client-aligned investment boutique managing investments on behalf of a select group of sophisticated institutional and private wealth investors. We engage in disciplined active investment management, specializing in equities, alternatives, ESG, and customized mandates. We are committed to producing the highest quality equity investment strategies. Hillsdale is recognized for both 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 a plus
  • Advanced Excel user a plus
  • 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.



  • Canada Resonaite Full time

    About the RoleWe are seeking an experienced Data Architect to lead our end-to-end data architecture efforts for a critical system rebuild project. As a key member of our team, you will be responsible for designing and implementing scalable, future-ready data integration solutions.The successful candidate will have expertise in SAP and a proven track record...

  • Lead Data Architect

    5 days ago


    Canada, CA Themesoft Inc. Full time

    Position: Lead Data ArchitectLocation: Canada – RemoteJob Description:Work independently to solve open-ended questions.Help lead and manage the design, testing, and implementation of databases (Azure SQL and/or Snowflake) that support productionized BI dashboards (PowerBI, Tableau) and custom analytic applications.Focus on the coding visuals for the...


  • Canada PrecisionERP Incorporated Full time

    Job OverviewPrecisionERP Incorporated is seeking an experienced Senior Data Architect to lead our cloud data platform initiatives.About the RoleThis full-time, 35-hour per week position offers a hybrid work arrangement with 2 days on-site in downtown Montreal and 3 days remotely.Estimated Salary: $120,000 - $160,000 per year, based on industry standards and...


  • Canada OnX Full time

    Job OverviewWe are seeking an experienced Lead Data Engineering Architect to join our team at OnX in Calgary. As a key member of our data engineering group, you will be responsible for driving the technical vision and strategy for our data platform.About the RoleThe successful candidate will have a minimum of 7 years of experience in a data engineering role,...


  • Canada TES The Employment Solution Full time

    Job DescriptionWe are seeking an experienced Data Storage Architect Lead to join our team at TES The Employment Solution. In this role, you will be responsible for monitoring, supporting, and enhancing associated storage, backups, and data replication for a large number of Sysplexes.You will provide support for Disaster Recovery Exercises and new data center...

  • Data Architect Lead

    7 days ago


    Canada Hillsdale Investment Management Inc. Full time

    Hillsdale Investment Management Inc. is a leading investment boutique managing investments on behalf of sophisticated institutional and private wealth investors.Competitive Salary: $120,000 - $180,000 per yearWe engage in disciplined active investment management, specializing in equities, alternatives, ESG, and customized mandates. Our team is committed to...

  • Data Architect Lead

    3 days ago


    Canada Themesoft Inc. Full time

    Lead Data ArchitectWe are seeking a skilled Lead Data Architect to join our team at Themesoft Inc. in Canada, with the opportunity to work remotely.Job OverviewThe ideal candidate will have experience in designing, testing, and implementing databases that support productionized BI dashboards and custom analytic applications.Key ResponsibilitiesDevelop...


  • Canada Agility Partners Full time

    Job DescriptionAgility Partners is seeking a seasoned Cloud Data Architect Lead to spearhead data pipeline development, model and prepare data, perform complex data analysis to address business queries, build and automate data pipeline and quality framework to empower self-service data pipelines, and assist in operationalizing AI/ML engineering...


  • Canada Amicon Hub Services Full time

    About Amicon Hub ServicesWe are a leading provider of innovative data modernization, analytics and AI solutions. Our team specializes in leveraging cutting-edge technologies to help businesses build and manage scalable data lakes and data lakehouses.Job DescriptionThis role involves designing, implementing, and optimizing our next-generation data lake...


  • Canada Themesoft Inc. Full time

    About the Role:We are seeking a seasoned Lead Data Architect to join our team at Themesoft Inc. in Canada.As a key member of our organization, you will play a crucial role in designing, implementing, and managing databases that support our productionized Business Intelligence (BI) dashboards and custom analytic applications.Main Responsibilities:Work...


  • Canada IMCS Group Full time

    Job Title: Data Solutions ArchitectAbout the Role:We are seeking an experienced Data Solutions Architect to join our team at IMCS Group in Edmonton, AB. This is a 6-month contract position with possible extension.About the Job:The proposed resource must meet or exceed one of the following criteria:University graduation in business, management, or a related...


  • Canada Hillsdale Investment Management Inc. Full time

    Hillsdale Investment Management Inc. is a leading investment boutique managing investments for institutional and private wealth clients.We are seeking an experienced Lead Data Architect to join our Data Engineering team, responsible for redesigning and refactoring our ETL function and financial database calculations.The ideal candidate will have a minimum of...


  • Canada LeverageTek Staffing Solutions Full time

    About the RoleLeverageTek Staffing Solutions is seeking a highly skilled Senior Data Architect to lead our data architecture initiatives. This is a 6-month contract opportunity with a remote work arrangement and occasional travel to Montreal (5-10% travel requirement).Key ResponsibilitiesDevelop and implement data ETL procedures, standards, and metrics to...


  • Canada Sigmoid Full time

    About Sigmoid Analytics:We are a cutting-edge data analytics company that empowers businesses to make informed decisions through real-time insights. Leveraging cloud and open-source technologies, we build modern data architectures that drive business transformation. Our expertise in data engineering, predictive analytics, artificial intelligence, and DataOps...

  • Cloud Data Architect

    24 hours ago


    Canada hireVouch Full time

    We are seeking a highly skilled Cloud Data Architect to join our team at hireVouch.As a Cloud Data Architect, you will play a critical role in designing and implementing data environments to support reporting and analytics for our clients.The ideal candidate will have experience with AWS infrastructure and technologies, including DMS, Glue, and Step...

  • Data Architect

    5 days ago


    Canada IMCS Group Full time

    Data Architect – Intermediate6 Months Contract with possible extensionRemote / Edmonton, ABThe proposed resource must meet or exceed one of the following:University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience.OR2-yr diploma in business, management or a related discipline and 4-yr DA experience.OR1-yr...

  • Data Architect

    4 days ago


    Canada IMCS Group Full time

    Data Architect – Intermediate6 Months Contract with possible extensionRemote / Edmonton, ABThe proposed resource must meet or exceed one of the following:University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience.OR2-yr diploma in business, management or a related discipline and 4-yr DA experience.OR1-yr...

  • Data Architect

    4 days ago


    Canada IMCS Group Full time

    Data Architect – Intermediate 6 Months Contract with possible extension Remote / Edmonton, AB The proposed resource must meet or exceed one of the following: University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience. OR 2-yr diploma in business, management or a related discipline and 4-yr DA...


  • Canada Compunnel Inc. Full time

    Job OverviewWe are seeking a skilled Cloud Data Architect to join our team at Compunnel Inc.About the Role:Design and implement scalable data solutions using cloud technologies like Azure Synapse, Databricks, and Azure Data Factory.Implement security controls on cloud PaaS and IaaS-based solutions.Collaborate with cross-functional teams to design and develop...

  • Data Architect

    5 days ago


    Canada, CA IMCS Group Full time

    Data Architect – Intermediate6 Months Contract with possible extensionRemote / Edmonton, ABThe proposed resource must meet or exceed one of the following:University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience.OR2-yr diploma in business, management or a related discipline and 4-yr DA experience.OR1-yr...