Business Intelligence jobs in Canada

We are looking for Data Architect to join the Enterprise Data Platforms team within our Data & Analytics program. You will be responsible for designing, delivering and consulting on logical and physical data models, virtualized and persistent integrated data sets, data access layer designs, and other data management aspects of solution development as part of the holistic suite of technology solutions provided to business teams.

Communicate and interact effectively with systems professionals and end users who are not systems experts. Work independently, prioritize work assignments, meet deadlines and produce an adequate volume of work. You will be working closely with solution engineering, product groups, and business partners to define, design and implement data architecture standards and solutions to ensure that our enterprise data architecture is technically sound and meets the needs of our business.

Data Modeling

Lead the creation and update of logical and physical bi-temporal relational and dimensional data models (and related documentation) for new and existing subject areas, including financial instruments, legal entities, reference, collateral, transactions, positions/valuations, benchmarks, performance, exposure and risk measures.

Track and monitor the known gaps in the data requirements/ model and develop reporting to communicate overall progress toward end-state of the enterprise warehouse services.

Determines appropriate integration patterns through hands-on experimentation including some of the following activities:

Transform and clean raw data to adopt appropriate store model for selection data type

Aggregating data to ensure suitability for analytical consumption

Filtering information to eliminate irrelevant, duplicated, or overly sensitive data

Joining and / or integrating two or more database tables via their matching attributes

Data validation and processing

Contribute to the design of access security (row-based vs. column-based).

Work with subject matter experts, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions.

Advise downstream data consumers on design of data consumption and data marts to meet specific end-user reporting requirements.

Develop and maintain data documentation such as entity relationship models (ERDs), data lineage, meta data and transformation rules.

Contribute towards development of data standards, data dictionaries, data quality rules, processes, and definitions of project and data requirements in support of strategy and ongoing operational support.

Participate in solution/compute/Infrastructure design to accommodate workload requirements for business solutions.

Bachelor’s degree in Computer Science, or related field, or equivalent IT (Information Technology) experience

Five years of progressive experience in the asset management/capital markets/investment management industry preferred

Six years of experience in the following: architecting enterprise information systems, analyzing inter-relationships between various domains of enterprise information

Extensive experience with modelling in a Data Warehousing and BI (Business Intelligence) context (star schemas, BI modelling issues such as slowly changing dimensions).

Experience with architectures supporting data integration and data orchestration for different data consumption requirements: operational data store, data warehouse, data marts, analytical data stores

Must have strong hands-on modelling, data integration and solution design experience - including strong version control, repository management, merge/compare utilities, and management of target models.

Experience with cloud data platforms and understanding of lake house Architecture

Experience with data and service integration both on prem and cloud

Proven record of delivering executable, communicable data models

Hands-on experience with Oracle, SQL server (AzureSQL, SQL MI, and Cloud data platform – Snowflake preferred)

Hands-on experience with an analytical tools e.g. Power BI

Hands-on experience with Python and spark framework

Strong communication skills with the ability to present and explain data in a way that establishes rapport, persuades others and gains understanding at peer levels.

#LI-OTPP, #LI-INITIALS, #LI-Hybrid (as applicable)

What we’re offering

Pay-for-performance environment that offers competitive salary and incentive

Numerous opportunities for professional growth and development

Comprehensive employer paid benefits coverage

Retirement income through a defined benefit pension plan

The opportunity to invest back into the fund through our Deferred Incentive Program

A flexible/hybrid work environment combining in office collaboration and remote working

Competitive time off

Our Flexible Travel Program gives you the option to work abroad in another region/country for up to a month each year

Employee discount programs including Edvantage and Perkopolis

Degreed: a digital platform that helps you quickly and easily discover, share, and track various learning resources — from courses to videos to articles and more

At Ontario Teachers', diversity is one of our core strengths. We take pride in ensuring that the people we hire and the culture we create, reflect and embrace diversity of thought, background and experience. Through our Diversity, Equity and Inclusion strategy and our Employee Resource Groups (ERGs), we celebrate diversity and foster inclusion through events for colleagues to connect for professional development, networking & mentoring. We are building an inclusive and equitable workplace where our talent is respected, accepted and empowered to be themselves. To learn more about our commitment to Diversity, Equity and Inclusion, check out Life at Teachers'.

How to apply

Are you ready to pursue new challenges and take your career to the next level? Apply today! You may be invited to complete a pre-recorded digital interview as part of your application.

Accommodations are available upon request (peopleandculture@otpp.com) for candidates with a disability taking part in the recruitment process and once hired.

Candidates must be legally entitled to work in the country where this role is located.

The privacy of your personal information is important to us. Please visit our Privacy Centre to learn how we handle your personal information.

Functional Areas:

