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
