ServiceNow Enterprise Architect

RESPONSIBILITIES: OpenKyber has a client that is seeking a UDMH Data Modeler - Senior Associate in New York, NY. Overview: Our client is seeking a UDMH Data Modeler to support enterprise healthcare analytics and data warehousing initiatives. This role is responsible for designing, developing, and maintaining logical and physical data models using the IBM Unified Data Model for Healthcare (UDMH) framework across Operational Data Stores (ODS), Enterprise Data Warehouses (EDW), Clinical Data Integration platforms, and cloud-based analytics environments. The ideal candidate will partner with data engineering, BI, and business teams to build scalable, high-quality data models that support reporting, analytics, and clinical decision-making. Responsibilities include developing canonical healthcare data models, supporting ETL and CDC integrations, maintaining data governance standards, performing impact analysis, and optimizing data structures for performance and scalability. Additional responsibilities include supporting AWS data modernization efforts through Redshift, S3, and Glue data modeling, driving data model rationalization and simplification initiatives, managing complex data model incidents and escalations, and maintaining comprehensive documentation including data dictionaries, ER diagrams, lineage, mapping specifications, and knowledge transfer materials. This is an excellent opportunity for a healthcare data modeling professional who enjoys translating complex business requirements into scalable, enterprise-grade data solutions while supporting data governance, modernization, and analytics initiatives.

REQUIREMENTS:

• Minimum degree required: Bachelor's degree in Computer Science, Information Systems, Engineering, Statistics, Mathematics, or a related quantitative field
• 5-8 years of enterprise data modelling experience with deep expertise in logical and physical data model design, ER modelling, and large-scale data warehouse architecture
• Hands-on experience with IBM Unified Data Model for Healthcare (UDMH) - including canonical model design, multi-tenant architecture, and hub-spoke entity structures
• Expert-level proficiency in IBM DB2 - schema design, complex query writing, stored procedures, index management, and performance tuning on IBM IIAS appliance
• Strong experience with data vault modelling concepts - Hubs, Links, Satellites, and Business Data Vault patterns
• Proficiency in data modelling tools such as ER/Studio, ERwin, or IBM InfoSphere Data Architect
• Solid understanding of SCD Type 1 and Type 2 implementation patterns and their impact on downstream ETL and reporting layers
• Hands-on IBM DataStage experience - understanding of how ETL job design maps to physical data model structures, partitioning strategies, and load patterns
• Experience working with Netezza Performance Server (NPS) or equivalent MPP analytical databases - distribution key design, zone maps, and query optimization
• Strong understanding of star schema, snowflake schema, and dimensional modelling concepts for enterprise data warehouse environments
• Experience with data governance tools and practices - data lineage, metadata management, data dictionary maintenance, and HIPAA-compliant data access controls
• Proven ability to lead data model impact analysis, manage cross-team dependencies, and communicate model changes to technical and non-technical stakeholders
• Experience operating within ITSM frameworks (ServiceNow or equivalent) for intake, change management, and delivery tracking

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future. We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave. Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in OpenKyber's sole discretion unless and until paid and may be modified in its discretion consistent with the law. This job is not eligible for bonuses, incentives or commissions. OpenKyber is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from OpenKyber and its affiliates, and service providers. Note that if you choose to communicate with OpenKyber via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.

For applications and inquiries, contact:View email address on click.appcast.io