Data Modeller

Overview

About the Role

As a Data Modeller, you will be responsible for designing and implementing data models for our Databricks-based Modern Data Platform. You will work closely with business stakeholders, data architects, and data engineers to create logical and physical data models that support the migration from legacy systems to the Databricks Lakehouse architecture, ensuring data integrity, performance, and compliance with healthcare industry standards.

**Key Responsibilities**:
- Design and implement logical and physical data models for Databricks Lakehouse implementations
- Translate business requirements into efficient, scalable data models
- Create and maintain data dictionaries, entity relationship diagrams, and model documentation
- Develop dimensional models, data vault models, and other modeling approaches as appropriate
- Support the migration of data models from legacy systems to Databricks platform
- Collaborate with data architects to ensure alignment with overall data architecture
- Work with data engineers to implement and optimize data models
- Ensure data models comply with healthcare industry regulations and standards
- Implement data modeling best practices and standards
- Provide guidance on data modeling approaches and techniques
- Participate in data governance initiatives and data quality assessments
- Stay current with evolving data modeling techniques and industry trends

**Qualifications**:
- Extensive experience in data modeling for analytics and reporting systems
- Strong knowledge of dimensional modeling, data vault, and other modeling methodologies
- Experience with Databricks platform and Delta Lake architecture
- Expertise in healthcare data modeling and industry standards
- Experience migrating data models from legacy systems to modern platforms
- Strong SQL skills and experience with data definition languages
- Understanding of data governance principles and practices
- Experience with data modeling tools and technologies
- Knowledge of performance optimization techniques for data models
- Bachelor's degree in Computer Science, Information Systems, or related field; advanced degree preferred
- Professional certifications in data modeling or related areas

**Technical Skills**:
- Data modeling methodologies (dimensional, data vault, etc.)
- Databricks platform and Delta Lake
- SQL and data definition languages
- Data modeling tools (erwin, ER/Studio, etc.)
- Data warehousing concepts and principles
- ETL/ELT processes and data integration
- Performance tuning for data models
- Metadata management and data cataloging
- Cloud platforms (AWS, Azure, GCP)
- Big data technologies and distributed computing

**Healthcare Industry Knowledge**:
- Healthcare data structures and relationships
- Healthcare terminology and coding systems (ICD, CPT, SNOMED, etc.)
- Healthcare data standards (HL7, FHIR, etc.)
- Healthcare analytics use cases and requirements
- Optionally Healthcare regulatory requirements (HIPAA, HITECH, etc.)
- Clinical and operational data modeling challenges
- Population health and value-based care data needs

**Personal Attributes**:
- Strong analytical and problem-solving skills
- Excellent attention to detail and data quality focus
- Ability to translate complex business requirements into technical solutions
- Effective communication skills with both technical and non-technical stakeholders
- Collaborative approach to working with cross-functional teams
- Self-motivated with ability to work independently
- Continuous learner who stays current with industry trends

**What We Offer**:
- Opportunity to design data models for cutting-edge healthcare analytics
- Collaborative and innovative work environment
- Competitive compensation package
- Professional development opportunities
- Work with leading technologies in the data space