Create and maintain Enterprise Analytics Platform (EAP) data models that integrate multiple source systems into a coherent, cohesive catalog of data. Some of those source systems include Oracle/Peoplesoft HR and Finance and Workday.
Design, develop and maintain conceptual, logical, and physical data models.
Work with analyst team to review business requirements and assess the data model needs to best fulfill those requirements. Advise on exercises like gap analyses or cost/benefit/risk analyses.
Ensure data models adhere to design and security standards.
Perform data profiling and analysis to ensure the quality of the data models.
Collaborate with functional and technical team to integrate model metadata with consumer tools (e.g. Collibra, Tableau).
Collaborate with development team to ensure models are clear and comprehensive. Provide developers with model and/or data definition language (DDL).
Support EAP customers/consumers with data model walkthroughs and help queue responses.