Data Modeler

Iris's Fortune 100 direct client is looking for Data Modeler. Please find below Job description and share me your updated resume at Saurav.upadhyay@irissoftware.com .

Position: Data Modeler

Location: Toronto Ontario

Key Responsibilities:

• Design, develop, and maintain conceptual, logical, and physical data models to support enterprise DataOps platform capabilities and business data requirements.
• Collaborate with business stakeholders, Solution Architects, Data Engineers, and application teams to translate business requirements into scalable and reusable data models.
• Analyze source systems and onboard new business use cases by defining target data structures, data flows, and integration requirements.
• Develop and optimize relational and dimensional data models, including Star Schema and Snowflake Schema designs for analytics, reporting, and operational data processing.
• Perform source-to-target mapping, data profiling, gap analysis, and impact assessments to support reliable data integration and migration initiatives.
• Create and maintain data dictionaries, metadata repositories, entity-relationship diagrams (ERDs), and data lineage documentation to ensure data governance and traceability.
• Establish and enforce enterprise data modeling standards, naming conventions, data quality rules, and governance policies across the DataOps ecosystem.
• Partner with Data Engineering and ETL/ELT teams to design efficient data structures that improve performance, scalability, and data processing efficiency.
• Support schema evolution, model enhancements, and change management activities as new business domains and use cases are introduced.
• Ensure compliance with enterprise data security, privacy, regulatory, and governance requirements, particularly for sensitive financial and customer data.
• Utilize data modeling tools such as ERwin, ER/Studio, PowerDesigner, or equivalent platforms, along with advanced SQL for data analysis, validation, and optimization.
• Contribute to DataOps and cloud data modernization initiatives, leveraging best practices in data warehousing, metadata management, CI/CD, data quality monitoring, and reusable data product development.

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.