Business Data Modeler (PL768)

Confidential

Toronto , Ontario, Canada permanent

Posted: January 30, 2026

Job Description

We are seeking an experienced Business Data Modeler to support our consulting-sector client in designing, structuring, and optimizing enterprise data models across Finance, Marketing, and HR domains.
The ideal candidate brings strong domain expertise, excellent requirement-gathering and logical design capabilities, and hands-on experience working within modern data ecosystems—particularly Azure Databricks, Delta Lake, and Azure Data Lake.

This role requires a blend of business understanding and technical proficiency to translate complex business processes into scalable, accurate, and well-documented data models.

Key Responsibilities

Domain & Business Understanding

• Partner with business stakeholders across Finance, Marketing, and HR to understand processes, data flows, and reporting requirements.

• Translate business concepts into conceptual, logical, and physical data models.

• Ensure alignment between business requirements, technical solutions, and data governance standards.

Data Modeling & Design

• Develop and maintain conceptual, logical, and physical data models (ERDs, data flow diagrams, canonical models).

• Apply best practices including normalization/denormalization, star/snowflake schemas, and optimized design for analytics/reporting.

• Support the consolidation of complex source systems (e.g., SAP, Salesforce, PeopleSoft) into integrated enterprise models.

• Document data models, definitions, relationships, and lineage for both technical and non-technical stakeholders.

Requirement Gathering & Documentation

• Lead structured requirement-gathering sessions with SMEs and technical teams.

• Produce functional and technical documentation including BRDs, FRDs, Logical Design Documents, and metadata definitions.

• Communicate models and requirements clearly to engineering, analytics, and business teams.

Data Analysis & SQL Development

• Write and optimize complex SQL queries to support data profiling, transformation logic, and validation.

• Conduct data quality assessments and ensure compliance with governance, audit, and regulatory requirements.

Technical Ecosystem & Integration

• Work with modern data platforms including:

• Azure Databricks, Delta Lake, Unity Catalog, Azure Data Lake

• SAP Finance/S4 (optional)

• Salesforce CRM (optional)

• PeopleSoft HR (optional)

• Participate in data integration, metadata management, reference data harmonization, and enterprise information management initiatives.

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.