> Markdown version of [/jobs/ext/4627981-data-modeler-er-studio](https://www.wearedevelopers.com/jobs/ext/4627981-data-modeler-er-studio). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler (ER/Studio)

- **Company:** Take2 Consulting
- **Location:** United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Amazon Web Services, Data Analysis, Data Cleansing, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Oracle (Applications), Systems Development Life Cycle, Software Engineering, Tableau (Software), Unstructured Data, Enterprise Data Management, Amazon Relational Database Service, Data Lakes, Data Management, Amazon Redshift, Databricks
- **Published:** November 7, 2026
- **Apply:** https://www.dice.com/job-detail/228114a1-23dc-4d0e-8811-7b54f51faae1

## About the Role

* 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

## Description

* 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