Creates and maintains data dictionary and data model for the Data Warehouse.Designs, develops, and supports ETL mappings and workflows for loading data into the Data Warehouse.Performs data quality and validation checks on a daily basis to ensure the Data Warehouse is being updated properly.Identifies, reports and corrects any data quality issues found in transactional databases or the Data Warehouse.Tunes databases, ETL workflows and queries using proven database optimization techniques.Supports, monitors, tests and troubleshoots hardware and software pertaining to the Data Warehouse and Business Intelligence applications.Collaborates with stakeholders on new data requirements.Researches and understands new sources of data and determines how to integrate in the Data Warehouse.Works with Application Developers and Business Analysts to assist with data requests, troubleshoot queries and optimize their processes.Enforces company information security initiatives. Reports unauthorized data usage and security problems.Ensures that access to databases or its components is granted only to authorized personnel and that access logs are maintained and reviewed.Performs all other duties as assigned.Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.