Sr Data Modeler

Our client, a leading Canadian commercial insurance organization, is seeking an experienced Senior Data Modeler to join their enterprise data team. In this role, you will be responsible for designing, developing, and maintaining high-performance conceptual, logical, and physical data models to support analytics, reporting, and enterprise-wide data solutions.

Operating within a modern cloud ecosystem, you will leverage your expertise in the Snowflake Cloud Data Platform and dimensional modeling techniques to build scalable data structures. You will collaborate closely with Data Architects, Data Engineers, BI teams, and key business stakeholders across domains such as finance, claims, and operations to translate business requirements into robust data architectures.

Advantages
Balanced Hybrid Model: Enjoy work-life balance with a hybrid setup featuring 3 days onsite in downtown Toronto.

Modern Tech Stack: Work extensively with cutting-edge cloud technologies, including Snowflake, Microsoft Azure, dbt, and advanced BI tools.

Enterprise Impact: Lead the architectural design of critical data marts supporting business-wide analytics, reporting, and operational efficiency.

Collaborative Environment: Join an innovative team that values continuous learning, mentoring, and strong cross-functional collaboration.

Responsibilities
Enterprise Data Design: Design, develop, and maintain conceptual, logical, and physical data models for scalable enterprise data solutions.

Cloud Platform Optimization: Create and optimize scalable data models within the Snowflake Cloud Data Platform, applying best practices in clustering, partitioning, and storage design to maximize query performance.

Dimensional & Normalized Modeling: Develop dimensional models—including star schemas, snowflake schemas, and normalized 3NF models—to support business analytics and operational reporting.

Stakeholder Collaboration: Partner with business stakeholders, Data Architects, Data Engineers, and BI teams to capture requirements and translate them into robust data structures.

Domain Data Marts: Support the architecture and design of enterprise data marts across finance, customer, underwriting, claims, and operational domains.

Pipeline & Governance Alignment: Collaborate with Data Engineering teams on ETL/ELT pipelines while ensuring compliance with data governance, security, privacy, and quality standards.

Metadata & Lineage Management: Maintain comprehensive metadata, business glossaries, data lineage, and detailed data dictionaries.

Agile & Architecture Delivery: Participate in Agile ceremonies, perform impact assessments for data model changes, participate in architecture reviews, and mentor junior team members.

Qualifications
Education: Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.

Core Experience: 7+ years of experience in enterprise data modeling, data warehouse design, and modern data architecture.

Snowflake Expertise: 3+ years of direct, hands-on experience designing and optimizing models within the Snowflake Cloud Data Platform.

Data Modeling Mastery: Deep technical proficiency in Conceptual, Logical, and Physical modeling, Dimensional Modeling (Star Schema/Snowflake Schema), and Third Normal Form (3NF).


Advanced Technical Skills:

- Advanced SQL proficiency and query performance optimization.

- Strong experience with cloud ecosystems, primarily Microsoft Azure or AWS.

- Hands-on familiarity with business intelligence and reporting platforms, particularly Power BI or Tableau.

- Experience with ETL/ELT integration tools (e.g., dbt, Azure Data Factory, Informatica, Matillion, or Talend).

- Hands-on skill with enterprise modeling tools such as ERwin, ER/Studio, PowerDesigner, or Lucidchart.

Methodology: Proven background working within Agile/Scrum delivery environments.

Summary
This is an exceptional opportunity for a senior-level Data Modeler looking to shape the enterprise data strategy of a top-tier Canadian financial and commercial organization. If you bring strong expertise in Snowflake, Azure, SQL, and dimensional data design, we encourage you to apply.

Please submit your updated resume for immediate consideration.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.