The database developer job, data analyst job or report writer job are related job roles that may be performed by the same person depending on how the size of the organization.
In most organizations, the business analyst or software developer starts out performing all three types of jobs. As demand multiplies and the individual begins to feel overwhelmed, the jobs are split … and as time goes … into the three (3) different type of jobs.
For this reason, anyone performing the duties of a business analyst, software developer, database analyst, report writer or database developer needs to have a strong understanding of each of these job responsibilities as well as the areas of overlap.
Here is a summary of the responsibilities of each role:
The data analyst gathers, analyzes or models data with the goal of identifying useful information, trends and patterns which may be directly used by management, decision makers or stakeholders.The data analyst works extensively with SQL within the context of the relational database system (RDBMS).
The database developer creates the logical data model comprising of entities and relationships or implements the physical model using the tables, views, queries, stored procedures or relationships needed by the relational database model.
The report writer develops reports used in presenting information queried from one or more tables or databases. They report writers report development is achieved using SQL, relational database development skills and tools like SQL Reporting Services, Crystal Reports, Business Objects or HTML for Intranet / Extranet Online Reporting Solutions.
The rest of this post presents the tasks or activities typically performed by database developers, database analysts or report writers.