Data Modeler

  • 37702
  • Life - Data Science
  • |
  • Massachusetts, United States
  • |
  • Jul 9, 2020
  • Perform as a technical data steward - understanding tables, data use, data replication, data connection, data lineage - and take accountability for data hygiene.
  • Review existing data model and recommend changes to optimize data requirements.
  • Analyze source system data and look for data redundancy and duplication.
  • Work with Application Architects to review exiting data models and suggest action to reduce input data for storage optimization.
  • Work with the development team to implement data strategies, build data flows, and develop conceptual data models.
  • Create logical and physical data models using best practices.
  • Delivers and provides feedback for data modeling policies, procedure, processes and standards.
  • Assists with capturing and documenting system flow and other pertinent technical information about data, database design, or systems.
  • Bachelor’s degree in computer engineering, computer science, information systems, or related field.
  • 8+ years experiences with data analytics, data modeling, and database design.
  • Experience in data modeling in transactional and operational reporting and analytical solutions.
  • Advanced knowledge of application, data and infrastructure disciplines.
  • Experience with capacity planning, database scripting and package deployment.
  • Good knowledge of data replication methodology.
  • Good knowledge of data warehouse, data mart, and data lake.
  • Expertise in tuning and debugging SQL and resolving application specific bottlenecks.
  • Experience facilitating meetings and providing presentations to stakeholders and senior leaders.
  • Expertise in Data modeling, data warehousing, dimensional modeling, data modeling for big data, and metadata management.
  • Data Lake and Big Data modeling experience.
  • Experience with cloud-based databases and data warehouses is a must.
  • Excellent communication, problem solving, organizational, and analytical skills required.
  • Preferred:
  • Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys.
  • Advanced degree in computer engineering, computer science, information systems, or related field.
  • Able to work independently.
  • Experience with Hadoop, Spark, and Kafka is a plus.
  • Experience with Scala is a plus.
  • Strong communication and interpersonal skills.
  • Ability to present design of the solution to various stakeholders.
  • Experience in data modeling and design in the insurance and financial industries.