> Markdown version of [/jobs/ext/287766-senior-data-modeler](https://www.wearedevelopers.com/jobs/ext/287766-senior-data-modeler). 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). --- # Senior Data Modeler - **Company:** DEREX Technologies, Inc. - **Location:** Erie, PA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Java (Programming Language), XML Schema, XMLSpy, Data Analysis, Big Data, Data Auditing, Data Governance, Data Profiling, Data Structures, Data Vault Modeling, Dimensional Modeling, Interoperability, JSON, Mainframes, Meta-Data Management, Standard Sql, Management of Software Versions, Extensible Markup Language (XML), XQuery, Data Ingestion, Change Data Capture, Star Schema, Data Pipelines - **Published:** May 13, 2026 - **Apply:** https://jobs.smartrecruiters.com/DerexTechnologiesInc/744000126159439-senior-data-modeler ## About the Role Must have in Property & Casualty (P&C) Insurance domain experience., * Strong experience in Data Analysis and Data Profiling tools/techniques * Expertise in Dimensional Modeling, Data Vault 2.0, Canonical Data Modeling and hands-on experience using the tools like ERWin and Hackoldate * Solid understanding of Change Data Capture (CDC) frameworks and tools * Deep knowledge of SCD Types and practical implementation strategies * Hands-on experience with XML, XSD, and JSON data structures using XML IDEs like Altova XMLSpy * Deep understanding of the Mainframe Data Structures (like Segments, Copybooks) * Experience in schema management, including schema evolution and drift handling * Proficiency in data auditing, reconciliation, and balancing techniques * Strong SQL and XQuery skills and experience working with large datasets. * Experience working with industry-standard data models such as ACORD ## Description We are seeking a highly skilled Senior Data Modeler with deep expertise in Property & Casualty (P&C) Insurance and strong capabilities in data analysis, modeling, governance, and schema management. This role requires hands-on experience in analyzing complex data structures, ensuring data quality, and designing scalable data models aligned with industry standards such as ACORD and enterprise canonical data models, along with strong familiarity with policy administration platforms such as OneShield and Policy Management Systems (PMS)., * Work closely with business stakeholders to translate P&C insurance domain requirements (policy/quote/rating lifecycle, endorsements, claims, billing) into scalable data solutions. * Perform in-depth data analysis and profiling to assess data quality, completeness, and consistency across multiple systems. * Design and implement robust data models, including: * Relational and Denormalized Data Modeling * Dimensional Modeling (Star/Snowflake schemas) * Data Vault Modeling (Hubs, Links, Satellites) * Apply Slowly Changing Dimensions (SCD Types 1, 2, 3, etc.), with clear understanding of when to use each based on business requirements. * Support Change Data Capture (CDC) processes to enable efficient incremental data ingestion and synchronization. * Conduct data balancing and auditing to ensure reconciliation between source and target systems. * Analyze and process XML and JSON data structures, including troubleshooting and transformation. * Maintain and enhance XSDs and Java-based schemas, addressing: * Schema evolution and Schema drift * Backward/forward compatibility * Work with and map data to industry-standard data models (e.g., ACORD) and design/maintain enterprise canonical data models for system interoperability. * Integrate and analyze data from policy administration systems such as OneShield and other PMS platforms, ensuring alignment with downstream data models and reporting layers. * Collaborate with engineering teams to ensure proper schema versioning, canonical modeling, and governance practices. * Define and enforce data governance standards, including metadata management, lineage, and data quality rules. * Support regulatory and reporting requirements specific to the insurance industry ## Related Videos - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [JSON and Beyond](https://www.wearedevelopers.com/videos/968-json-and-beyond) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)