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