Data Modeling Analyst

Description

Job Description
Responsibilities
Analyzes and translates business, data, functional, and user requirements and/or business rules into analytic and reporting requirements, data models and metadata deliverables by leading and guiding discussions internally with the project team and externally with business and technology partners
Plans, develops and leads information gathering sessions
Constructs and executes complex SQL queries and review data profiling results to discover semantics, patterns and value domains of data under analysis
Performs complex data analysis utilizing multiple techniques to determine, document and communicate existing and potential future data relationships, profiles and quality levels; uncover anomalies and variances in data content from expected results
Updates and maintains all logical (conceptual, relational, subjectlevel and dimensional) and physical data models and other design deliverables at multiple levels of detail and functionality
Plans, develops and facilitates inspection sessions to validate that modeled data and related metadata deliverables match and satisfy business data requirements
Conducts reviews of physical data model and related technical detail with database administrators and technical developers as part of development life cycle
Leads the initiation of new products through estimation and planning
Creates complex technical requirements through analyzing business and functional requirements