Della Infotech
Data Modeler / Data Analyst Job at Della Infotech in Sacramento
Della Infotech, Sacramento, CA, United States, 95828
Position: Data Modeler / Data Analyst
Location: Sacramento, CA (Candidate should stay close to customer location)
Rate: Open
Duration : 3 yrs.
Local candidates are preferred.
This candidate should have good communication skill to interact with customer and deliver within SLA.
Data Analyst/Data Modeler:
Key Duties/Responsibilities:
• Performs business and systems analysis and documentation.
• Develops conceptual and dimensional data models for the enterprise data warehouse.
• Performs data modelling 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 Modelling 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 modelling.
• Mentors and educates team members on best practices and industry standards.
Qualifications:
Mandatory:
Location: Sacramento, CA (Candidate should stay close to customer location)
Rate: Open
Duration : 3 yrs.
Local candidates are preferred.
This candidate should have good communication skill to interact with customer and deliver within SLA.
Data Analyst/Data Modeler:
Key Duties/Responsibilities:
• Performs business and systems analysis and documentation.
• Develops conceptual and dimensional data models for the enterprise data warehouse.
• Performs data modelling 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 Modelling 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 modelling.
• Mentors and educates team members on best practices and industry standards.
Qualifications:
Mandatory:
- 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 identified above.
- Minimum of five (5) years of relevant experience in relational data modelling and dimensional data modelling, 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.
- Expert level Kimball Dimensional Data Modelling experience
- Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.