Data Modeling experience is mandatory. Pure BA experience will not suffice
Experience in Securities Processing, Clearing and Settlement space desired
Modeling effort will focus on leveraging your deep expertise in conceptual and logical data modeling, data management and meta-data management, you will work with business teams, end-users, and application owners to define data relationships across multiple legacy data sources
Experience with enterprise-class data modeling tools is a MUST
Work with the Enterprise Data and Analytics Services (EDAS) team to determine high level data strategy for the Securities Processing data
Reverse engineering and consolidate legacy databases using DDL's from multiple legacy systems
Work closely with Business and IT SME's and map their requirements into Conceptual and Logical Data Models
Manage the Data Model repository maintenance and for the development and administration of the appropriate roles.
Create logical and physical data models for operational applications
Provide data governance to ensure corporate data standards are met.
Participate in data architecture design and acts as the subject matter expert on source and target data structures.
Produce data models and related documentation that can be understood and reviewed by a business audience
Conduct data analysis tasks including source system analysis and data profiling
Identify opportunities to unify/rationalize disparate but common data concepts across multiple enterprise systems
Work with appropriate Business and IT leads to incorporate data modeling and data quality best practices into IT solutions roadmaps
Communicate and build consensus with other groups regarding data definitions, data solutions, and available implementation options
Participate in query performance tuning (SQL proficiency required)
8+ years of large enterprise project experience that must include conceptual and logical data modeling
Significant experience developing and maintaining complex logical data models in both business models as well as meta-data models for dynamic business rules
Extensive experience in developing data definitions, meta-data, taxonomy and data models to support requirements definitions for application development across a wide variety of platforms and data intensive solutions
Ability to take iterative (agile) approach to modeling and determine points of the model needed for flex (abstraction) versus explicit fixed modeling
Strong understanding of process models
Experience with enterprise-class data modeling tools like PowerDesigner, Erwin, ER/Studio etc. is a MUST
Exceptional critical thinking, communication, problem solving and cross-group collaboration skills
Strong business acumen and proven track record for providing innovative solutions resulting in increased business performance
Good communication skills and the ability to communicate appropriately at all levels of the organization
Broad, enterprise-wide view and understanding of data strategy, processes and capabilities, enabling technologies, and governance
Understanding of the value of data-centric approach to capability development
Experience working within cross-functional project team to understand business requirements and deliver process artifacts
Ability to assimilate and correlate disconnected data and articulate their collective relevance lineage to the organization and to high-priority business issues
Understanding of legacy and relational data modeling concepts/techniques.
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.