Description
Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Create and optimize data models for warehouse infrastructure and workflow. Integrate new systems with existing warehouse structure and refine system performance and functionality.
Interests
- Conventional
- Investigative
Work Values
- Achievement
- Working Conditions
- Independence
Work Styles
- Analytical Thinking
- Attention to Detail
- Achievement/Effort
- Initiative
- Cooperation
Tasks
- Develop and document database architectures.
- Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Design databases to support business applications, ensuring system scalability, security, performance, and reliability.
- Develop data models for applications, metadata tables, views or related database structures.
Work Activities
- Working with Computers
- Analyzing Data or Information
- Getting Information
- Processing Information
- Making Decisions and Solving Problems
Detailed Work Activities
- Working with Computers - Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- Analyzing Data or Information - Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
- Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources.
- Processing Information - Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.
- Updating and Using Relevant Knowledge - Keeping up-to-date technically and applying new knowledge to your job.
- Communicating with Supervisors, Peers, or Subordinates - Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Estimating the Quantifiable Characteristics of Products, Events, or Information - Estimating sizes, distances, and quantities; or determining time, costs, resources, or materials needed to perform a work activity.
- Evaluating Information to Determine Compliance with Standards - Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.
Technology Skills
- Data base management system software
- Data base user interface and query software
- Web platform development software
- Development environment software
- Metadata management software
Skills
- Complex Problem Solving
- Critical Thinking
- Judgment and Decision Making
- Reading Comprehension
- Systems Analysis
Knowledge
- Computers and Electronics
- Engineering and Technology
- Design
- Mathematics
- English Language
Most Common Education Level
The “Most Common Education Level” refers to the level of education held by the majority of workers in a given occupation. For example, if the highest percentage of workers in a role have an Associate’s Degree, that suggests this is the typical educational requirement. Knowing this helps you plan how many years of education you may need to pursue that career.
Certificates
Certificate name
Microsoft Certified: Dynamics 365: Finance and Operations Apps Solution Architect ExpertCertifying Organization
Microsoft Corporation
Type
Product/Equipment
Certificate name
SAS Certified Data Scientist Using SAS 9Certifying Organization
SAS Institute, Inc.
Type
Product/Equipment
Certificate name
SAS Certified Big Data Professional Using SAS 9Certifying Organization
SAS Institute, Inc.
Type
Product/Equipment
Certificate name
AWS Certified Solutions Architect - AssociateCertifying Organization
Amazon.com Web Services
Type
Product/Equipment
Certificate name
Cloud Technology Associate CertificationCertifying Organization
Cloud Credential Council
Type
Core
Income Percentile
The income percentiles show how earnings are distributed within a profession. The 10th percentile means that 10% of workers earned less than that amount. The median (50th percentile) indicates that half of workers earned more, and half earned less. The 90th percentile reflects what the top 10% of earners in the field make.
| Income Percentile | Income |
|---|---|
| Low (10%) | $NaN |
| Median (50%) | $NaN |
| High (90%) | $NaN |
Income by Experience
This table shows how income typically grows with experience—from entry level (0–2 years), to mid-level (3–7 years), to senior level (8+ years).
| Experience | Income |
|---|---|
| Entry Level | $50,000 |
| Mid Level | $100,000 |
| Senior Level | $150,000 |
Employability
There are currently 61,400 jobs in this career path. Over the next 10 years, that number is expected to increase to 68,000 positions, reflecting a projected growth of 11%.
The Projected Job Growth figure refers to the expected increase or decrease in employment within a specific career field over a certain period of time.
Projected Job Growth of 11%
The career information and data on this site incorporates information from O*NET Web Services by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA), with ONET® being a registered trademark of USDOL/ETA. Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA; CareerOneStop, sponsored by the U.S. Department of Labor, Employment and Training Administration (DOLETA) and the Minnesota Department of Employment and Economic Development (DEED); and the U.S. Bureau of Labor Statistics (BLS).
Career Resources
Search All Careers
Compare Careers
Income Outlook
Career Pathways
Career Clusters
Job Suite Home
CVs
Resumes
Cover Letters
Templates
Job Resources
Blog Articles
Podcast