Business Data Modeler (PL768)

Paralucent Inc; Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

A consulting firm is seeking an experienced Business Data Modeler to support clients with enterprise data model design across Finance, Marketing, and HR domains. The ideal candidate should have over 7 years of experience, strong domain expertise, and proficiency in SQL and Azure data platforms. This is a fully remote position for 6 months with potential for extension.

Qualifications

• 7+ years of experience in data modeling, data analysis, or business data architecture.
• Strong domain knowledge in Finance, Marketing Analytics, or HR management.
• Proven experience creating conceptual/logical/physical data models.

Responsibilities

• Partner with business stakeholders to understand processes and data flows.
• Translate business concepts into conceptual, logical, and physical data models.
• Develop and maintain ERDs and data flow diagrams.
• Lead requirement-gathering sessions with SMEs and technical teams.
• Write and optimize complex SQL queries for data profiling.
• Participate in data integration and enterprise information management initiatives.

Skills

Domain expertise

Requirement-gathering

Logical design capabilities

Data modeling

SQL proficiency

Data quality assessment

Tools

Azure Databricks

Azure Data Lake

Delta Lake

SQL

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.

• 7+ years of experience in data modeling, data analysis, or business data architecture.

• Strong domain knowledge in at least one of the following:

  • Finance (GL, WIP, Time & Expense, AR, vendor accounting; SAP Finance preferred)

  • Marketing Analytics (client analytics, campaigns, sales pipeline; Salesforce familiarity preferred)

  • HR/People Management (staffing, utilization, workforce planning; PeopleSoft familiarity preferred)

• Proven experience creating conceptual/logical/physical data models.

• Proficiency in SQL for data exploration and validation.

• Experience with Databricks or similar cloud data platforms.

• Strong understanding of data quality, data lineage, metadata, and compliance.

Nice-to-Have

• Experience with Azure cloud services.

• Familiarity with enterprise reporting systems, CDS views, or BW/4HANA.

• Exposure to enterprise data warehouse modeling and integration patterns.

• Strong documentation skills and ability to communicate complex concepts to diverse audiences.

Location: Fully Remote
Duration: 6 Months (Strong Possibility of Extension)