Business Analyst vs. Data Architect: Who should do the source-to-target mapping?
An Oracle user asks who should do the source-to-target mapping in a company--the Business Analyst or Data Architect.
- A Business Analyst (BA) is responsible for analyzing the business needs of their clients to help identify business problems and propose solutions. Typical BA activities include requirements gathering (functional and non-functional), solutions development, project planning, etc.
- A Data Architect, on the other hand, is responsible for developing and maintaining a formal description of the data and data structures - this can include data definitions, data models, data flow diagrams, etc. Typical activities include data modelling, ETL (Extraction / Transformation / Load) processing, data mining, data analysis, etc.
The better answer, then, in my opinion, would be a Data Architect. In most scenarios, the Business Analyst would document the requirements while the data architect would perform the actual mapping of the data.
Dig Deeper on Oracle management
Related Q&A from Michael Hillenbrand
What is the difference between a database engineer, architect and administrator?
Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Performance goals for DBAs
Do you have any suggestions on how to measure DBA job performance and provide meaningful goals for performance management of DBAs? Continue Reading