Back to Jobs
Other

Data Modeler (ER/Studio)

Take2 ConsultingUnited States🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationUnited States
OracleAWSETLTableauDatabricksRedshiftAgileData Analysis

Job description

Data Modeler (ER/Studio)

Take2 Consulting is seeking a Data Modeler with ER/Studio Enterprise expertise to join the BIA/Corporate team. This role focuses on data modeling, architecture, and ETL design and development across enterprise data warehouse and cloud data platforms.

Responsibilities:

  • Design, build, and maintain data models and architecture using ER/Studio Enterprise
  • Design and develop Data Warehouse / Data Lake architecture supporting structured, semi-structured, and unstructured data
  • Design and develop ETL architecture, including master data management and data cleansing processes
  • Work across AWS, Oracle, and Amazon RDS to support data modeling and data warehouse initiatives
  • Leverage Databricks and other ETL/data analytics tools to support data engineering workflows
  • Operate within Agile/SDLC methodologies alongside cross-functional development teams

Required Qualifications:

  • 3+ years of experience with ER/Studio Enterprise Data Modeling and Architecture Tools (non-negotiable)
  • 3+ years of experience with Data Warehouse / Data Lake architecture, design, and development
  • 3+ years of ETL (Extract, Transform, Load) design and development, including ETL architecture, master data management, and data cleansing
  • 3+ years of experience with AWS, Oracle, and Amazon Relational Database Service (RDS)
  • 3+ years of experience with ETL and data analytics tools, including Databricks
  • Experience with structured, semi-structured, and unstructured data design
  • Knowledge of Agile methodologies or the Software Development Life Cycle (SDLC)
  • Ability to obtain a security clearance

Preferred Qualifications:

  • Amazon Redshift
  • Tableau

Similar jobs