Data Warehousing Specialists

What does a professional in this career do?

In this job you will...

• 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.
• Provide or coordinate troubleshooting support for data warehouses.
• Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
• 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.
• Implement business rules via stored procedures, middleware, or other technologies.
• Prepare functional or technical documentation for data warehouses.
• Test software systems or applications for software enhancements or new products.