Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Median Annual Income

$103,044

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Analyze science, engineering, business, and other data processing problems to develop and implement solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions, improve existing computer systems, and review computer system capabilities, workflow, and schedule limitations. May analyze or recommend commercially available software.

Median Annual Income

$107,664

Projected Job Growth

+8 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. Identify, investigate, and resolve database performance issues, database capacity, and database scalability. May plan, coordinate, and implement security measures to safeguard computer databases.

Median Annual Income

$133,872

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

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.

Median Annual Income

$101,644

Projected Job Growth

-10 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Create, modify, and test the code and scripts that allow computer applications to run. Work from specifications drawn up by software and web developers or other individuals. May develop and write computer programs to store, locate, and retrieve specific documents, data, and information.

Median Annual Income

$124,170

Projected Job Growth

+18 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Research, design, and develop computer and network software or specialized utility programs. Analyze user needs and develop software solutions, applying principles and techniques of computer science, engineering, and mathematical analysis. Update software or enhance existing software capabilities. May work with computer hardware engineers to integrate hardware and software systems, and develop specifications and performance requirements. May maintain databases within an application area, working individually or coordinating database development as part of a team.

Median Annual Income

$105,976

Projected Job Growth

+12 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Develop and execute software tests to identify software problems and their causes. Test system modifications to prepare for implementation. Document software and application defects using a bug tracking system and report defects to software or web developers. Create and maintain databases of known defects. May participate in software design reviews to provide input on functional requirements, operational characteristics, product designs, and schedules.

Median Annual Income

$112,753

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Maintain and support distributed and decentralized blockchain-based networks or block-chain applications such as cryptocurrency exchange, payment processing, document sharing, and digital voting. Design and deploy secure block-chain design patterns and solutions over geographically distributed networks using advanced technologies. May assist with infrastructure setup and testing for application transparency and security.

Median Annual Income

$112,753

Projected Job Growth

+11 %

Career Cluster(s)

Public Service & Safety

Most Common Education Level

Bachelor's degree

Design and develop solutions to complex applications problems, system administration issues, or network concerns. Perform systems management and integration functions.

Median Annual Income

$105,473

Projected Job Growth

+36 %

Career Cluster(s)

Marketing & Sales

Most Common Education Level

Bachelor's degree

Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software. Apply data mining, data modeling, natural language processing, and machine learning to extract and analyze information from large structured and unstructured datasets. Visualize, interpret, and report data findings. May create dynamic data reports.

Median Annual Income

$105,473

Projected Job Growth

+36 %

Career Cluster(s)

Marketing & Sales

Most Common Education Level

Bachelor's degree

Produce financial and market intelligence by querying data repositories and generating periodic reports. Devise methods for identifying data patterns and trends in available information sources.

Median Annual Income

$

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

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.

Median Annual Income

$

Projected Job Growth

+11 %

Career Cluster(s)

Digital Technology

Most Common Education Level

Bachelor's degree

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Median Annual Income

$

Projected Job Growth

+36 %

Career Cluster(s)

Marketing & Sales

Most Common Education Level

Bachelor's degree

Produce financial and market intelligence by querying data repositories and generating periodic reports. Devise methods for identifying data patterns and trends in available information sources.