Data Modeler

Iris's client, the largest bank in the United States is looking to hire Data Modeler

Please find below the job details and share your resume if interested at [email protected]

Job Description:

Title: Data Modeler

Location: Toronto, ON (Hybrid – 2-3 days/Week)

Duration: Long term assignment

Job Description:

Key Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models supporting enterprise DataOps Platform capabilities and business use cases.
• Collaborate with business stakeholders, Solution Architects, Data Engineers, and platform teams to translate business requirements into scalable, reusable data models.
• Support onboarding of multiple business use cases onto the DataOps Platform by analyzing source systems, defining target data structures, and identifying opportunities for data model reuse.
• Develop relational and dimensional data models, including Star and Snowflake schemas, to support data ingestion, transformation, analytics, and reporting.
• Perform source-to-target data mapping, data profiling, schema analysis, and impact assessments to enable reliable data integration across applications.
• Define and maintain data dictionaries, metadata, entity-relationship diagrams, and data lineage documentation.
• Establish and enforce data modeling standards, naming conventions, data quality rules, and governance requirements across the platform.
• Work closely with Data Engineering and ETL/ELT teams to optimize data structures for performance, scalability, and efficient processing.
• Support schema evolution, change management, and data model enhancements as new use cases are onboarded.
• Ensure data models align with enterprise security, privacy, compliance, and data governance requirements, particularly for sensitive banking and financial data.

Required Skills

• 5–6 years of 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.

Preferred / Good-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.

Best Regards,

Sandeep Goyal

Address: 200 Metroplex Dr. Edison, NJ 08817

Cell: 732.426.8546

Email: [email protected] | www.irissoftware.com