Application Data Modeler

Overview:

Job Title: Application Data Modeler

Duration: Contract-to-Hire (CTH)

Location: Remote

Role Overview

We are seeking an Application Data Modeler to design and optimize data structures supporting interactive software applications and online transaction processing (OLTP) systems. This role requires strong expertise in database design, data modelling, and governance, with hands-on experience across multiple relational database platforms. The ideal candidate will bridge technical design with business needs, ensuring scalable, compliant, and well-documented data solutions.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models for OLTP systems.
• Develop and optimize relational database schemas with proper normalization (up to 3NF).
• Collaborate with application teams to ensure models align with interactive software requirements.
• Implement and enforce data governance standards across platforms.
• Utilize data catalog tools (Alation, Collibra, or comparable) to manage metadata and ensure data accessibility.
• Generate and validate SQL scripts from modeling tools to support schema creation and updates.
• Partner with cross-functional teams to ensure consistency, compliance, and scalability of data solutions.

Top Requirements (Must-Haves)

Technical Skills

• Interactive software applications and OLTP systems experience.
• Database design and data modeling (conceptual, logical, physical).
• Relational databases: PostgreSQL (primary), with exposure to MySQL and Oracle for cross-platform understanding.
• Normalization (3NF) and schema optimization.
• SQL scripting: Strong understanding of SQL dialects; not required to be a PostgreSQL expert but must grasp differences across platforms.
• Modeling tools: Proficiency with DB Schema (preferred), Irwin, ER Studio, or cloud-based modeling solutions.

Data Governance & Catalogs

• Experience with metadata management and data catalog platforms.
• Hands-on with Alation (preferred) or comparable tools such as Collibra.
• Strong grasp of data catalog principles beyond tool usage.

Preferred Attributes

• Strong analytical and problem-solving skills.
• Ability to translate complex technical requirements into clear, actionable designs.
• Excellent communication skills for cross-functional collaboration.
• Detail-oriented with a focus on compliance and governance.

Skills:

Data Modeler,OLTP,Interactive software applications,3NF,DATA GOVERNANCE