Key skills
Data EngineeringData LakeAnalyticsSnowflakeAzureOracleERPSAPSales
About this role
Job Profile: Data Architect -- Sales/Finance Domain Expert
Location: (100% Remote)
Duration: 8 months
Role Overview
This role plays a key part at the start of the project, working with multiple business units to gather and define Finance, Sales and Marketing data requirements across diverse ERP systems such as SAP, AS400, DataWorks, SAP Business ByDesign, and Oracle JD Edwards. With most data sourced from SAP and future ERP migrations planned, strong SAP Sales & Marketing domain expertise is essential. The role bridges business and technical teams, defines source to target mappings, and collaborates closely with data modelers to design scalable Fact and Dimension models that support enterprise wide Sales, Finance, and Marketing reporting. Candidate must have working experience in Datalake, Datawarehouse and understand the basic concepts.
Key Responsibilities
Work with multiple business units to gather, analyze, and document Sales and Marketing data requirements across various ERP systems.
Collaborate closely with Sales and Marketing teams to understand ERP tables and business context.
Define attribute level source to target mappings from ERP systems.
Translate business requirements into functional and technical specifications for data engineering teams.
Create and maintain project documentation such as data dictionaries and mapping documents.
Act as a bridge between business stakeholders and technical teams, ensuring alignment and clarity.
Partner with the Data Modeler to design and validate Fact and Dimension models for analytics and reporting.
Required Skills & Expertise (Must have)
Strong ERP techno functional experience, especially in Sales and Marketing modules (SAP preferred).
Solid understanding of master and transactional ERP data.
Ability to query, analyze, and validate data from source systems.
Experience working with multiple ERP platforms and integrating diverse data sources.
Understanding of Datawarehouse, Data Lake concepts, Knowledge of Row Level / Column Level security Core data modeling concepts (such as Star Schema vs. Snowflake Schema), and the difference between a Data Warehouse and a Lakehouse.
Hands on experience as Data Analyst/Data Engineer/Architect in Datalake projects Good to have experience in Azure Data Services/Data lake/Fabric