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.