Theresa Ayerst is an experienced, hands-on data warehouse architect who has been involved in the architecture, design, and implementation of numerous data warehouses and application databases. With over 16 years’ experience, she has significant expertise in data and systems architecture.
After starting her career in IT as a developer, Theresa quickly developed a passion for data management & systems architecture. Her first experience in the data management field was in designing and loading operational data stores. She then moved into a Data Warehousing role with a team whose architecture was best explained as a ‘traditional data warehouse’ or ‘hybrid/combination of different methodologies and modelling concepts’, including many Kimball data warehousing techniques and IIW concepts.
In her current role as Solution Designer – Information and Data at The Co-operators Life Insurance Company, Theresa is the Team Lead and Data Warehouse Architect for an Agile Delivery Team whose mandate is to ensure that all data needs for IFRS (International Financial Reporting Standards) are served from 1 of 2 data warehouses. A Certified Data Vault Professional since 2016, Theresa has a solid understanding of Agile methodologies and how Data Vault fits within them and streamlines agile delivery cycles, the advantages of using Data Vault over other data modeling concepts, and the true meaning of working with all data, including the good, the bad, and the ugly.
Certifications: MCSA in SQL Server Data Warehousing, Professional ScrumMaster (PSM) 1, Certified Data Vault 2.0 Professional, CA Accredited Associate: CA Erwin Data Modeler