Senior Data Modeler
$86k - $130k per yearOMERS / Oxford Properties Group
Choose a workplace that empowers your impact. Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be — and deliver — your best. We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 665,000 members, placing their best interests at the heart of everything we do. Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work. Don’t just work anywhere — come build tomorrow together with us.Sr. Data Modeler
The OMERS Products and Technology team is seeking a self-motivated and highly experienced Senior Data Modeler to join the Pension Architecture team. The team is responsible for modernizing OMERS’ core pension administration system and related applications, while also providing architectural oversight for the organization’s analytics data platform and associated integrations. This role reports into the Director, Architecture and is important because it will help shape the data architecture and technical foundation supporting critical business solutions. In this role, you will help design and maintain scalable, secure, and reliable data solutions for large, service-oriented applications. You will apply your expertise in data solution engineering, data modeling, and data architecture to ensure that solutions align with business needs, corporate standards, industry best practices, and security requirements. You will create and maintain a range of technical designs and architectural artifacts, including data flows, logical and physical data models, application information models, data migration designs, deployment models, and related documentation. You will collaborate closely with business, engineering, DevOps, infrastructure, and security leaders throughout the development lifecycle to ensure solutions are fit for purpose and adhere to established technical and architectural standards. This is an excellent opportunity for a hands‑on professional who is passionate about technology, continuous learning, and delivering meaningful solutions. You will be a key contributor to an engaged, high-performing team that values collaboration, people development, and long-term growth. At OMERS, you will be part of a culture committed to innovation, building trusted relationships, anticipating stakeholder needs, and creating lasting value for our members and customers.You will be responsible for:
Lead data modeling and architecture activities supporting OMERS’ legacy and modern pension administration systems, including systems with more than 2,000 tables and Employer and Member portal applications. Define and maintain data architecture standards, frameworks, and principles covering data modeling, metadata, security, master data, reference data, naming conventions, data types, and data quality. Design and maintain logical and physical data models for new initiatives and system enhancements, from initial requirements through executable DDL generation and implementation. Design data flows, migration strategies, source-to-target mappings, and data transformations that preserve data integrity and support successful system implementations. Provide expertise and guidance on data classification, data security, data masking, data encryption, metadata management, data governance, and data quality. Act as a trusted data subject matter expert during requirements engineering, architecture reviews, working groups, and cross‑functional project discussions. Develop and publish data architecture diagrams, models, technical documentation, and related artifacts for review by business stakeholders, Security, Enterprise Architecture, Product, Development, and DevOps teams. Establish and maintain data definitions for database objects and contribute to a shared Data Dictionary and broader metadata management practices. Support multiple project teams by coordinating schema changes across development and testing environments and partnering with DevOps teams to plan and implement changes in production.Required Skills & Experience
7 or more years of overall information technology experience, including at least 3 years of hands‑on experience as a Data Architect, Data Modeler, or in a closely related role.Demonstrated experience designing data solutions for complex enterprise applications, including relational databases and large-scale transactional or operational systems.Strong experience developing logical and physical data models, database designs, data flows, data migration designs, and source-to-target mappings.At least 3 years of experience using a data architecture or data modeling tool such as SAP PowerDesigner, ER/Studio, erwin Data Modeler, or a comparable platform.At least 5 years of experience working with the Oracle database platform, preferably Oracle19c or later, and related development and administration tools.Strong hands‑on data modeling experience with Oracle, PostgreSQL, Microsoft SQL Server, Azure SQL Database, or similar relational database platforms.Proven experience with database development and design tools, such as Oracle SQL Developer, SQL Navigator, Quest Toad, or comparable tools.Strong analytical experience with database programming languages, including Oracle PL/SQL, Microsoft T-SQL, PostgreSQL PL/pgSQL, or similar.Strong understanding of data integrations, conversions, migrations, transformations, and data integrity controls.Demonstrated knowledge of metadata management, data governance, data quality, data dictionaries, data classification, and related data management practices.Excellent analytical, investigative, problem‑solving, and quantitative skills, with a strong attention to detail and quality.Ability to understand and translate complex business rules, processes, calculations, and system requirements into effective data solutions.Preferred Skills & Experience
A university degree, preferably a master’s degree, in Computer Science, Information Systems, Engineering, or a related discipline.Experience designing data solutions in the defined benefit pension industry, financial services, insurance, or another highly regulated environment.Knowledge of Master Data Management, reference data management, data science, artificial intelligence, and machine learning concepts.Experience supporting actuarial, benefits administration, financial calculation, or other systems involving complex mathematical formulas and business rules.Experience with database schema deployment processes, DevOps practices, and promoting database changes across development, testing, and production environments.Experience providing coaching, mentoring, or technical leadership to junior data professionals.This posting is for an existing vacancy. The expected salary range for this position is $86,000.00 - $130,000.00 per year. You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans – details on these elements of compensation are included within OMERS & Oxford offer letters.As one of Canada’s largest defined benefit pension plans, our people‑first culture is at its best when our workforce reflects the communities where we live and work — and the members we proudly serve. From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier‑free recruitment and selection process that extends all the way through your employee experience.Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision‑making remain central to our candidate experience. We're committed to: We are passionate about inclusion and advocate for I&D across our network of employees, members and partners We are proud of our commitment to developing a best in class approach to complete wellness for our employees and members We invest in our people, providing them with opportunities so they can develop and grow
#J-18808-Ljbffr
The OMERS Products and Technology team is seeking a self-motivated and highly experienced Senior Data Modeler to join the Pension Architecture team. The team is responsible for modernizing OMERS’ core pension administration system and related applications, while also providing architectural oversight for the organization’s analytics data platform and associated integrations. This role reports into the Director, Architecture and is important because it will help shape the data architecture and technical foundation supporting critical business solutions. In this role, you will help design and maintain scalable, secure, and reliable data solutions for large, service-oriented applications. You will apply your expertise in data solution engineering, data modeling, and data architecture to ensure that solutions align with business needs, corporate standards, industry best practices, and security requirements. You will create and maintain a range of technical designs and architectural artifacts, including data flows, logical and physical data models, application information models, data migration designs, deployment models, and related documentation. You will collaborate closely with business, engineering, DevOps, infrastructure, and security leaders throughout the development lifecycle to ensure solutions are fit for purpose and adhere to established technical and architectural standards. This is an excellent opportunity for a hands‑on professional who is passionate about technology, continuous learning, and delivering meaningful solutions. You will be a key contributor to an engaged, high-performing team that values collaboration, people development, and long-term growth. At OMERS, you will be part of a culture committed to innovation, building trusted relationships, anticipating stakeholder needs, and creating lasting value for our members and customers.You will be responsible for:
Lead data modeling and architecture activities supporting OMERS’ legacy and modern pension administration systems, including systems with more than 2,000 tables and Employer and Member portal applications. Define and maintain data architecture standards, frameworks, and principles covering data modeling, metadata, security, master data, reference data, naming conventions, data types, and data quality. Design and maintain logical and physical data models for new initiatives and system enhancements, from initial requirements through executable DDL generation and implementation. Design data flows, migration strategies, source-to-target mappings, and data transformations that preserve data integrity and support successful system implementations. Provide expertise and guidance on data classification, data security, data masking, data encryption, metadata management, data governance, and data quality. Act as a trusted data subject matter expert during requirements engineering, architecture reviews, working groups, and cross‑functional project discussions. Develop and publish data architecture diagrams, models, technical documentation, and related artifacts for review by business stakeholders, Security, Enterprise Architecture, Product, Development, and DevOps teams. Establish and maintain data definitions for database objects and contribute to a shared Data Dictionary and broader metadata management practices. Support multiple project teams by coordinating schema changes across development and testing environments and partnering with DevOps teams to plan and implement changes in production.Required Skills & Experience
7 or more years of overall information technology experience, including at least 3 years of hands‑on experience as a Data Architect, Data Modeler, or in a closely related role.Demonstrated experience designing data solutions for complex enterprise applications, including relational databases and large-scale transactional or operational systems.Strong experience developing logical and physical data models, database designs, data flows, data migration designs, and source-to-target mappings.At least 3 years of experience using a data architecture or data modeling tool such as SAP PowerDesigner, ER/Studio, erwin Data Modeler, or a comparable platform.At least 5 years of experience working with the Oracle database platform, preferably Oracle19c or later, and related development and administration tools.Strong hands‑on data modeling experience with Oracle, PostgreSQL, Microsoft SQL Server, Azure SQL Database, or similar relational database platforms.Proven experience with database development and design tools, such as Oracle SQL Developer, SQL Navigator, Quest Toad, or comparable tools.Strong analytical experience with database programming languages, including Oracle PL/SQL, Microsoft T-SQL, PostgreSQL PL/pgSQL, or similar.Strong understanding of data integrations, conversions, migrations, transformations, and data integrity controls.Demonstrated knowledge of metadata management, data governance, data quality, data dictionaries, data classification, and related data management practices.Excellent analytical, investigative, problem‑solving, and quantitative skills, with a strong attention to detail and quality.Ability to understand and translate complex business rules, processes, calculations, and system requirements into effective data solutions.Preferred Skills & Experience
A university degree, preferably a master’s degree, in Computer Science, Information Systems, Engineering, or a related discipline.Experience designing data solutions in the defined benefit pension industry, financial services, insurance, or another highly regulated environment.Knowledge of Master Data Management, reference data management, data science, artificial intelligence, and machine learning concepts.Experience supporting actuarial, benefits administration, financial calculation, or other systems involving complex mathematical formulas and business rules.Experience with database schema deployment processes, DevOps practices, and promoting database changes across development, testing, and production environments.Experience providing coaching, mentoring, or technical leadership to junior data professionals.This posting is for an existing vacancy. The expected salary range for this position is $86,000.00 - $130,000.00 per year. You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans – details on these elements of compensation are included within OMERS & Oxford offer letters.As one of Canada’s largest defined benefit pension plans, our people‑first culture is at its best when our workforce reflects the communities where we live and work — and the members we proudly serve. From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier‑free recruitment and selection process that extends all the way through your employee experience.Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision‑making remain central to our candidate experience. We're committed to: We are passionate about inclusion and advocate for I&D across our network of employees, members and partners We are proud of our commitment to developing a best in class approach to complete wellness for our employees and members We invest in our people, providing them with opportunities so they can develop and grow
#J-18808-Ljbffr
Vacancy posted 46 minutes ago
Similar jobs that could be interesting for youBased on the Senior Data Modeler in Winnipeg, MB vacancy
- JOB SUMMARY We are seeking an experienced Senior Data Modeler with strong expertise in enterprise data modeling and insurance domain data. The successful candidate will design, develop, and maintain logical and physical data models that support analytics, reporting, actuarial...Senior
- Apply data modeling expertise to banking and financial services as a Senior Data Modeler supporting business applications, warehouses, and reporting.This experienced Data Modeler designs, develops, and maintains data models for banking and financial services environments. The...Senior
- Drive data integration design with New Value Solutions, supporting Government of Canada modernization and digital transformation... ...work. Client arrangements may be remote, hybrid, or onsite.This Senior Data Modeller position emphasizes source-to-target mappings, transformation...SeniorRemote work
$125k - $140k per year
...Services clients is building a world-class data organization that leverages artificial... ...and consume data. We are seeking a Senior Business Analyst to support the design... ...quality, and help establish scalable data models supporting multiple asset classes and front...SeniorLong term contractTemporary workWork at officeLocal areaRemote work- Apply senior data architecture expertise on-site five days weekly, designing logical and physical models with strong SQL and RDBMS knowledge.This Senior Data Architect and Data Modeller analyzes business requirements, existing applications, databases, and source data models....Senior
- Senior Data Architect / Data ModellerPosition OverviewSeeking a Senior Data Architect / Data Modeller with 8+ years of experience analyzing business requirements, evaluating existing data structures, and designing logical and physical data models. The successful candidate will...Senior
- Elevate your career as a Senior Data Modeler with OMERS, leading data architecture initiatives in a diverse, global environment. Your expertise will shape innovative data solutions across core pension systems. Join the Pension Architecture team at OMERS, where you will play...Senior
- Lead predictive modeling with Databricks and MLflow as a Senior Data Scientist based in Canada. Work remotely on scalable, production-ready machine learning solutions... ...experienced Senior Data Scientist, you will develop models for customer lifetime value, conversion propensity,...SeniorRemote work
- Data modeling and ETL expertise anchor this Senior Business Intelligence Specialist role. Apply SQL Server, Oracle, R Shiny, and analytical skills to complex data... ...deliverables, data quality processes, and information models that help reduce redundant business processes.Key...Senior
- About the job RQ08478 - Data Architect/Modeller - SeniorExperience and Skill Set Requirements Demonstrates experience in working with large scale public safety radio systems that employ P25 trunking, encryption, conventional repeater, and simplex systems. Demonstrates...SeniorWork at officeMonday to friday
- The Senior Data Architect/Modeller will design and evolve enterprise data architecture and data models to enable scalable analytics, AI, and data products. The role will help establish the future-state data architecture, identify critical data assets, and define standards...Senior
- About the job RQ08648 - Data Architect/Modeller - SeniorDescription Responsibilities Develops and supports data architecture for prototype and program development in a complex and distributed environment, including the determination of the flow and distribution of data...SeniorContract work3 days per week
- About the job RQ09051 - Data Architect/Modeller - SeniorDescription Responsibilities: Develops, recommends, implements and manages the technical architecture (hardware, software, database and communications) which will be used for all or specific applications in a large,...Senior
- About the job RQ08912 - Data Architect/Modeller - SeniorResponsibilities: Construct a high-level overview of the entire data landscape of the organization. Illustrate how data moves through the organization and between systems. Develop high-level designs outlining...SeniorFlexible hours
- Direct message the job poster from BuzzClanSenior Data Architect/Data Modeller Location: Toronto, ONDuration: ContractWe are seeking a Senior Data Architect/Data Modeller to advance enterprise data architecture and metadata management practices. The role supports...Senior
$90k - $110k per year
...and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today. Data ModelerJob SummaryWe are seeking an experienced Data Modeler with strong expertise in ACORD Information and Data Models within the insurance domain. The ideal candidate...Long term contractWorldwide- We are looking for a detail-oriented Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business processes and analytics. The ideal candidate will work closely with data engineers, analysts, and business stakeholders to ensure...
- The Data Valorization Department develops, monitors and maintains our credit risk models so that we can offer innovative financing products to our members and clients while ensuring... ...Desjardins’s long-term viability. As a Senior Credit Risk Modelling Data Scientist, you help...SeniorLong term contractInternshipRemote workFlexible hours
- ...advanced Power BI skills. The ideal candidate will have significant experience in data modeling and strong SQL proficiency, alongside project management experience. This role is targeted for a mid-senior level position and is located in the Greater Toronto Area, Canada....SeniorHourly pay
- A leading data solutions company is seeking a Senior Data Architect/Data Modeller in Toronto to enhance enterprise data architecture and metadata management practices. Candidates should have over 10 years of experience in solution design and system integration, with strong...SeniorContract work
- As a Senior Data Scientist in the Credit Risk Analytics team at National Bank, you’ll be responsible for the IFRS 9 and stress testing model development and performance monitoring, as well as IFRS 9 reporting and analytics. This role will also need to support other closely...Senior
- ...Aviva Canada in Toronto, ON is seeking a Data Scientist to join the Commercial P&C Pricing Modelling & Sophistication team, building models and data-driven solutions that improve customer experience and inform business decisions. You’ll manage the full model lifecycle from...Senior
- ...Ledcor is seeking a Senior Data Engineer to design, build, and maintain enterprise-scale data solutions across construction and infrastructure... ...data products. The role requires deep data engineering and modeling expertise, Python/PySpark, and strong communication. #J-18808...Senior
- Ledcor Group is hiring a Senior Data Engineer to join the Data & Analytics Platform team. You will design, build, and maintain enterprise-scale data solutions supporting reporting, analytics, and operational intelligence across Ledcor's construction and infrastructure businesses...Senior
- A technology consulting firm in Ontario seeks a Senior Data Architect/Modeller with 7+ years of experience in developing data models. The role requires proficiency in data modeling methods and tools like ERWIN and Azure services. Responsibilities include creating comprehensive...Senior
$125k - $135k per year
...diverse applications including server, storage, data center, mobile, RF, networking, industrial... ...POSITION SUMMARYWe are seeking a Data and Modeling Engineer to join our IT Applications team.... ...business requirements into reliable data models, consistent KPI definitions, reusable...Long term contractTemporary work- We are looking for an experienced Data Modeler with strong knowledge of data modeling and the Banking / Financial Services domain. The candidate will be responsible for designing, developing, and maintaining data models to support business applications, data warehouses, and...
- ZoomInfo, a leading Go-To-Market Intelligence Platform, is seeking a Senior Analytics Engineer to advance the maturity of our data organization. You will design, build, and own core data models and pipelines powering reports, BI, product analytics, and operational decision-making...Senior
- Stantec is seeking a Senior Database Geologist to join our Energy and Resources Canada West team. The role focuses on integrating, managing, and optimizing large geological datasets to support resource estimation, mining engineering, hydrogeology, mine planning, mineral processing...SeniorRemote work
- A technology consulting firm in Toronto is seeking a Senior Data Architect/Modeller with extensive experience in RF design and telecommunications. The ideal candidate has a professional engineering degree, at least 5 years in the wireless telecom industry, and strong analytical...Senior
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Data Modeler. Be the first to apply!
Related searches
- data modeler Winnipeg, MB
- data architect Winnipeg, MB
- senior financial accountant Winnipeg, MB
- senior sales consultant Winnipeg, MB
- senior communications specialist Winnipeg, MB
- senior bookkeeper Winnipeg, MB
- senior system administrator Winnipeg, MB
- senior technical recruiter Winnipeg, MB
- senior director Winnipeg, MB
- senior technical specialist Winnipeg, MB

