Job Description:

·         User firm-wide standards and design review process to develop logical/physical data models for implementation on target platforms like Teradat, Exadata and/or Hadoop

·         Create target state solutions using Hadoop and other technologies within the Data Ecosystem

·         Working with business and other key stakeholders to facilitate JAD sessions to understand analytical requirements

·         Translate business requirements into target state conceptual models.

·         Collaborate with high-performing teams and individuals throughout the firm to accomplish common goals

·         Mentor junior modelers and perform peer reviews on project solution deliverables.

·         Identify opportunities for improving processes to bring efficiencies to the data modeling efforts.

·         Advanced knowledge of dat architecture, design and business processes ODS and Data Warehouse environments

·         Ability to work collaboratively in teams and develop meaningful relationships to achieve common goals

·         Hands on experience with modeling tools, such as ERWIN or another industry standard tool and knowledge of various features of modeling tool

·         Strong experience in platforms like Teradata and/or Oracle with VLDB

·         Strong SQL skills to pull data from Teradata/Oracle and perform usage analysis and/or data profiling

·         Experience leading JAD sessions and assisting junior team members with defining dat model development methodologies, principles, standards and governance considering People and Process optimization aspects.

·         Define/maintain application specific solution designs that align to target state dat ecosystem architectures, including viable alternatives with value propositions / trade-offs.

·         Exposure and understanding of Big Data technologies and architectures - Hadoop, Cassandra, Green Plum, etc