Work through early stages of software lifecycle to profile data and to create conceptual, logical & physical data model designs with appropriate structure and relationships for optimal performance.
Support multiple Business Intelligence/Data Warehouse projects, including build-out of Dimensional Models (Star/Snowflake Schema).
Responsible for performing data analysis activities to capture data requirements clearly, completely, and correctly while, at the same time, representing them in a formal and visual way through data models.
Interface with a wide range of customers, ranging from Senior Level Executives to ETL/Reporting Developers.
Ensure the long-term reliability, scalability, and maintainability of systems
Design stable, reliable and effective databases
Optimize and maintain legacy systems
Modify databases according to requests and perform tests
Solve database usage issues and malfunctions
Liaise with developers to improve applications and establish best practices
Gather user requirements and identify new features
Develop technical and training manuals
Provide data management support to users
Ensure all database programs meet company and performance requirements
Research and suggest new database products, services, and protocols
