Develops SQL Business Intelligence (BI) reports, models, and applications as illustrated by the following:
Designs, builds, and populates data objects such as SSAS cubes, relational dimensional databases, and SSAS data mining models.
Designs and builds BI user interfaces such as dashboards and reports using SAP business objects , Lumira, Tableau & other BI Tools.
Designs and builds data models to support self-service BI.
Knowledge of data models , data marts & data warehouses.
Supports Data Warehouse enhancements and operations including table, view, stored procedure, and other changes.
Performs query tuning and optimization.
Develops, monitors, and maintains ETL (Extract, Transform, Load) processes that extract, transform, and load data into the Data Warehouse and BI data objects.
Meets with Lines of Business and Business Systems Analysts to define reporting requirements and goals and to identify the data needed for meeting business requirements.
Maintains data dictionary and related meta-data stores.
Follows change and version control in moving code from development to test/QA and to production environments.
DanaRemoters