SysMind Tech
Akash_Dummy_Data Analyst/Data Modeler
SysMind Tech, Sacramento, California, United States, 95828
JOB DESCRIPTION:
MANDATORY QUALIFICATIONS:
1. Staff resource must have a minimum of 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
2. Staff resource must have a minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling, and statistical analysis, supportive of key duties/responsibilities.
3. At least one staff resource must have a minimum of three (3) years of verifiable experience specific to business analysis.
DESIRED QUALIFICATIONS:• (5) years of Kimball Dimensional Data Modeling experience. (This DQ will be verified through an interview)• (5) years of experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle. (This DQ will be verified through an interview)
JOB RESPONSIBILITIES:
1. Performs business and systems analysis and documentation
2. Develops conceptual and dimensional data models for the enterprise data warehouse
3. Performs data modeling in relational and dimensional models
4. Develops physical data model and/or works with architect to develop physical data model
5. Develops Data Facts and Dimensions in the EDW
6. Provides documentation to support the Kimball Dimensional Data Modeling Framework
7. Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
8. Documents data flow diagrams in existing and future reports to use as input in report design and optimization
9. Develops Requirements Specifications
10. Develops Design Specifications
11. Performs data analysis/predictive data modeling
12. Mentors and educates team members on best practices and industry standards
MANDATORY QUALIFICATIONS:
1. Staff resource must have a minimum of 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
2. Staff resource must have a minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling, and statistical analysis, supportive of key duties/responsibilities.
3. At least one staff resource must have a minimum of three (3) years of verifiable experience specific to business analysis.
DESIRED QUALIFICATIONS:• (5) years of Kimball Dimensional Data Modeling experience. (This DQ will be verified through an interview)• (5) years of experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle. (This DQ will be verified through an interview)
JOB RESPONSIBILITIES:
1. Performs business and systems analysis and documentation
2. Develops conceptual and dimensional data models for the enterprise data warehouse
3. Performs data modeling in relational and dimensional models
4. Develops physical data model and/or works with architect to develop physical data model
5. Develops Data Facts and Dimensions in the EDW
6. Provides documentation to support the Kimball Dimensional Data Modeling Framework
7. Visualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge data
8. Documents data flow diagrams in existing and future reports to use as input in report design and optimization
9. Develops Requirements Specifications
10. Develops Design Specifications
11. Performs data analysis/predictive data modeling
12. Mentors and educates team members on best practices and industry standards