Description/Comment: Strategically designs and implements data warehouses, data marts, and data stores, while ensuring high levels of data availability. Responsible for defining data standards and models for warehouse architectures. Evaluates and selects all infrastructure components such as software, hardware, database management systems, and networking capabilities. Participates in the development and maintenance of governance policies and business processes as they pertain to the consumption of data by both business and IT users (and systems).
Major Responsibilities: Assesses and cultivates long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders. Mentors and/or provides leadership to other members of the data warehouse team. Coordinates and collaborates with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures. Plans and implements capacity and resource expansion to ensure data warehouse scalability. Designs and implements redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets. Evaluates, recommends, and selects data warehouse components, including hardware, database management systems, ETL (extract, transform, load) software, data mining tools, and meta data management tools.
Identifies inefficiencies and gaps in current data warehouses and leverages solutions. Identifies data discrepancies and data quality issues, and works to ensure data consistency and integrity. Diagnoses and resolves data warehouse access and performance issues. Conducts research and makes recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts. Create models for new data warehouse development and/or changes to existing data stores. Collaborates with end users to identify, create, and deliver reports according to requirements. Installs and configures relevant components to ensure data warehouse access. Develops, implements, and maintains change control and testing processes for modifications to data systems. Monitors system details within the data warehouse, including stored procedures and execution time, and implements efficiency improvements. Performs cost estimates for data migration between development, test, and production systems, and plans and coordinates these migrations.
Education Required:
Bachelor's degree in Computer Science or other related field.