Enterprise Architect II
Sr. Data Analyst Role
Data mapping, one of the most critical aspects of data integration, is the process of conforming data elements between one or (usually) more sources to a target. The Sr. Data Analyst will provide data mapping details on the all attributes required including the vital information on how the data from the source system will be transformed and stored in the target source. They are responsible to provides all the business rules, transformation logic, derived column formulae etc.
Determines the target subject areas: If applicable, review the target data model to group the target tables into logical subject areas.
Identifies the target data element or elements by subject area: For each of the subject areas (such as customer or product), determine what data elements fit within that grouping.
Review’s all the source systems for candidate data elements: Review the other sources for potential one-to-many source data elements for the target data element.
Maps the candidate data element or elements to the target data element: Map the identified source data element to target data element.
Review’s each source and target data element for one-to-many or many-to-one requirements: Perform both a vertical and horizontal review of the sources against the target data element.
Maps technical mapping requirements to each target’s subject area data element: Build in any mapping business rules, which may be as simple as padding or trimming the field, to aggregating and/or calculating amounts.
Reconcile definitional (data governance) issues between source systems: Resolve any data element (attribute)–level definitional differences between the different sources and the target data element
Serves as a liaison between the end users (Strategic programs, projects, data office, etc.) and data factory team
(ETL and Data Architecture)
• Works with the project Business Analysts and LOB determine requirements for data.
• Identify and assess potential data sources.
• Recommends appropriate scope of requirements.
• Defines business rules to map data from the Data Supply Chain’s Sourcing Layer to Organize or Consume Layer
• Works with ETL and/or Data architects to translate requirements into technical data specifications
• Deliver on expectations while also managing/meeting the Enterprise Data Strategy/Vision.
• Partnering with the Line of Business and application SME’s performs business rules and data mapping
• Need to compare prototyped results to production to expected results
• 7+ years mapping data using data profiling\\discovery tools.
• Strong interpersonal and communications skills.
• Ability to translate business requirements into technical data requirements.
• Knowledge of KeyBank data and its uses in the line of business application areas.
• Knowledge of key data processes in the Data Supply Chain.
• Strong SQL Skills and knowledge of data warehouse principles including an understanding of Entity-Relationship
• SAS EG experience to facilitate testing and comparisons of mapping rules to expected values.
• Data requirements – Standard Interface documentation
• Working with the project BA’s to put together the Master Attributes List (SI06)
• Master Attributes List to Source Specific Mapping (SI06-SSM)
• Source Specific Detail Mapping – Sourcing Layer to Integrated Layer Mapping (SI06-DMD)
• PTP – Sourcing Layer to Point to Point Mapping Doc (SI06-Extract)
• Business/Data priorities
• Prototype Data Mapping Rules
KeyCorp's roots trace back 190 years to Albany, New York. Headquartered in Cleveland, Ohio, Key is one of the nation's largest bank-based financial services companies, with assets of approximately $134.5 billion at March 31, 2017. Key provides deposit, lending, cash management, insurance, and investment services to individuals and businesses in 15 states under the name KeyBank National Association through a network of more than 1,200 branches and more than 1,500 ATMs. Key also provides a broad range of sophisticated corporate and investment banking products, such as merger and acquisition advice, public and private debt and equity, syndications, and derivatives to middle market companies in selected industries throughout the United States under the KeyBanc Capital Markets trade name. KeyBank is Member FDIC.
ABOUT THE BUSINESS:
Key Technology and Operations (KTO) is Key Bank’s shared services organization for technology, operational, and servicing functions supporting business partners and clients across all lines of business. Within the overall organization, KTO provides efficient, reliable and secure technology; creates an effective variable cost technology delivery model that maximizes the return on IT spend; orchestrates the efficient use of corporate information and technology assets; and supports innovation that creates competitive distinction. KTO is effective and efficient in payment and deposit servicing, loan servicing, exception and dispute processing, investment and support services, sourcing and procurement, as well as enterprise-wide fraud prevention, investigations and operational support to human resources and the Bank’s BSA/AML program.
KeyCorp is an Equal Opportunity and Affirmative Action Employer committed to engaging a diverse workforce and sustaining an inclusive culture. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.