Live Chat
Contact

Welcome,
New User

Data Warehousing Specialists

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

View All

    Work Activities

    Work Activities

    • 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.
    • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
    • Design and implement warehouse database structures.
    • Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
    • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
    • Provide or coordinate troubleshooting support for data warehouses.
    • Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
    • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
    • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
    • Create or implement metadata processes and frameworks.
    • Review designs, codes, test plans, or documentation to ensure quality.
    • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
    • Select methods, techniques, or criteria for data warehousing evaluative procedures.
    • Prepare functional or technical documentation for data warehouses.
    • Test software systems or applications for software enhancements or new products.

    Skills

    • Critical Thinking

      Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

    • Reading Comprehension

      Understanding written sentences and paragraphs in work related documents.

    • Programming

      Writing computer programs for various purposes.

    WorkKeys®

    Applied Math
    N/A
    Workplace Documents
    N/A
    Graphic Literacy
    N/A

    Abilities

    • Information Ordering

      The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).

    • Written Comprehension

      The ability to read and understand information and ideas presented in writing.

    • Deductive Reasoning

      The ability to apply general rules to specific problems to produce answers that make sense.

    Knowledge

    • Computers and Electronics

      Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.

    • Mathematics

      Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.

    • English Language

      Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.

    Career Video

    Video not available
    Additional videos and more information available on CareerOneStop

    Pay

    • Ohio Annual Salary 92060/yr
    • Typical Salary
    • Ohio Hourly Wage 44.26/hr
    • Typical Hourly Wage

    Ohio Employment Trends

    • Currently Employed Not Available
    • Yearly Projected Openings Not Available

    Typical Education

    Personality

    Investigative: 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

    Tools

    • Notebook computers
    • Mainframe computers
    • High end computer servers
    • Desktop computers
    • Computer servers

    Technology

    • Operating system software
    • Metadata management software
    • Development environment software
    • Data base user interface and query software
    • Data base management system software

    Tags

    • Bright Outlook occupations will grow rapidly in the next few years, have a large number of openings, or are new and emerging careers.

    Budget Calculator

    Answer a few questions to determine your target salary. Use this target salary to help choose the right occupation for you.

    Lifestyle Calculator

    Answer a few questions to determine your target salary. Use this target salary to help choose the right occupation for you.

    Workforce Supply Tool

    Workforce Supply Tool

    The Workforce Supply Tool provides statistics for the occupations in highest demand throughout Ohio.

    You can view statewide statistics as well as more region specific information.

    Visit Site
    Powered By: