Ofsaa Technical Lead

2 weeks ago


Toronto, Canada Compest Solutions Inc Full time

What are the top 3 skills required for this role?
1. BASEL/Large Exposure experience with OFSAA
2. Regulatory Functional knowledge of both US and Canadian OSFI experience
3. OFSAA stack full end to end from data ingestion to regulatory reporting

Job Description/ Responsibilities:
Additional Information:
OFSAA, SQL / PLSQL, Oracle database 12c / 19c, Unix shell scripting, Erwin data modeling, ETL, ODI, SQL Developer

JD:

- Lead OFSAA development team.
- Plan, execute, and deliver proposed Solutions within scope, budget, and timeline.
- Assign tasks to team members and monitor progress to ensure project milestones are achieved on time
- Ensure high code quality by guiding team members, conduct code reviews, and promote best practices.
- Identify and address technical challenges during project execution.
- Communicate project plan with team members, product owners, and engineering managers.
- Collaborate among team members to ensure smooth development cycles.
- Must have an implementation Experience on below OFSAA modules OFSAA Financial Solution Data Foundation
- OFSAA Capital Adequacy Pack OFSAA Data Integration Hub OFSAA Data Governance Pack and OFSAA GL Recon
- Advanced OFSAA platform knowledge (FSDF) with coding experience; especially in OFSAAI 8.0.6.x or similar (at least 3 years in OFSAAI)
- Experience in OFSAA architecture and metadata management framework (Hierarchies, datasets).
- Experience in OFSAAI performance enhancement work. Scalability/performance tuning experience with large databases. Parallel execution of queries and optimization
- Experience developing or reviewing credit risk (including Counterparty credit risk) risk rating and measurements systems, economic capital, stress testing with commercial banks or financial institutions in the context of broader regulatory reforms such as Basel III
- Knowledge of credit risk reporting and economic capital, regulatory reporting related to credit risk portfolios and supporting the process
- Experience with Oracle 19c, SQL, PL/SQL, OFSAA metadata management framework, data modeling, and managing OFSAA data model using Erwin
- Experience with OFSAA data management tools - T2T, file extracts, data quality framework, run-rule, and process modeling framework.
- Experience with building data entry forms, Excel uploads, run-Rule framework, Data Quality, and FSDF architecture
- Knowledge of Data Modelling using Erwin tool, Data Migration Activities and Slowly Changing Dimension (SCD) Component
- Experience in managing requirements gathering, business/gap analysis, solution design and documentation for OFSAA projects.
- Strong in Data Warehouse Principles, ETL/Data Flow tools.

Years of Experience: 8.00 Years of Experience

**Job Type**: Fixed term contract
Contract length: 12 months

**Salary**: $50.00-$55.00 per hour

Expected hours: 40 per week

Schedule:

- Monday to Friday

**Education**:

- Bachelor's Degree (preferred)

**Experience**:

- OFSAA: 10 years (required)
- OSFI: 10 years (required)
- Erwin data modeling: 9 years (preferred)
- SQL / PLSQL: 9 years (preferred)

**Language**:

- English (preferred)

Work Location: In person



  • Toronto, ON, Canada REALIGN LLC Full time

    Job Type: Contract Job Category: IT Job Description Job Title: Oracle OFSAA Consultant Job Summary: We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation,...


  • Old Toronto, Canada REALIGN LLC Full time

    Job Type: ContractJob Category: ITJob DescriptionJob Title: Oracle OFSAA ConsultantJob Summary:We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation, and support...


  • Old Toronto, Canada REALIGN LLC Full time

    Job Type: ContractJob Category: ITJob DescriptionJob Title: Oracle OFSAA ConsultantJob Summary:We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation, and support...


  • Old Toronto, Canada REALIGN LLC Full time

    Job Type: ContractJob Category: ITJob DescriptionJob Title: Oracle OFSAA ConsultantJob Summary:We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation, and support...

  • Technical Lead

    2 weeks ago


    Toronto, Canada Tundra Technical Solutions Full time

    Key Responsibilities: You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Lead

    2 weeks ago


    Toronto, Canada Tundra Technical Solutions Full time

    Key Responsibilities:You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Lead

    2 weeks ago


    Toronto, Canada Tundra Technical Solutions Full time

    Key Responsibilities:You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Database Consultant

    3 weeks ago


    Toronto, ON, Canada REALIGN LLC Full time

    Job Type: Contract Job Category: IT Job Title: Oracle OFSAA Consultant We are seeking a proficient and experienced Oracle OFSAA (Oracle Financial Services Analytical Applications) Consultant to join our dynamic team. As an Oracle OFSAA Consultant, you will be responsible for providing end-to-end solutions, implementation, and support related to Oracle...

  • Technical Lead

    6 days ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Key Responsibilities:You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Lead

    6 days ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Key Responsibilities:You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Lead

    6 days ago


    Toronto, ON, Canada Tundra Technical Solutions Inc. Full time

    Key Responsibilities: You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Lead

    6 days ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Key Responsibilities:You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant...

  • Technical Team Lead

    2 days ago


    Toronto, Canada Tundra Technical Solutions Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role OverviewThe Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...

  • Technical Team Lead

    14 hours ago


    Toronto, Canada Tundra Technical Solutions Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role Overview The Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...

  • Technical Team Lead

    14 hours ago


    Toronto, Canada Tundra Technical Solutions Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role OverviewThe Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...

  • Technical Team Lead

    11 hours ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role OverviewThe Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...

  • Technical Team Lead

    11 hours ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role OverviewThe Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...

  • Technical Team Lead

    13 hours ago


    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    We are looking to hire a full time Senior Technical Lead for our Technology team. Role OverviewThe Senior Technical Lead is a customer first individual accountable for the vision and execution of their portfolio. The role covers all aspects of the software development lifecycle. Success is measured by the team’s collective ability to generate positive...


  • Toronto, ON, Canada Tundra Technical Solutions Inc. Full time

    You will be responsible for the development, delivery and maintenance of features and other deliverables for your team within their respective Technical Area, as well as career development, guidance, coaching and support of your team members. You will work closely with the development team and Technical Architect to design elegant solutions, troubleshoot...

  • Technical Lead

    4 days ago


    Toronto, Canada Canadian Institute for Health Information Full time

    **Category** - Information/Infrastructure Technology **City** - Toronto, Ottawa, Ontario, Canada - Technical Lead - Who we are - We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our...