Job Database Architect in Toronto

Investment & Asset Management
The opportunity
We are looking for a Senior Software Developer to join the Data Architecture and Solutions team within our Data & Analytics program. You will be responsible designs, delivers and consulting on logical and physical data models, virtualized and persistent integrated data set 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.
Who you'll work with
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.
What you'll do
  • 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
What you'll need
  • 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:
Operations

Requisition ID:
5098

Apply Here

About Ontario Teachers’ Pension Plan

CEO: Jo Taylor
Revenue: $10+ billion (USD)
Size: 1001 to 5000 Employees
Type: Company - Private
Website: www.otpp.com
Year Founded: 1990