Responsibilities PRIMARY PURPOSE Develops and maintains a three-statement consolidated long range financial model; performs financial and sensitivity analysis and creates presentations and reports as assigned. Develops and recommends business insights through financial analysis to improve business area decision-making and to deliver effective long range financial forecasting using current, updated procedures and industry best practices. Key Accountabilities Designs and recommends long range corporate financial investment models used to evaluate new and existing opportunities in support of strategic initiatives. Ensures that financial models comply with TransLink’s legislative and board policy requirements. Formulates and recommends policies and procedures for upgrading and improving models, and in supporting transition that includes bridging, from one model to the next and provide training usage of the model. Provides consolidated financial data and related resources for the development and reporting of 10-Year Investment Plan; identifies opportunities to enhance financial outlooks, and other financial analysis tasks and projects. Creates and monitors an audit program pertaining to relative risks, modelling errors and implements procedures to minimize future errors. Collaborates with internal stakeholders on the Investment plan and various functional and upcoming financial models. Advises various department / project managers on financial issues and assumptions that will impact operating and capital requirements; develops detailed instructions for investment plan inputs and provides guidance and direction to relevant team members on related matters. Identifies adequate resources for complex projects or initiatives. Reports out on the assigned projects, deadlines and any concerns and prepares executive dashboards to assist in insightful decision making. Develops various reports both periodic and ad-hoc related to projects, programs and other corporate financial initiatives to support Enterprise objectives. Works closely with team members in the financial planning department and Strategic Planning and Development department on financial information and other data ensuring accuracy, completeness and compliance with corporate guidelines and determining reasons for change from previous budget and/or submission; collaborates with business units and responds to their financial data requests and related matters. Analyzes financial impacts of opportunities towards improving efficiencies; analyzes and tracks key business drivers and initiatives and prepares recommendations to relevant managers; reviews and analyzes financial and performance metric variances against historic trends, strategic plan, and budget to develop business cases for process improvements. Prepares and ensures accuracy of executive briefing material; assists in preparing draft sections for the investment plan, reviews impact of budgets/forecasts on approved investment plan and participates in special projects, including providing financial analysis services to various project teams. Education and Experience The competencies for this position would be acquired through completion of a university degree in finance, commerce or related discipline along with a Professional designation (CA, CPA, CFA, CMA) plus six (6) years progressive experience in financial planning with an emphasis on financial modeling / corporate finance in a large organization. Other Requirements Advanced analytical and financial modeling skills using Excel and other modeling tools Solid business acumen and experience with reviewing business cases with good understanding of project management practices (Gantt charts, work breakdown structures, project governance) Advanced foundation in accounting and finance with working knowledge of PSAB accounting standards and general understanding of TransLink’s governance legislation is an asset Strong skills with PowerPoint and ability to present complex information in a concise manner along with strong written and verbal communication skills Strong interpersonal skills who builds great relationships with colleagues, senior leaders and non-financial staff at various levels Strong organization and time management skills with ability to multitask during tight project deadlines Intermediate or Advanced Power Query, Power BI and VBA experience is an asset Capital Planning experience is an asset Work Schedule 37.5 hours per week. Work Designation Hybrid – flexibility of working both on-site and remotely within B. C. Rate of Pay The salary for this position ranges from $91,840 - $137,760 per annum. Actual salary offered will be based on education, experience, skills, and qualifications as they relate to the role. Accommodations Accommodations are available on request for candidates taking part in all aspects of the selection process. EEO Statement TransLink is committed to employment equity and building a diverse workforce, representative of the customers we serve and the many communities in the Metro Vancouver region. We welcome and encourage Indigenous applicants, people of colour, all genders, 2SLGBTQ+ and persons with disabilities to apply. Learn more about TransLink's commitment to equity, diversity and inclusion. #J-18808-Ljbffr