Business Intelligence Data Modeler - RibbitZ

Position Overview

We are seeking an experienced Business Intelligence Data Modeler to document key business areas and concepts through reverse engineering, database analysis, metadata development, and data-model creation.

Key Responsibilities

• Develop conceptual, logical, and physical data models for the organization’s data architecture.
• Ensure all relevant aspects of the data model, including granularity, relationships, standards, and business rules, are properly considered.
• Analyze logical and physical database models and ensure compliance with established architecture and modeling standards.
• Reverse-engineer existing database structures and document key business areas and concepts.
• Develop and maintain metadata definitions and documentation for production application databases.
• Translate technical data-modeling concepts, including facts, dimensions, normalization, and snowflake schemas, into language that nontechnical stakeholders can understand.
• Collaborate effectively with both technical and nontechnical stakeholders.
• Recommend data-maintenance strategies for slowly changing dimensions, data archival, data roll-off, and retention planning.
• Design models optimized for both data storage and end-user query or reporting requirements.
• Perform relational database analysis and testing.
• Investigate data-load failures, data-retrieval issues, and database inconsistencies.
• Assess and profile data quality within the database architecture.
• Create and review SQL and PL/SQL scripts.
• Create and maintain database objects.

Required Qualifications

• 5+ years of conceptual, logical, and physical data-modeling experience.
• 5+ years of both application and data warehouse database-modeling experience.
• 5+ years of experience creating database objects.
• 5+ years of database-design experience.
• 5+ years of experience using ERwin Data Modeler.
• 5+ years of data-analysis experience.
• 5+ years of experience creating and reviewing SQL scripts.
• 6+ years of advanced Oracle PL/SQL experience.
• 5+ years of experience with metadata tools.
• 5+ years of experience with Oracle 11g, DB2, and/or SQL Server.
• 4+ years of experience working with Oracle data dictionary views.
• 5+ years of metadata-documentation experience.
• 5+ years of data-quality assessment and profiling experience.
• Strong experience reverse-engineering database structures and developing metadata.
• Excellent organizational, analytical, communication, and documentation skills.
• Ability to work independently with guidance from senior technical leadership.

Preferred Qualification

• Experience working with human-services systems, programs, or data.