Occupational Employment Statistics
15-1243 Database Architects
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. Excludes “Database Administrators†(15-1242).
|
Minnesota
| 790 | 61 | $63.58/hr | $42.89/hr | $52.40/hr | $64.56/hr | $76.36/hr | $84.71/hr |
| Manufacturing | 40 | $62.61/hr |
| Trade, Transportation and Utilities | 140 | $79.02/hr |
| Financial Activities | 350 | $64.56/hr |
| Professional and Business Services | 200 | $64.59/hr |
| Education and Health Services | 40 | $52.31/hr |
| Leisure and Hospitality | N/A | N/A |
| Other Services | N/A | N/A |
| Public Administration | N/A | N/A |
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Develop or maintain archived procedures, procedural codes, or queries for applications.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Map data between source systems, data warehouses, and data marts.
- Implement business rules via stored procedures, middleware, or other technologies.
- Verify the structure, accuracy, or quality of warehouse data.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Review designs, codes, test plans, or documentation to ensure quality.
- Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
- Identify and correct deviations from database development standards.