Andrew is a prominent demographer, urbanist, and planning consultant. As Director of Urban Futures Incorporated, Andrew carried out strategic management assignments for a wide range of private and public sector clients. Andrew has worked with many of Canada’s leading developers, investors, and retailers as well as public sector clients, including many of Canada’s most rapidly changing municipalities, public agencies and crown corporations. In working with such a broad range of clients, Andrew has recently been named one of Business in Vancouver's "Top Forty Under 40".

Andrew is also a Director of the Urban Futures Institute. In this capacity he has been a contributing author to over 40 of the Institute’s research reports and participated in many of its public presentations. Research topics of note include: The Context for Change: Demographics, Life Cycles, Economics, and the Lower Mainland of British Columbia Over the Next Four Decades, Changing People, Changing Participation: Demographic and Behavioural Trends as a Context for the Future of the Canada Pension Plan, 2001 to 2051 and A Decade of Jobs and Pay in Canada: A Perspective on Canada's National and Regional Economies.

Andrew is a member of the Planning Institute of British Columbia (PIBC) and has formerly held a position on PIBC Council. He has organized and taught courses for both UBC and Simon Fraser University (SFU), in addition to providing ongoing workshops and seminars for programs at the British Columbia Institute of Technology and SFU’s City Program.