Every organization, public or private, needs secure data storage. Data warehousing specialists and document management specialists configure data storage systems to keep data both accessible and safe. Data warehousing specialists start by gaining an understanding of what data their customers need to store, and how they want to access it. Then they design data warehouses to securely store their customer’s data. Their systems often need to allow batch loading of large amounts of data, such as a company’s payroll, sales, or purchasing records. These specialists develop detailed documentation, such as a description of data’s path from origin, formatting and structure specifications, where it’s stored, and who has access to it. They create procedures and rules so that different business groups can extract needed data. Document management specialists oversee an organization’s systems for capturing, storing, and destroying electronic records and documents. They make sure that documents can be accessed only by authorized individuals, and that master documents remain secure. Both roles test many functions of their systems regularly to ensure they operate accurately, and meet relevant industry regulations. Skills in data analysis and programming are needed to modify programs, and troubleshoot support for users. People in these positions may work more than 40 hours per week. Most positions require a bachelor’s degree, but some require only technical training or an associate’s degree.
What they do:
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
On the job, you would:
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Verify the structure, accuracy, or quality of warehouse data.
Map data between source systems, data warehouses, and data marts.
Engineering and Technology
computers and electronics
design
Math and Science
arithmetic, algebra, geometry, calculus, or statistics
Arts and Humanities
English language
Basic Skills
reading work related information
thinking about the pros and cons of different ways to solve a problem
Problem Solving
noticing a problem and figuring out the best way to solve it
People and Technology Systems
figuring out how a system should work and how changes in the future will affect it
thinking about the pros and cons of different options and picking the best one
Verbal
read and understand what is written
listen and understand what people say
Ideas and Logic
order or arrange things
make general rules or come up with answers from lots of detailed information
Math
choose the right type of math to solve a problem
add, subtract, multiply, or divide
People interested in this work like activities that include ideas, thinking, and figuring things out.
They do well at jobs that need:
Analytical Thinking
Attention to Detail
Initiative
Persistence
Cooperation
Dependability
You might use software like this on the job:
Data base management system software
Amazon DynamoDB
Oracle PL/SQL
Presentation software
Microsoft PowerPoint
Metadata management software
CA Erwin Data Modeler
Informatica software
bachelor's degree usually needed
Get started on your career:
New job opportunities are very likely in the future.