{"schemaVersion":"jobsearcher.job.v1","id":"1553d0907fa0d7c3b491501e","url":"https://jobsearcher.com/jobs/1553d0907fa0d7c3b491501e","canonicalUrl":"https://jobsearcher.com/jobs/1553d0907fa0d7c3b491501e","title":"Application Data Modeler","description":"Job Title: Application Data Modeler\nDuration: Contract‑to‑Hire (CTH)\nLocation: Remote\n\nRole Overview\nWe 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.\nKey Responsibilities\nDesign and maintain conceptual, logical, and physical data models for OLTP systems.\nDevelop and optimize relational database schemas with proper normalization (up to 3NF).\nCollaborate with application teams to ensure models align with interactive software requirements.\nImplement and enforce data governance standards across platforms.\nUtilize data catalog tools (Alation, Collibra, or comparable) to manage metadata and ensure data accessibility.\nGenerate and validate SQL scripts from modeling tools to support schema creation and updates.\nPartner with cross‑functional teams to ensure consistency, compliance, and scalability of data solutions.\nTop Requirements (Must‑Haves)\nTechnical Skills\nInteractive software applications and OLTP systems experience.\nDatabase design and data modeling (conceptual, logical, physical).\nRelational databases: PostgreSQL (primary), with exposure to MySQL and Oracle for cross‑platform understanding.\nNormalization (3NF) and schema optimization.\nSQL scripting: Strong understanding of SQL dialects; not required to be a PostgreSQL expert but must grasp differences across platforms.\nModeling tools: Proficiency with DB Schema (preferred), Irwin, ER Studio, or cloud‑based modeling solutions.\nData Governance & Catalogs\nExperience with metadata management and data catalog platforms.\nHands‑on with Alation (preferred) or comparable tools such as Collibra.\nStrong grasp of data catalog principles beyond tool usage.\nPreferred Attributes\nStrong analytical and problem‑solving skills.\nAbility to translate complex technical requirements into clear, actionable designs.\nExcellent communication skills for cross‑functional collaboration.\nDetail‑oriented with a focus on compliance and governance.","company":"Stellar It Solutions","rawCompany":"stellar it solutions","city":"St Louis","state":"MO","isRemote":false,"isActive":false,"createdAt":"2026-08-10T14:17:03.305Z","occupations":[{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Application Data Modeler","description":"Job Title: Application Data Modeler\nDuration: Contract‑to‑Hire (CTH)\nLocation: Remote\n\nRole Overview\nWe 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.\nKey Responsibilities\nDesign and maintain conceptual, logical, and physical data models for OLTP systems.\nDevelop and optimize relational database schemas with proper normalization (up to 3NF).\nCollaborate with application teams to ensure models align with interactive software requirements.\nImplement and enforce data governance standards across platforms.\nUtilize data catalog tools (Alation, Collibra, or comparable) to manage metadata and ensure data accessibility.\nGenerate and validate SQL scripts from modeling tools to support schema creation and updates.\nPartner with cross‑functional teams to ensure consistency, compliance, and scalability of data solutions.\nTop Requirements (Must‑Haves)\nTechnical Skills\nInteractive software applications and OLTP systems experience.\nDatabase design and data modeling (conceptual, logical, physical).\nRelational databases: PostgreSQL (primary), with exposure to MySQL and Oracle for cross‑platform understanding.\nNormalization (3NF) and schema optimization.\nSQL scripting: Strong understanding of SQL dialects; not required to be a PostgreSQL expert but must grasp differences across platforms.\nModeling tools: Proficiency with DB Schema (preferred), Irwin, ER Studio, or cloud‑based modeling solutions.\nData Governance & Catalogs\nExperience with metadata management and data catalog platforms.\nHands‑on with Alation (preferred) or comparable tools such as Collibra.\nStrong grasp of data catalog principles beyond tool usage.\nPreferred Attributes\nStrong analytical and problem‑solving skills.\nAbility to translate complex technical requirements into clear, actionable designs.\nExcellent communication skills for cross‑functional collaboration.\nDetail‑oriented with a focus on compliance and governance.","datePosted":"2026-08-10T14:17:03.305Z","dateModified":"2026-08-10T14:17:03.305Z","hiringOrganization":{"@type":"Organization","name":"Stellar It Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"St Louis","addressRegion":"MO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"1553d0907fa0d7c3b491501e"},"url":"https://jobsearcher.com/jobs/1553d0907fa0d7c3b491501e"}}