Senior Data Modeler - 15625

Senior Data Modeler - 15625

Location Address: Toronto - Hybrid - 3 days in office

Contract Duration: ASAP - 04/10/2026

Number of Positions: 2

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs./week or 8am-4pm if they prefer.

We are seeking a dedicated and experienced Data Modeling Specialist to join our team. The successful candidate will be responsible for expanding our catalogue of reusable common data model patterns, refining our data reference architectures, and ensuring a robust data management framework. This role requires deep expertise in leveraging the Azure product suite to optimize performance and scalability and an ability to align data capabilities with strategic objectives.

The ideal candidate should be experienced in data architecture or data modeling in enterprise data management environment.

Key Responsibilities:

• Develop and maintain conceptual, logical, and physical data models to support data analysis and business intelligence initiatives.

• Collaborate with stakeholders, including business analysts and data engineers, to gather requirements and ensure data models align with business needs.

• Design and implement database schemas, tables, and relationships to optimize for performance and scalability.

• Conduct data profiling and analysis to understand data patterns and quality issues.

The IT/Data Architect is responsible for assessing business requirements, collecting, identifying, and approving technical specifications, and developing technology solutions that are viable for business applications, LOB applications, workflow systems, purchased applications, developed applications, and applications integration. The IT Architect is considered the highest-level domain technology expert.

• Conduct thorough discovery exercises to gain a detailed understanding of the current data landscape.

• Ensure architectures align with business strategies and technology standards.

• Document and formalize an approved inventory of data capabilities and tools, ensuring alignment with strategic objectives.

• Expand and develop a comprehensive catalogue of reusable data patterns to promote consistency, efficiency, and adherence to best practices across the organization.

• Create and continuously refine target data reference architectures utilizing the Azure product suite to achieve optimal performance and scalability.

• Identify and recommend opportunities for improvement and optimization.

• Collaborate with cross-functional teams to ensure the effective adoption of data patterns.

• Implement a systematic approach to organizing and storing documentation, ensuring easy accessibility, robust version control, and compliance with governance standards.

• Maintain a centralized repository for all data architecture-related documentation.

Must Have Skills:

• 8+ years of experience.

• Proven experience in data architecture and management in the financial and insurance industry, particularly with the Azure product suite.

• Strong understanding of data governance, data modeling, and data integration practices.

• Experience with documentation tools and version control systems.

• Strong experience in data modeling tools (such as ER/Studio, Erwin, or similar) and relational database management systems (RDBMS) like SQL Server, Oracle, or MySQL.

• Proficiency in SQL for data manipulation and querying.

• Understanding of data warehousing concepts, including star schema and snowflake schema designs.

Nice-To-Have Skills:

• ITILv3 certifications are a plus.

• Strong understanding of relational data structures, theories, principles, and practices is preferred.

• Knowledge and skills in big data, data warehousing methodologies and tools are preferred.

• Familiarity with NoSQL databases and big data technologies is a plus.

• Relevant certifications in Azure or data management are a plus.

Education:

Bachelor’s degree in computer science, Information Systems, Data Management, or a related field. Master’s degree preferred.