We are seeking a Data Modeler for a 3 year Hybrid assignment with our Sacramento, California based client. This position requires that you be able to work on-site in Sacramento, California.
Key Duties/Responsibilities:
Performs business and systems analysis and documentationDevelops conceptual and dimensional data models for the enterprise data warehousePerforms data modeling in relational and dimensional modelsDevelops physical data model and/or works with architect to develop physical data modelDevelops Data Facts and Dimensions in the EDWProvides documentation to support the Kimball Dimensional Data Modeling FrameworkVisualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge dataDocuments data flow diagrams in existing and future reports to use as input in report design and optimizationDevelops Requirements SpecificationsDevelops Design SpecificationsPerforms data analysis/predictive data modelingMentors and educates team members on best practices and industry standards
Qualifications:
Required:
Five (5) years of 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.Minimum of five (5) years of 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.Preferred:
Expert level Kimball Dimensional Data Modeling experienceExpert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.