Following are the data management job descriptions for the Kforce 2008 Salary Survey.
Data Management
Data Warehouse Specialist
Other Titles: Data Warehouse Developer
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Data warehouse tool training, OLAP/DSS/Data Mining
JOB DESCRIPTION: Focuses on designing and developing enterprise-wide repositories for all corporate data storage typically utilizing SQL-based database products including DB2, SQL Server, Oracle, Sybase and other database systems, or other specialized decision support or expert systems. Defines requirements and tools to interface all current and legacy data into a central data warehouse. May also help define the usage of queries and reporting tools to support corporate business units or external customers when combining and analyzing large volumes of information contained within the corporate data warehouse.
Database Administrator
OTHER TITLES: DBA
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Certified DBA, Oracle DBA, or SQL Server Preferred
JOB DESCRIPTION: Creates physical database tables, typically from designs provided by the database analyst or data modeler. Administers and controls an organization's data resources, including multiple relational databases and servers. Performs physical database design, works with system administrators and uses data dictionary software packages to ensure data integrity and security, recovers corrupted data and eliminates data redundancy. Uses tuning tools to improve database performance. Requires expertise with Oracle, Sybase, MS SQL Server or other relational databases. Works with the applications development teams(s), focusing on the back-end portion of data storage considerations and performance considerations for application systems being developed.
Database Architect
OTHER TITLES: Data Architect, Data Warehouse Architect
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Certified DBA, Oracle DBA, or SQL Server Preferred
JOB DESCRIPTION: Designs and builds complex relational databases and data warehouses. Works with technical as well as end users to understand business requirements and identify data solutions. Develops strategies for data acquisitions, archive recovery, and implementation of a database on an enterprise level. Significant experience with the design, development and maintenance of enterprise level data systems such as Oracle, SQL Server, Teradata or others. Works in conjunction with and may provide leadership and direction to a team of database developers to meet technical requirements. Database Architects must also have in depth expertise with data security, storage solutions, database virtualization and replication as well as other complex technical tools and solutions.
Database Analyst/Data Modeler
OTHER TITLES: Data Analyst, Logical Data Analyst
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
JOB DESCRIPTION: Uses data modeling techniques and tools in analyzing and specifying data structures to be implemented within an application system. In a client/server development environment, responsibilities include defining back-end database structures from a logical or application-oriented perspective to ensure that all front-end development efforts correlate with the appropriate tables and fields required by the system. Also defines logical views and works with the database administrator to create physical data structures.
ERP Application Architect
OTHER TITLES: Sr. PeopleSoft/SAP Architect, Sr. ERP Consultant, ERP Technical Architect, CRM Application Architect
EXPERIENCE: 6+ years
EDUCATION: BS/BA Highly Preferred
JOB DESCRIPTION: Specific expertise in solving complex ERP Application integration business solutions. Primarily organizes business and functional requirement and designs the appropriate solutions within packaged ERP applications. Is involved in determining the long-range strategic direction of systems and manages the process and business model changes required to make an ERP/CRM solution successful. Provides applications and administration expertise in specific technical areas or modules. Will typically work with a development team as the Sr. business solution resource and provide solution capabilities to the technical team as well as the end user/customer. Requires significant expertise in applicable application and technology and bring a dynamic problem solving ability to meet the demands of enterprise integration.
ERP SW Integration/Implementation Specialist
OTHER TITLES: ERP developer, CRM developer, ERP configuration specialists
YEARS EXPERIENCE: Junior 1-2 years/ Mid-level 3-5 years/ Senior 6+ years
EDUCATION: BS/BA Preferred
CERTIFICATION/TRAINING: Specific ERP CERTIFICATION: SAP, Peoplesoft, Baan, QAD
JOB DESCRIPTION: Analyzes and designs system specifications for integrating all business processes into a single company-wide business system. Requires knowledge of multiple business areas including manufacturing, distribution, customer service and accounting. Also requires knowledge of process engineering and re-engineering with strong communications skills and solid documentation skills, plus an in-depth understanding ERP/MRP software packages. Frequently participates on projects to customize ERP/MRP packages to better meet the specific needs of the organization.
Data Management
Data Warehouse Specialist
Other Titles: Data Warehouse Developer
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Data warehouse tool training, OLAP/DSS/Data Mining
JOB DESCRIPTION: Focuses on designing and developing enterprise-wide repositories for all corporate data storage typically utilizing SQL-based database products including DB2, SQL Server, Oracle, Sybase and other database systems, or other specialized decision support or expert systems. Defines requirements and tools to interface all current and legacy data into a central data warehouse. May also help define the usage of queries and reporting tools to support corporate business units or external customers when combining and analyzing large volumes of information contained within the corporate data warehouse.
Database Administrator
OTHER TITLES: DBA
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Certified DBA, Oracle DBA, or SQL Server Preferred
JOB DESCRIPTION: Creates physical database tables, typically from designs provided by the database analyst or data modeler. Administers and controls an organization's data resources, including multiple relational databases and servers. Performs physical database design, works with system administrators and uses data dictionary software packages to ensure data integrity and security, recovers corrupted data and eliminates data redundancy. Uses tuning tools to improve database performance. Requires expertise with Oracle, Sybase, MS SQL Server or other relational databases. Works with the applications development teams(s), focusing on the back-end portion of data storage considerations and performance considerations for application systems being developed.
Database Architect
OTHER TITLES: Data Architect, Data Warehouse Architect
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
CERTIFICATION/TRAINING: Certified DBA, Oracle DBA, or SQL Server Preferred
JOB DESCRIPTION: Designs and builds complex relational databases and data warehouses. Works with technical as well as end users to understand business requirements and identify data solutions. Develops strategies for data acquisitions, archive recovery, and implementation of a database on an enterprise level. Significant experience with the design, development and maintenance of enterprise level data systems such as Oracle, SQL Server, Teradata or others. Works in conjunction with and may provide leadership and direction to a team of database developers to meet technical requirements. Database Architects must also have in depth expertise with data security, storage solutions, database virtualization and replication as well as other complex technical tools and solutions.
Database Analyst/Data Modeler
OTHER TITLES: Data Analyst, Logical Data Analyst
YEARS EXPERIENCE: Junior 1-2/Mid-Level 3-5/Senior 6+
EDUCATION: BS/BA Required
JOB DESCRIPTION: Uses data modeling techniques and tools in analyzing and specifying data structures to be implemented within an application system. In a client/server development environment, responsibilities include defining back-end database structures from a logical or application-oriented perspective to ensure that all front-end development efforts correlate with the appropriate tables and fields required by the system. Also defines logical views and works with the database administrator to create physical data structures.
ERP Application Architect
OTHER TITLES: Sr. PeopleSoft/SAP Architect, Sr. ERP Consultant, ERP Technical Architect, CRM Application Architect
EXPERIENCE: 6+ years
EDUCATION: BS/BA Highly Preferred
JOB DESCRIPTION: Specific expertise in solving complex ERP Application integration business solutions. Primarily organizes business and functional requirement and designs the appropriate solutions within packaged ERP applications. Is involved in determining the long-range strategic direction of systems and manages the process and business model changes required to make an ERP/CRM solution successful. Provides applications and administration expertise in specific technical areas or modules. Will typically work with a development team as the Sr. business solution resource and provide solution capabilities to the technical team as well as the end user/customer. Requires significant expertise in applicable application and technology and bring a dynamic problem solving ability to meet the demands of enterprise integration.
ERP SW Integration/Implementation Specialist
OTHER TITLES: ERP developer, CRM developer, ERP configuration specialists
YEARS EXPERIENCE: Junior 1-2 years/ Mid-level 3-5 years/ Senior 6+ years
EDUCATION: BS/BA Preferred
CERTIFICATION/TRAINING: Specific ERP CERTIFICATION: SAP, Peoplesoft, Baan, QAD
JOB DESCRIPTION: Analyzes and designs system specifications for integrating all business processes into a single company-wide business system. Requires knowledge of multiple business areas including manufacturing, distribution, customer service and accounting. Also requires knowledge of process engineering and re-engineering with strong communications skills and solid documentation skills, plus an in-depth understanding ERP/MRP software packages. Frequently participates on projects to customize ERP/MRP packages to better meet the specific needs of the organization.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Conversation with Richard Muirhead of Tideway Systems
- Richard Muirwood, CEO of Tideway Systems, and I had our semi-annual chat the other day. Tideway's Tideway Foundation™is a management tool making it possible for organizations to get a clear understanding of the underlying physical and virtual infrastructure supporting their business applications. They call what they do "dependency mapping." ...
- Blog posts 2008-10-11
- Print this: Actually, please don't, but DO think about why printers should get more airtime in green tech discussions
- I was talking to someone within the past couple of months (I honestly can't remember who right now, sorry) who made a pretty profound statement that seems pertinent in the context of this post. I had just admitted, somewhat shamefacedly, to my ongoing addiction to printing out my notes, presentations...
- Blog posts 2008-10-10
- Will Bush sign Pro-IP? Biz, labor, schools push for it
- There's no word yet on whether President Bush will sign the PRO-IP bill [ZDN] but big business and labor were united in favor of the bill that creates a copyright czar in the executive branch. The bill originally called for the Justice Dept. to prosecute copyright...
- Blog posts 2008-10-10
- America's airways ready for NextGen
- It's time – long past time – to upgrade the U.S. air traffic control system. The current system, designed during World War II, contributes mightily to flight delays, customer dissatisfaction and a massive energy wastefulness. But a GPS satellite-based system, on the drawing board for more than a decade, has...
- Blog posts 2008-10-10
- Is Google working on the synchronization problem?
- ReadWriteWeb has a post up about the fact that Zoho has added offline access to Zoho Mail using Gears. Zoho continues to do a really good job of innovating when it comes to Ajax-based RIAs. They were very early to the game in creating offline support for Zoho Docs before...
- Blog posts 2008-10-10
- Microsoft: How we'll take on VMware
- The software maker believes it has the tools and the right price point to beat VMware in the battle for the virtualisation market. Microsoft has a three-pronged strategy to beat VMware in the virtualization market, according to the company's senior director for virtualization product management, Zane Adam. ...
- News items 2008-10-10
- My Awesome IT Job: Director of Rich Media Group at Microsoft
- Hey, we all complain about work from time to time; we've all had lousy jobs. But before you call it a day and head off to the support group that meets at the bar, here are a few words from an IT pro that loves their work. ...
- Blog posts 2008-10-10
- Consumers score a partial win against Walmart
- Walmart has done a 180 on its earlier decision to pull the plug on its DRM servers (thereby locking customers' music collection to whatever PC it happened to be on at the time) and decided to keep the DRM servers running - for now. Important Information About Your Digital Music Purchases ...
- Blog posts 2008-10-10
- Is OpenOffice good enough?
- Yes. OK, obviously there's more to this story than my tongue-in-cheek answer. This came up after one of our supercool, power user secretaries (who is an Office 2003/2007 wiz) ran a training session for the other secretaries in the district. The other secretaries are largely...
- Blog posts 2008-10-10
- Forrester: Credit crunch may freeze tech services projects
- Forrester Research in a report is confirming that the credit crunch is beginning to hit technology services firms. The extent of the damage is unclear, but IBM's lower-than-expected third quarter revenue its earnings are stronger than expected may indicate something worse is afoot. Forrester's...
- Blog posts 2008-10-10
- Virtualization 2.0 panel recording from NGDC is available
- Back in August, I had the opportunity to moderate a panel at the Next Generation Data Center Conference, entitled "Virtualization 2.0".The panel included Albert Lee, Chief Strategy Officer and Board Director of xkoto, Greg O'Connor, CEO of Trigence, Jonah Paransky, Marketing VP of StackSafe and Lawrence Stein, Engineering VP of...
- Blog posts 2008-10-10
- From Chapter Two: The appliance computing culture
- The most striking thing about the appliance computing applications market is that most customers have one or two global applications and a range of special purpose stuff accumulated and refined over many years - the opposite of what happens in data processing where thousands of tiny applications get strung...
- Blog posts 2008-10-10
- Image Copyrighter Pro (zip)
- Image copyrighter takes the copyright information you provide and converts that into binary data then saves it to an image, thus making your image digitally signed. There are very few programs that know how to read this data from an image however, this way of storing data with an image...
- Software downloads 2008-10-10
- easyStock DataGenerator (exe)
- With easyStock DataGenerator the user can produce random generated stock price data. The data looks like real stock prices but is not. User may use this type of data to test trading systems against 100% unknown data. Up to 50000 data periods are possible (end of day = 200 years)....
- Software downloads 2008-10-10
- easyStock Game (exe)
- easyStockGame is a stock trading simulator. Use it to compete against real time data. Use it to check indicators and or you skills with indicators. Try various included end of day data to trade for swing and trend trading. The user can specify and save commission costs, slippage, profit stop,...
- Software downloads 2008-10-10
- EasyStock Info (exe)
- easyStockInfo from easyStockDater is a stock company information data base. The user can search stocks by entering the ticker or sliding a speed slider. The database contains following data fields: company name, ticker, sector, industry group, industry, sub industry, associated index, associated index ticker symbol, main exchange, country of origin,...
- Software downloads 2008-10-10
- easyStock Logger (exe)
- With easyStockLogger from easyStockDater the user can generate automated keyboard profiles, which can be used to automated many repetitive task, such as login to a Web based email account, login to bank accounts, trading accounts. The profiles are displayed in simple to select list. Once a profile is generated, the...
- Software downloads 2008-10-10
- SBSH SafeWallet - PC edition (zip)
- Store all your private and important information in one secure and organized application. SafeWallet is the most secure data storage application. Use SafeWallet to store credit cards information, online passwords, bank account info, and registration codes. This is the PC version of the application, including an application designed for Windows...
- Software downloads 2008-10-10
- Mac OS X Patch Day: 40 security flaws fixed
- Apple has shipped another whopper of a patch to cover a total of 40 documented vulnerabilities affecting the Mac OS X ecosystem. The Security Update 2008-007, available for Tiger and Leopard, covers a range of third-party components and Mac OS X flaws that could users at risk...
- Blog posts 2008-10-09
- Bureaucracy and open source: Do they mix?
- Another high-profile departure from Sun, this time MySQL's David Axmark is taking wing -- citing a dislike for working in a large organization: I have thought about my role at Sun and decided that I am better off in smaller organisations. I HATE all the rules that I need...
- Blog posts 2008-10-09
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- ZDNet News Videos
-
Tech news covering the latest in products, conferences and blog commentary, from ZDNet video.
- Watch the latest video >>
- Is it time for "Radical Change" in IT?
-
We need to get back to freethinking and innovation that is core to our roots. Companies like Intel were founded on thoughts like the famous quote from Robert Noyce - "Don't be encumbered by the past, go out and do something wonderful."
- Read the impassioned view on IT@Intel Blog >>
- Printers
- 'Green' Font Cuts Costs and Saves Trees (BNET)
- Three Ways to Save Paper (BNET)
- CNET Reviews printer buying guide (CNET)
- View all printers-tagged content on ZDNet
- Plan B from Brother
- It's the smarter way to work in color Our professional color ink-jet all-in-ones give you more choices, more features, and more value. Make the Smarter Choice. Learn More »
