SAS to PySpark Conversion

Opportunity Summary: SAS to PySpark Conversion for Canada Mortgage and Housing Corporation (CMHC)

Issuing Organization:

• Canada Mortgage and Housing Corporation (CMHC)
• Contact: Ryan Lemay (Email: [email protected])

Project Overview:
CMHC seeks proposals for the conversion of its SAS EG environment to PySpark within a Databricks framework. This initiative is part of CMHC's mandate to enhance accessibility to affordable housing options for Canadians. The project aims to modernize analytic processes by migrating existing SAS procedures.

Scope and Objectives:

• Conduct a complete scan and assessment of the current SAS EG environment.
• Compile a comprehensive list of SAS EG processes.
• Recommend a modern conversion approach to replace existing processes.
• Implement the conversion to ensure compatibility with Databricks, utilizing PySpark, R, and SQL.
• Complete the SAS migration in several phases, aiming for full conversion by the end of 2029.

Important Dates:

• Posted: January 21, 2026
• Proposal Due: February 16, 2026
• Performance Period: Up to 3 years from contract award.

Contract Type:

• Non-exclusive agreement.

Mandatory Qualifications:

• Experience with SAS to PySpark conversion projects.
• Proven capability to work within Databricks environment.
• Expertise in data processes related to PySpark, R, and SQL.

Key Technical Capabilities Needed:

• Strong understanding of SAS EG environment and processes.
• Expertise in data migration and analytics using PySpark.
• Knowledge of Databricks platform integration.

Deliverables:

• Complete assessment report of the SAS EG environment.
• Comprehensive list and documentation of existing SAS processes.
• Recommended strategy and implementation plan for conversion.
• Successfully converted SAS processes operational in Databricks by the specified deadlines in 3-4 waves.

Evaluation Criteria:

• Clarity and completeness of the proposed methodology for the conversion.
• Team qualifications and relevant project experience.
• Ability to meet project timelines and performance standards.
• Quality of previous work, as evidenced by case studies or references.

Preferred Qualifications (Competitive Advantage):

• Previous engagement with government projects or Crown Corporations.
• Proven track record of successful SAS conversions to modern programming frameworks.
• Strong client references in the analytics domain.

Proposal Evaluation:
Proposals will be assessed on the organization’s expertise, project understanding, technical approach, budget justification, and ability to meet CMHC's specific requirements and timelines.

This summary captures the essential aspects of the opportunity while focusing on requirements that will aid in company matching.