Dimensional Data Modeler
PMCS Services, Inc. ·Austin, TXClosing in
Term:Part timeWork:Remote
Type:EmployeeContract
We are looking for a Part-Time/contract employee for a Dimensional Data Modeler.
- Determines database requirements by analyzing business operations, applications, and programming; receiving business objectives; and evaluating current systems.
- Obtains data model requirements, develops, and implements data models for new projects, and maintains existing data models and data architectures.
- Develops data structures for data warehouses and data marts projects and initiatives; and supports data analytics and business intelligence systems.
- Builds conceptual, logical, and physical dimensional data models following the Ralph Kimball approach to data warehouse development.
- Works with Business and System Analytics to investigate source system.
- Communicates physical database designs and dba and explains features that may affect the physical data model.
- Follows processes for capturing and maintaining metadata from all data warehousing components.
- Implements corresponding database changes to support new and modified applications, and ensures new designs conform to data standards and guidelines; are consistent, appropriate for their intended use, and perform as required; and secure from unauthorized access or update.
- Conforms to guidelines on creating data models and various standards relating to governed data. Reviews measures to chart progress related to the completeness and quality of metadata for enterprise information; to support the reduction of data redundancy and fragmentation and elimination of unnecessary movement of data, and to improve data quality.
- Identifies appropriate data sourcing and extraction process and identifies and nominates sources as systems of record for data usage in various applications.
- Performs root cause analyses related to information issues and non-conformance to published data standards based on a review of technical metadata of various source systems.
If you are interested in this opportunity, please apply asap.