Hybrid Data Modeler (erwin, Oracle & SQL Server)

Openkyber, LLC; Atlanta (GA); Hybrid; USD 69,000 - 117,000; Full time

Job summary

OpenKyber, LLC in Dallas, TX is seeking a Data Modeler to join the Data Architecture team on a 6+ month contract, hybrid with 3 days onsite. You will design and maintain enterprise data models using erwin Data Modeler, Oracle, and MS SQL Server to support analytics, governance, and advanced data solutions.

You will translate business requirements into robust data models, collaborate with DBAs, ETL developers, and stakeholders, and ensure performance, scalability, and data quality across large

Qualifications

• 4+ years of hands-on data modeling experience in enterprise environments.
• Advanced proficiency with erwin Data Modeler (v9.x+).
• Strong experience with Oracle databases and MS SQL Server.
• Advanced SQL skills with extensive DDL knowledge.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models using erwin Data Modeler.
• Create, review, and optimize DDL scripts for database objects.
• Perform forward and reverse engineering of Oracle and SQL Server databases.
• Collaborate with data architects, DBAs, ETL developers, and stakeholders to refine requirements.
• Develop data models adhering to normalization standards (3NF/BCNF).
• Support dimensional modeling initiatives for data warehousing and analytics.
• Conduct data model reviews and version control using modeling tools.
• Participate in data governance initiatives including metadata management and data lineage.
• Follow Data Governance and Protection policies.
• Assist with optimizing enterprise data solutions.

Skills

Data modeling

Communication

Analytical thinking

Detail orientation

Collaborative

Tools

erwin Data Modeler

Oracle

Microsoft SQL Server

DDL scripting

Job description

OpenKyber, LLC in Dallas, TX is seeking a Data Modeler to join the Data Architecture team on a 6+ month contract, hybrid with 3 days onsite. You will design and maintain enterprise data models using erwin Data Modeler, Oracle, and MS SQL Server to support analytics, governance, and advanced data solutions.

You will translate business requirements into robust data models, collaborate with DBAs, ETL developers, and stakeholders, and ensure performance, scalability, and data quality across large