Data Modeler (ER/Studio)

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