Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data like linked server issues.
The DA will design an architecture that supports reuse, improved performance, data governance/standards, and removes latency. * The DA will implement the design and support the Tableau teams with data integration and performance.
Ensures the integrity of project data, including data extraction, storage, manipulation, processing and analysis; consult with the external clients and internal staff to determine data management needs and objectives.
Analyze input/output requirements, information flow, technical requirements, resources needed and select between alternative systems solutions in order to make a proposal for assigned Development Projects.
In this role, you will be responsible for designing and maintaining an enterprise-class data model. As part of this effort, they also reverse engineer complex new datasets, providing documentation to developers instructing how to map these new datasets to the existing model.
Analyze database system requirements and ensure systems are working at optimal levels and are effectively integrated with other applications. Plan and design the development data storage solutions (including conceptual, logical, and physical database models).
Create and document the Big Data Architecture, design and all pertinent configuration, execution instructions, and artifacts to establish and update the Big Data Reservoir to provide data-driven organizational capabilities.