Overview:
Key Duties/Responsibilities:Performs business and systems analysis and documentation- Develops conceptual and dimensional data models for the enterprise data warehouse- Performs data modeling in relational and dimensional models- Develops physical data model and/or works with architect to develop physical data model- Develops Data Facts and Dimensions in the EDW- Provides documentation to support the Kimball Dimensional Data Modeling Framework- Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data- Documents data flow diagrams in existing and future reports to use as input in report design and optimization- Develops Requirements Specifications- Develops Design Specifications- Performs data analysis/predictive data modeling- Mentors and educates team members on best practices and industry standards
Mandatory:- Experience as a data analyst or in other quantitative analysis or related disciplines, such as researcher or data engineer supportive of key duties/responsibilities identified above.- Relevant experience in relational data modeling and dimensional data modeling, statistical analysis, and machine learning supportive of key duties/responsibilities identified above.- Excellent communication and collaboration skills to work effectively with stakeholders and team members.Desired:- Expert level Kimball Dimensional Data Modeling experience- Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.