Demonstrable experience in developing, validating, publishing, maintaining logical and physical data models.
Demonstrable experience using data modeling tools - e.g., ErWin
Evaluate existing data models and physical databases for variances and discrepancies
Experience with managing meta data for data models
Collaborate with the BI and Analytics teams on creating the optimized, reusable semantic model, complete with metadata and lineage information
Demonstrable experience in developing, publishing, and maintaining all documentation for data models
Develop best practices for standard naming conventions to ensure consistency across data models.
Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
Streamline data administration procedures through developing detail data attribute abbreviations guide and managing data models
Develop data architecture prototypes and data models including ETL staging models, audit control models and traditional data warehouse dimension/fact models.
Document all source-to-target data mapping for the EDW.
Engage the business users to assess their information needs
Analyze the business rules and come up with an audit control and exception handling mechanism
Education and Experience
Bachelor’s degree in Computer Science, Information Systems or related field; Masters’ degree preferred.
Minimum of ten (10) years’ experience in the fields of Experience with Data Governance/management/standardization tools Data Modeling
Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models
Strong analytical, data profiling and problem-solving skills
Perform reverse engineering of physical data models from databases and SQL scripts
Validate business use cases for accuracy and completeness of proposed data models
Advanced SQL skills
5+ years Data Lake and Data Warehousing modeling experience
3+ years modeling experience on Hive, HBASE,Snowflake
2+ years experience in Hadoop data analysis
2+ years experience in supporting AI/ML inititaives
Good understanding of sql/No sql databases concepts