Data Architect (Hybrid) Jobs

The opportunity

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.

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

• Transform and clean raw data to adopt appropriate store model for selection data type
• 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.
• Advise downstream data consumers on design of data consumption and data marts to meet specific end-user reporting requirements.
• 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:
• Participate in solution/compute/Infrastructure design to accommodate workload requirements for business solutions.
• 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.
• Contribute to the design of access security (row-based vs. column-based).
• Aggregating data to ensure suitability for analytical consumption
• Filtering information to eliminate irrelevant, duplicated, or overly sensitive data
• Data validation and processing
• Work with subject matter experts, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions.
• Develop and maintain data documentation such as entity relationship models (ERDs), data lineage, meta data and transformation rules.
• Joining and / or integrating two or more database tables via their matching attributes

What You'll Need

• Experience with cloud data platforms and understanding of lake house Architecture
• Hands-on experience with an analytical tools e.g. Power BI
• 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.
• Experience with architectures supporting data integration and data orchestration for different data consumption requirements: operational data store, data warehouse, data marts, analytical data stores
• Proven record of delivering executable, communicable data models
• Extensive experience with modelling in a Data Warehousing and BI (Business Intelligence) context (star schemas, BI modelling issues such as slowly changing dimensions).
• Hands-on experience with Python and spark framework
• Hands-on experience with Oracle, SQL server (AzureSQL, SQL MI, and Cloud data platform – Snowflake preferred)
• Experience with data and service integration both on prem and cloud
• 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.
• Five years of progressive experience in the asset management/capital markets/investment management industry preferred
• Bachelor’s degree in Computer Science, or related field, or equivalent IT (Information Technology) experience
• Six years of experience in the following: architecting enterprise information systems, analyzing inter-relationships between various domains of enterprise information

, , (as applicable)

What We’re Offering

• 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
• Employee discount programs including Edvantage and Perkopolis
• Retirement income through a defined benefit pension plan
• Pay-for-performance environment that offers competitive salary and incentive
• Our Flexible Travel Program gives you the option to work abroad in another region/country for up to a month each year
• 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
• Comprehensive employer paid benefits coverage
• Numerous opportunities for professional growth and development

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 ([email protected]) 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