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 sandeep.goel@irissoftware.com

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: sandeep.goel@irissoftware.com | www.irissoftware.com