Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  

Data Modeler

Job Category:
Technology Provider
Career Level:
Student (Undergraduate)
Job Type:
Full Time/Permanent
Company Name:

Job description

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.




  • 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


Preferred Qualifications


Experience with enterprise-class data modeling tools is highly preferred


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.




Amazon Corporate LLC


Recruiting Team

Seniority Level

Not Applicable


  • Computer Software
  • Information Technology and Services
  • Internet

Employment Type


Job Functions

  • Business Development
  • Sales