Database Warehouse Analyst designs and supports data warehouse systems, maintenance processes, and projects. Designs and writes code for ETL data solutions. Being a Database Warehouse Analyst plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Additionally, Database Warehouse Analyst analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units. Requires a bachelor's degree. Typically reports to a manager. The Database Warehouse Analyst work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Warehouse Analyst typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)
Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily at the front end of the lifecycle requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.
Clear All
0 Database Warehouse Analyst jobs found in Baltimore, MD area