Senior Data Modeler – Azure & Databricks

Recrute Action; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading recruitment agency is seeking a Senior Data Modeler for a hybrid contract in the insurance sector. This role demands expertise in data modeling, collaboration with various stakeholders, and proficiency in Azure technologies. Ideal candidates will possess a strong background in data strategy and architecture, delivering impactful results in an enterprise-level environment.

Qualifications

• 5 to 8 years of experience in IT, with at least 4 years in data model design.
• Proficiency in relational database systems (RDBMS), experience in big data environments.
• Strong expertise in Azure data solutions and SQL.

Responsibilities

• Understand and translate complex business needs into scalable data models.
• Collaborate with business partners to gather and analyze system requirements.
• Architect, design, and maintain conceptual, logical, and physical data models.

Skills

Data modeling

Data analysis

Communication

Problem-solving

Attention to detail

Education

Bachelor’s degree in computer science or related field

Tools

PowerDesigner

Erwin Data Modeling tools

Job description

Senior Data Modeler – Azure & Databricks
Hybrid contract opportunity in the insurance industry for a skilled data modeler with strong experience in information architecture, data strategy, and Azure solutions. Work with investment data in a collaborative, enterprise-level environment supporting a global data strategy.

What is in it for you:
• Salaried: $75-85 per hour.
• Incorporated Business Rate: $90-100 per hour.
• 6-month contract.
• Full-time position: 37.50 hours per week.
• Weekday schedule from 9 am to 5 pm.
• Hybrid work: in-office Tuesday to Thursday.

Responsibilities:
• Understand and translate complex business needs into scalable and long-term data models.
• Collaborate closely with business partners, stakeholders, functional experts, business analysts, contractors, and developers to gather and analyze system requirements.
• Architect, design, and maintain conceptual, logical, and physical data models using industry best practices.
• Work with Application Development teams to implement data strategies, build data flows, and support solution delivery.
• Develop and maintain metadata repositories and document data lineage to ensure transparency and traceability.
• Ensure data model quality, consistency, and performance by optimizing models to reduce redundancy and improve accuracy.
• Reverse-engineer physical data models from existing databases and SQL scripts.
• Evaluate data models and physical databases for discrepancies and recommend improvements.
• Apply and enforce standardized naming conventions, coding practices, and modeling guidelines.
• Recommend opportunities for reuse and standardization of existing data models across projects.
• Identify and address data-related system integration challenges, proposing viable technical solutions.
• Define and maintain clear data definitions for all data tables.
• Validate business data objects for accuracy and completeness.
• Communicate model constraints, interdependencies, and limitations clearly to data engineers, technical teams, and business stakeholders.
• Provide guidance and support to system analysts, developers, and other project team members regarding data model usage and constraints.
• Ensure understanding and application of OLAP, reporting, and analytics principles in model design.
• Take full ownership of data modeling activities, performing hands-on work with accountability for results.

What you will need to succeed:
• Bachelor’s degree in computer science, information systems, or a related field.
• 5 to 8 years of experience in IT, with at least 4 years specifically in data model design.
• Strong data modeling and data analysis skills, with the ability to take ownership and perform hands-on modeling work.
• Proficiency in relational database systems (RDBMS).
• Experience working in big data environments.
• Expertise in big data technologies and Databricks.
• Solid experience with business intelligence and data warehousing development technologies.
• Experience with Azure data solutions and SQL.
• Expertise with PowerDesigner or Erwin Data Modeling tools.
• Ability to reverse-engineer physical data models from databases and scripts.
• Familiarity with capital markets and investment data.
• Understanding of OLAP, reporting, and analytics principles.
• Clear and effective communication skills, both verbal and written.
• Strong work ethic with a focus on results, accuracy, and attention to detail.
• Ability to work independently, navigate ambiguity, and proactively solve problems.

Nice-to-Have:

• Knowledge of the wealth management and/or capital markets industry.
• Experience with the Hortonworks/Cloudera Hadoop platform.

Why Recruit Action?
Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted.

# MFCJP00015100