Sr Data Modeler /Architect Role

Iris Software Inc.; Toronto; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

Iris Software Inc. is seeking a Sr Data Modeler/Architect for a long-term opportunity in Toronto, ON, with a hybrid work arrangement.

The direct client is a leading Banking and Financial Company, offering a challenging role to design and evolve enterprise data models, data warehouses, and governance frameworks across cloud platforms. You will collaborate with Solution Architects, Data Engineers, and business teams in an Agile setting, applying DataOps practices, ensuring data quality, lineage,

Qualifications

• 10+ years of experience with at least 5–6 years in data modeling and architecture.
• Proficiency in conceptual, logical, physical, relational, and dimensional modeling.
• Hands-on with ERwin/ER/Studio/PowerDesigner and SQL across Oracle/SQL Server/PostgreSQL/Snowflake/Redshift.

Skills

Data modeling

Data architecture

Data warehousing

SQL proficiency

Cloud data platforms

DataOps knowledge

ETL/ELT

Governance & security

Agile delivery

Stakeholder collaboration

Tools

ERwin

ER/Studio

PowerDesigner

Job description

Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a Sr Data Modeler /Architect Role for a long term opportunity at Toronto, ON (Hybrid Position).

Location: Toronto, ON (Hybrid Position)

Duration: Long Term Position /Open Ended SOW (12+ Months)

Required Skills:

• Need over all 10+ years of experience and must have 5–6 years of strong experience in Data Modeling, Database Design, Data Warehousing, or Enterprise Data Platforms.
• Strong proficiency in conceptual, logical, physical, relational, and dimensional data modeling.
• Hands-on experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, or equivalent.
• Strong SQL skills for data analysis, profiling, validation, and query optimization.
• Experience working with databases and cloud data platforms such as Oracle, SQL Server, PostgreSQL, Snowflake, Amazon Redshift, or equivalent.
• Good understanding of DataOps principles, including automated data pipelines, data quality, metadata management, lineage, monitoring, and repeatable onboarding processes.
• Experience with ETL/ELT processes, source-to-target mappings, data integration, and data warehousing architectures.
• Understanding of data governance, master/reference data, data security, and regulatory compliance considerations.
• Experience collaborating with Solution Architects, Data Engineers, application teams, and business stakeholders in Agile delivery environments.
• Strong analytical, problem-solving, documentation, and communication skills.

Nice to have Skills:

• Experience working on enterprise DataOps or cloud-based data platform modernization initiatives.
• Exposure to AWS data services such as Amazon S3, AWS Glue, Amazon Redshift, and AWS Lake Formation.
• Familiarity with modern data architecture concepts such as Data Lakes, Lakehouse, Data Mesh, and reusable data products.
• Knowledge of data cataloging, metadata management, and data lineage tools.
• Experience in Banking and Financial Services (BFSI), including customer, account, transaction, payments, or regulatory data domains.
• Familiarity with CI/CD, version control, and automated data model deployment practices.

About Iris Software Inc.

With 4,000+ associates and offices in India, U.S.A. and Canada, Iris Software delivers technology services and solutions that help clients complete fast, far-reaching digital transformations and achieve their business goals. A strategic partner to Fortune 500 and other top companies in financial services and many other industries, Iris provides a value-driven approach - a unique blend of highly-skilled specialists, software engineering expertise, cutting-edge technology, and flexible engagement models. High customer satisfaction has translated into long-standing relationships and preferred-partner status with many of our clients, who rely on our 30+ years of technical and domain expertise to future-proof their enterprises. Associates of Iris work on mission-critical applications supported by a workplace culture that has won numerous awards in the last few years, including Certified Great Place to Work in India; Top 25 GPW in IT & IT-BPM; Ambition Box Best Place to Work, #3 in IT/ITES; and Top Workplace NJ-USA.