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)
#J-18808-Ljbffr
