Job Description
Advisor / Senior Advisor -Data Modeler Healthcare SME (Data Architect)
ROLE OVERVIEW
We are seeking an experienced and highly skilled Data Modeler Healthcare SME (Data Architect) with over 12 years of experience to lead the design and implementation of our data architecture. The ideal candidate will be responsible for developing, optimizing, and overseeing our conceptual, logical, and physical data models to support our strategic initiatives in the healthcare domain. You will work closely with cross-functional teams, including business stakeholders, data engineers, and analysts, to create a robust and scalable data framework that ensures the highest standards of data integrity and security.
KEY RESPONSIBILITIES
- Develop and maintain comprehensive data models that align with business requirements and industry best practices.
- Design and implement effective database solutions and models to store and retrieve healthcare data.
- Act as the subject matter expert for healthcare data standards, including FHIR and HL7, ensuring compliance and seamless data interoperability.
- Define and govern data modeling and design standards, tools, best practices, and related development methodologies.
- Create and maintain data flow diagrams, data dictionaries, and other relevant documentation for data-related processes.
- Collaborate with ETL developers to design and implement efficient and scalable data integration solutions.
- Ensure data architecture is designed for security and compliance with regulations such as HIPAA.
- Provide technical leadership and mentorship to other data professionals within the organization.
- Lead data architecture reviews, proof-of-concepts, and technical spikes to validate design choices.
- Partner with delivery leaders to estimate work, identify dependencies, and manage technical risks related to data architecture.
- Collaborate with security, privacy and compliance teams on classification, access control, minimization, retention and protection of regulated healthcare data.
- Mentor modelers, analysts and engineers; communicate complex data concepts clearly to architects, product owners, developers and business stakeholders.
MANDATORY TECHNICAL SKILLS
- Domain Core Knowledge / Technologies Expected Proficiency Responsibilities
- Enterprise Data Modeling Conceptual, logical and physical models; canonical models; normalization and denormalization; dimensional and graph-oriented patterns Own enterprise-grade models across multiple systems; convert ambiguous business concepts into implementable structures and explain trade-offs to technical and business stakeholders.
- Database Technologies SQL (e.g., PostgreSQL, SQL Server), NoSQL (e.g., MongoDB, Cassandra) Design and manage both relational and non-relational database solutions based on workload requirements, access patterns, and performance needs.
- Legacy-to-Canonical Mapping Legacy schema analysis, rule decomposition, source-to-target mapping, harmonization and semantic reconciliation Extract structures and dependencies from legacy sources; define mapping specifications, transformation rules, exceptions and reconciliation criteria.
- Data Architecture System of record, authoritative source, lineage, data contracts, integration boundaries, master/reference data and metadata Define how benefit data is created, governed, synchronized and consumed across product, enterprise healthcare benefits, claims and downstream platforms.
- Healthcare Standards Coding ICD-10-CM/PCS, CPT, HCPCS, NDC, revenue codes, place of service and X12 awareness Model clinical and administrative code references at the correct grain and support effective dating, code-set versioning and crosswalks. Hands‑on coding expertise is advantageous.
- Relational NoSQL Modeling SQL databases, document databases, indexing, partitioning, performance and schema evolution Select fit-for-purpose storage patterns from access, consistency, scale, lifecycle and query requirements; avoid technology‑first modeling.
- Integration Data Contracts REST APIs, events, streaming, batch/file interfaces, schemas, versioning and idempotency Define stable contracts and payload models that support traceability, compatibility, validation and safe evolution across producers and consumers.
- Data Governce Quality Glossary, dictionary, catalog, lineage, stewardship, classification, quality rules and controls Set governce standards and measurable quality checks for completeness, validity, consistency, uniqueness, timeliness and reconciliation.
- Modeling Tools Delivery ER/Studio, erwin, Sparx Enterprise Architect or comparable tools; Git; SQL; documentation and collaboration platforms Maintain reviewable, version‑controlled model artifacts, mapping documents and decision records; integrate modeling into iterative delivery.
- Security, Privacy Compliance PHI/PII classification, least privilege, encryption, tokenization/masking, retention and auditability Embed privacy and security requirements into the model and collaborate with governce, security and compliance partners.
- Technical Leadership Architecture Reviews, Stakeholder Management, Mentoring Lead cross‑functional decisions, resolve semantic disagreements with evidence, mentor practitioners and own model outcomes through implementation.
DESIRABLE / GOOD-TO-HAVE SKILLS
- Certified Data Management Professional (CDMP) or similar certification.
- Experience with data visualization tools such as Tableau or Power BI.
- Knowledge of Big Data technologies like Spark, Hadoop, or Kafka.
- Familiarity with domain-driven design principles.
- Experience working within an Agile/Scrum development process.
- Knowledge of major EHR/EMR systems and their underlying data structures.
EDUCATION
- Bachelors or masters degree in Computer Science, Information Technology, Data Science, Engineering, Health Informatics or a related discipline is preferred. Equivalent practical experience may be considered in line with organizational hiring policy.