Job description
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.
Requirements
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)