We are looking for Data Architect to join the Enterprise Data Platforms team within our Data & Analytics program. You will be responsible for designing, delivering and consulting on logical and physical data models, virtualized and persistent integrated data sets, data access layer designs, and other data management aspects of solution development as part of the holistic suite of technology solutions provided to business teams.

Communicate and interact effectively with systems professionals and end users who are not systems experts. Work independently, prioritize work assignments, meet deadlines and produce an adequate volume of work. You will be working closely with solution engineering, product groups, and business partners to define, design and implement data architecture standards and solutions to ensure that our enterprise data architecture is technically sound and meets the needs of our business.

• Data Modeling

  • Lead the creation and update of logical and physical bi-temporal relational and dimensional data models (and related documentation) for new and existing subject areas, including financial instruments, legal entities, reference, collateral, transactions, positions/valuations, benchmarks, performance, exposure and risk measures.

  • Track and monitor the known gaps in the data requirements/ model and develop reporting to communicate overall progress toward end-state of the enterprise warehouse services.

• Determines appropriate integration patterns through hands-on experimentation including some of the following activities:

  • Transform and clean raw data to adopt appropriate store model for selection data type

  • Aggregating data to ensure suitability for analytical consumption

  • Filtering information to eliminate irrelevant, duplicated, or overly sensitive data

  • Joining and / or integrating two or more database tables via their matching attributes

  • Data validation and processing

• Contribute to the design of access security (row-based vs. column-based).

• Work with subject matter experts, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions.

• Advise downstream data consumers on design of data consumption and data marts to meet specific end-user reporting requirements.

• Develop and maintain data documentation such as entity relationship models (ERDs), data lineage, meta data and transformation rules.

• Contribute towards development of data standards, data dictionaries, data quality rules, processes, and definitions of project and data requirements in support of strategy and ongoing operational support.

• Participate in solution/compute/Infrastructure design to accommodate workload requirements for business solutions.

• Bachelor’s degree in Computer Science, or related field, or equivalent IT (Information Technology) experience

• Five years of progressive experience in the asset management/capital markets/investment management industry preferred

• Six years of experience in the following: architecting enterprise information systems, analyzing inter-relationships between various domains of enterprise information

• Extensive experience with modelling in a Data Warehousing and BI (Business Intelligence) context (star schemas, BI modelling issues such as slowly changing dimensions).

• Experience with architectures supporting data integration and data orchestration for different data consumption requirements: operational data store, data warehouse, data marts, analytical data stores

• Must have strong hands-on modelling, data integration and solution design experience - including strong version control, repository management, merge/compare utilities, and management of target models.

• Experience with cloud data platforms and understanding of lake house Architecture

• Experience with data and service integration both on prem and cloud

• Proven record of delivering executable, communicable data models

• Hands-on experience with Oracle, SQL server (AzureSQL, SQL MI, and Cloud data platform – Snowflake preferred)

• Hands-on experience with an analytical tools e.g. Power BI

• Hands-on experience with Python and spark framework

• Strong communication skills with the ability to present and explain data in a way that establishes rapport, persuades others and gains understanding at peer levels.

#LI-OTPP, #LI-INITIALS, #LI-Hybrid (as applicable)

What we’re offering

• Pay-for-performance environment that offers competitive salary and incentive

• Numerous opportunities for professional growth and development

• Comprehensive employer paid benefits coverage

• Retirement income through a defined benefit pension plan

• The opportunity to invest back into the fund through our Deferred Incentive Program

• A flexible/hybrid work environment combining in office collaboration and remote working

• Competitive time off

• Our Flexible Travel Program gives you the option to work abroad in another region/country for up to a month each year

• Employee discount programs including Edvantage and Perkopolis

• Degreed: a digital platform that helps you quickly and easily discover, share, and track various learning resources — from courses to videos to articles and more

At Ontario Teachers', diversity is one of our core strengths. We take pride in ensuring that the people we hire and the culture we create, reflect and embrace diversity of thought, background and experience. Through our Diversity, Equity and Inclusion strategy and our Employee Resource Groups (ERGs), we celebrate diversity and foster inclusion through events for colleagues to connect for professional development, networking & mentoring. We are building an inclusive and equitable workplace where our talent is respected, accepted and empowered to be themselves. To learn more about our commitment to Diversity, Equity and Inclusion, check out Life at Teachers'.

How to apply

Are you ready to pursue new challenges and take your career to the next level? Apply today! You may be invited to complete a pre-recorded digital interview as part of your application.

Accommodations are available upon request (peopleandculture@otpp.com) for candidates with a disability taking part in the recruitment process and once hired.

Candidates must be legally entitled to work in the country where this role is located.

The privacy of your personal information is important to us. Please visit our Privacy Centre to learn how we handle your personal information.

Functional Areas:

Requisition ID:

The Ontario Teachers' Pension Plan Board is an independent organization responsible for administering defined-benefit pensions for school teachers of the Canadian province of Ontario.

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.