Manager, Financial Analytics

We need to output HTML fragment with sections: About the role? Actually the posting includes "About You" and "What Success Looks Like", "Benefits", "Bonus", "For Salary Roles Approximate Salary Range". Also there is a description of role responsibilities. We need to use

for section headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We must not repeat job title as heading. We need to include sections only when posting has real specific content. We must preserve all substantive info, not invent or summarize away detail. Remove boilerplate: EEO, legal, application instructions, etc. Also remove duplicated lines. We need to parse the posting. Key sections: - Intro: "Make your next move an expert one..." etc. That's fluff, maybe not needed. But we need to preserve substantive info: description of role, responsibilities, etc. We need to decide headings: "About the role" could contain description of role purpose. "Responsibilities" list bullet points from "In this role, you will…" and other duty sentences. "Requirements" maybe education and experience. "Qualifications" maybe preferred qualifications. "Skills" maybe technical skills. "Benefits" from benefits section. "Pay" from salary range. "Schedule" maybe not present; posting does not mention schedule (like full-time, remote). It mentions WFH USA location, but not schedule specifics. So we should not create Schedule section if no specific content. We must not include filler like "commensurate with experience". Not present. We need to ensure we don't include boilerplate like EEO, equal opportunity, etc. Also remove "Applicants must be currently authorized to work..." etc. That's application instruction/requirement? Might be considered boilerplate but it's a requirement (work authorization). Might be considered substantive? The instruction says remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. So we should remove work authorization statement as application instruction. Also remove "Direct applicants only please, no agencies." etc. Also remove "Colliers respects diversity..." etc. Also remove "If you are a qualified applicant..." etc. We need to keep substantive info: role description, responsibilities, requirements, qualifications, skills, benefits, pay. Let's extract: Role description (About You): "The Manager, Financial Analytics serves as a strategic financial leader supporting multi-market occupier and leasing clients through the development, implementation, and continuous enhancement of sophisticated financial analytics and modeling solutions. Operating within a national platform, this role’s deep financial expertise provides actionable financial insights tailored to each client's objectives, enabling occupiers to make informed real estate decisions and help landlords evaluate the financial impact of various leasing and asset management strategies. Balancing hands-on execution of complex financial analyses with oversight and development of financial resources across markets, the Manager, Financial Analytics role partners closely with brokers, account leadership, transaction teams, landlords, and corporate occupiers to develop comprehensive financial models that quantify the financial implications of real estate decisions and leasing strategies. The role leads the development of sophisticated financial models that evaluate leasehold interests across multiple asset types using pre-tax and after-tax cash flow projections, Net Present Value (NPV), internal rate of return (IRR), occupancy cost analyses, and U.S. GAAP accounting impacts. These analyses support critical business decisions, including site selection, lease renewals, acquisitions, dispositions, capital investments, and portfolio optimization." That's about the role. Responsibilities: bullet list from "In this role, you will…" and subsequent sentences: - Serve as the financial analytics leader for multi-market occupier and broker client engagements. - Participating in onboarding and transition initiatives for leasing and/or multi-market client accounts. - Designing and developing customized financial models aligned with client decision-making processes, KPIs, and reporting requirements. - Translating client business objectives into scalable financial analytics solutions. - Establishing standardized methodologies while accommodating unique client requirements. - Collaborating with account leadership and transaction teams to ensure seamless implementation of financial frameworks. - Building and maintaining complex, dynamic financial models evaluating real estate alternatives. - Analyzing occupancy costs, lease structures, cash flows, and capital expenditures to support transaction recommendations. - Performing cash versus GAAP analyses and evaluating financial implications of alternative transaction structures. - Continuously refining and enhancing modeling methodologies and analytical tools. - Leading financial analysis for tenant representation and occupier transactions. - Delivering actionable insights that support occupancy strategy, portfolio optimization, and business decision-making. - Owning the development, governance, and evolution of financial modeling tools and frameworks. - Supporting implementation of technology solutions that advance analytical capabilities and reporting effectiveness. Also earlier: "Participating in onboarding and transition initiatives..." already captured. Also "Serve as the financial analytics leader..." etc. We should ensure no duplication. Requirements: "What Success Looks Like" includes: - Bachelor's degree required; concentration in Finance, Real Estate, Economics, Accounting, or related field. - MBA or other relevant advanced degree preferred. - 8–12 years of progressively responsible experience in financial analysis, real estate finance, occupier services, or related fields. - Demonstrated experience leading complex real estate transaction financial analyses for occupiers and tenants. - Experience working closely with tenant representation brokerage teams preferred. - Prior experience managing, mentoring, or developing financial professionals preferred. - Advanced expertise in Microsoft Excel, including development of sophisticated and dynamic financial models. - Strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, and real estate financial structures. - Experience with cash versus GAAP accounting analyses. - Familiarity with ProCalc or similar real estate financial analysis platforms preferred. - Strong analytical, quantitative, and problem-solving capabilities. - Proven ability to operate effectively as a player-coach, balancing individual contribution with team leadership. - Strong verbal, written, and presentation skills with executive-level communication capability. We could split into Requirements (education, experience) and Qualifications (preferred) and Skills (technical). But the instruction says use headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide what goes where. We can put: - About the role: description paragraph. - Responsibilities: bullet list of duties. - Requirements: mandatory items (Bachelor's degree required, 8–12 years experience, demonstrated experience leading complex analyses, advanced expertise in Excel, strong understanding of cash flow etc., experience with cash vs GAAP, strong analytical capabilities, proven ability to operate as player-coach, strong communication skills). Might also include "Bachelor's degree required; concentration in Finance, Real Estate, Economics, Accounting, or related field." as requirement. - Qualifications: preferred items (MBA or other relevant advanced degree preferred, experience working closely with tenant representation brokerage teams preferred, prior experience managing/mentoring preferred, familiarity with ProCalc preferred). - Skills: maybe technical skills like Advanced expertise in Microsoft Excel, strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, real estate financial structures, experience with cash versus GAAP accounting analyses, strong analytical, quantitative, problem-solving capabilities, strong verbal/written/presentation skills. But some overlap. We'll try to allocate. Better: Requirements = education + years experience + core mandatory experience. Qualifications = preferred education/experience. Skills = technical and soft skills. Let's list: Mandatory (Requirements): - Bachelor's degree required; concentration in Finance, Real Estate, Economics, Accounting, or related field. - 8–12 years of progressively responsible experience in financial analysis, real estate finance, occupier services, or related fields. - Demonstrated experience leading complex real estate transaction financial analyses for occupiers and tenants. - Advanced expertise in Microsoft Excel, including development of sophisticated and dynamic financial models. - Strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, and real estate financial structures. - Experience with cash versus GAAP accounting analyses. - Strong analytical, quantitative, and problem-solving capabilities. - Proven ability to operate effectively as a player-coach, balancing individual contribution with team leadership. - Strong verbal, written, and presentation skills with executive-level communication capability. Preferred (Qualifications): - MBA or other relevant advanced degree preferred. - Experience working closely with tenant representation brokerage teams preferred. - Prior experience managing, mentoring, or developing financial professionals preferred. - Familiarity with ProCalc or similar real estate financial analysis platforms preferred. Skills: maybe we can combine some of the above but to avoid duplication, we could list technical skills: Advanced expertise in Microsoft Excel, strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, real estate financial structures, experience with cash versus GAAP accounting analyses, familiarity with ProCalc (or similar) platforms, strong analytical, quantitative, problem-solving capabilities, strong verbal/written/presentation skills. But that duplicates with Requirements/Qualifications. Perhaps better to not have Skills section if it duplicates. But instruction says we can include Skills section if posting has real specific content. It does have skills mentioned. We could list them without repeating the exact phrases from Requirements/Qualifications? Might be okay to have some overlap but we should avoid duplication? Not explicitly forbidden but better to avoid. We could treat Skills as the technical and soft skills list: Advanced expertise in Microsoft Excel, strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, real estate financial structures, experience with cash versus GAAP accounting analyses, familiarity with ProCalc or similar platforms, strong analytical, quantitative, problem-solving capabilities, strong verbal, written, and presentation skills. But then Requirements would be education and experience only. Qualifications would be preferred education/experience. Let's do that. Thus: Requirements: - Bachelor's degree required; concentration in Finance, Real Estate, Economics, Accounting, or related field. - 8–12 years of progressively responsible experience in financial analysis, real estate finance, occupier services, or related fields. - Demonstrated experience leading complex real estate transaction financial analyses for occupiers and tenants. Qualifications: - MBA or other relevant advanced degree preferred. - Experience working closely with tenant representation brokerage teams preferred. - Prior experience managing, mentoring, or developing financial professionals preferred. - Familiarity with ProCalc or similar real estate financial analysis platforms preferred. Skills: - Advanced expertise in Microsoft Excel, including development of sophisticated and dynamic financial models. - Strong understanding of cash flow analysis, lease analysis, occupancy cost analysis, and real estate financial structures. - Experience with cash versus GAAP accounting analyses. - Strong analytical, quantitative, and problem-solving capabilities. - Proven ability to operate effectively as a player-coach, balancing individual contribution with team leadership. - Strong verbal, written, and presentation skills with executive-level communication capability. Benefits: extract from Benefits section: - Employees (and their families) are provided options for employer subsidized medical benefits including RX, dental, vision as well as employer paid basic life/AD&D insurance and short-term/long-term disability. - Employees are able to enroll in our company’s 401k plan, which includes an employer match. - Employees will also receive 10 days of sick leave and a minimum of 15-days vacation annually. - Certain senior-level roles are eligible for unlimited time off. - Employees will also enjoy 10 paid holidays plus two personal flex days throughout the calendar year. - Twelve weeks (for birth parents) and 4 weeks (for non-birth parents, including adoptive/foster parents) of paid parental leave will also be available for use after successful completion of 90 days of employment. - Individuals may be eligible for different or additional benefits under applicable state law. Also Bonus: "This position is eligible for an annual bonus, based on company and individual performance." Could be part of Benefits or separate? There's no Bonus heading in list, but we could include under Benefits or maybe under Pay? The instruction includes Benefits, Pay, Schedule headings. Bonus could be part of Benefits or Pay. Since there is a Bonus bullet, we could include it under Benefits as an additional bullet. Pay: Salary range: "Approximate Salary Range for Role: $126,762 to $145,000 Area/Location Specific: WFH USA". Also note: "Our salary ranges are determined by role, level, and location. The range displayed on this job posting reflects the minimum and