Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable conceptual and subsequently, logical data constructs that will be captured in data models
Creating data models that conform to existing standards and conventions
Developing mapping documents that demonstrate data lineage
Revising data dictionaries, governance practices, and standards
Profiling existing data by writing SQL scripts in the source systems
Converting Logical Data Models (LDMs) into working Physical Data Models (PDMs), document and maintain lineage between the two artifacts
Interact with different stakeholders and gather information that would help solve the challenges at hand and help achieve the long-term goals of the project
Minimum Qualifications:
10+ years of experience in data architecture
7 or more years of data modeling experience with demonstrated expertise in the analysis and design of large-sized systems
Thorough knowledge of ERwin Data Modeler (V8 or higher) or a comparable CASE tool
Knowledge of Agile development methodology and concepts
Understanding of information systems and data life-cycle management best practices and methodologies, formal systems engineering life cycle (SELC), and systems development life cycle (SDLC).
Experience with Service Oriented Architecture (SOA), web services, enterprise data management, information security, applications development, and cloud-based architectures
Experience with enterprise data management technologies, including database platforms, ETL tools, and proficiency in SQL
Additional Skills:
Experience working as a member of a distributed data architecture team
Hands-on SQL experience
Experience with three or more of the following DBMS technologies: Oracle, Microsoft SQL Server, Greenplum, Sybase and UDB
Good communication skills and customer relationship skills
Experience in translating business requirements documents into design artifacts, employing the core design principles
Performs a key leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, and statistical methods
Thorough knowledge of Microsoft Office suite of products
Desired Skills:
Experience with ERwin Data Intelligence (DI)
Experience with any ETL tool (Informatica, DataStage, etc.)
Experience with any Business Intelligence (BI) tool (i.e. Cognos, MicroStrategy, Business Objects, etc.)
Experience with Snowflake
Good understanding of the concepts in the financial industry, especially in the area of trade, clearing and settlement
Experience with any data profiling/data discovery tool
Working knowledge of data analytics and data mining techniques
Education/Certification:
Bachelor’s degree in an appropriate area of specialization (computer science or information systems) or advanced education (Master’s degree)
Understanding of two or more industry standard frameworks, including DAMA, DMBOK, or Zachman Framework
Data management and data architecture related certifications (i.e. TOGAF)