Amazon

Returning Candidate?

GHRS, Data Modeler

GHRS, Data Modeler

Job ID 
526116
Location 
US-WA-Seattle
Posted Date 
4/26/2017
Company 
Amazon Corporate LLC
Position Category 
Human Resources
Recruiting Team 
..

Job Description

Within this role, you will build a strong relationship with client business teams, gaining a deep understanding of their business needs and the data necessary to support their processes. Leveraging your deep expertise in logical and conceptual 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 data sources.

As a Data Modeler you will be responsible for creating and modifying conceptual, logical and physical data models to support a new SaaS Solution (Salesforce), PeopleSoft and Workday . You will be required to work with developers and business analysts, data engineer to model the data (using data modeling techniques i.e snowflake, Star, Dimensional data modeling (Kimball methodology), conform to naming standards, maintain the data models in Erwin, Salesforce generating DDL and managing DDL across various environments (dev, test, uat, production). You will also have data management experience to successfully create metadata, business definitions, data related policies and data profiling using SQL.

Responsibilities:
· Work with the Data Solution Manager to determine high level data strategy for PeopleSoft Data
· Logical data modeling in Salesforce tool for creating Data Objects
· Work closely with business and IT subject matter experts 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 ETL design and acts as the subject matter expert on source and target data structures.
· Occasionally participate in SQL query tuning on Oracle (SQL proficiency needed)
· Produce data models and related documentation that can be understood and reviewed by a business audience
· Reverse engineer data from various systems
· Conduct other data analysis tasks including source system analysis and data profiling
· Identify opportunities to unify 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
· Revise ETL mapping specifications and/or stored procedures as required.
· Development: Develop/modify/test data to populate new tables and columns until the ETL team can develop Informatica mappings to replace the stored procedures.



Basic Qualifications


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
Exceptional critical thinking, communication, problem solving and cross-group collaboration skills
Understanding of Data Lake concepts
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 is highly preferred

Preferred Qualifications


Bachelor’s degree in Engineering, Computer Science or related sciences required

Amazon is an Equal Opportunity-Affirmative Action Employer - Female/Minority/Disability/Veteran/Gender Identity/Sexual Orientation.