Job Title
Data Modeler – Databricks Delta Lake / Lakebase & Cloud Data Migration
Experience
5+ Years
Employment Type
Full-Time
Work Mode
Hybrid
Domain
Healthcare / Financial Services / Insurance (Preferred)
Job Summary
We are seeking an experienced Data Modeler with strong expertise in Databricks Delta Lake, Lakehouse architecture, cloud data platforms, and Oracle database modernization initiatives. The ideal candidate will be responsible for designing enterprise data models, supporting large-scale data migrations, and developing modern data architectures that enable analytics, AI/ML, and business intelligence solutions.
The successful candidate will have hands-on experience with Databricks Unity Catalog, Delta Sharing, metadata governance, ETL/ELT frameworks, and cloud-native databases. This role requires strong knowledge of data modeling practices, data governance, lineage, quality management, and migration strategies from traditional Oracle platforms to modern cloud data ecosystems.
Key Responsibilities
- Design and develop conceptual, logical, and physical data models for enterprise-scale data platforms.
- Define data architecture patterns for Databricks Lakehouse environments using Delta Lake and Lakebase capabilities.
- Support Oracle database modernization and migration initiatives to modern cloud platforms.
- Design optimized data structures for:
- Databricks Delta Lake
- Snowflake
- Azure SQL Database
- Azure Synapse Analytics
- PostgreSQL
- MongoDB and other cloud-native databases
- Develop data models supporting analytics, reporting, operational workloads, and AI/ML use cases.
- Implement data modeling best practices including normalization, dimensional modeling, star schemas, and data vault concepts where applicable.
- Collaborate with data engineers, architects, analysts, and business stakeholders to define enterprise data requirements.
- Support implementation of Databricks Unity Catalog, Delta Sharing, and metadata governance frameworks.
- Define data lineage, ownership, security, and governance standards.
- Work with ETL/ELT teams to design efficient data ingestion and transformation processes.
- Support data pipeline development using tools such as:
- Azure Data Factory (ADF)
- dbt
- Informatica
- Fivetran
- Other ETL/ELT platforms
- Partner with data governance teams to implement metadata management, data quality, and compliance processes.
- Design AI/ML-ready data products and support feature engineering requirements.
- Perform data analysis, profiling, validation, and optimization activities.
- Provide technical guidance during migration, integration, and modernization projects.
Required SkillsData Modeling & Architecture
- Enterprise Data Modeling
- Conceptual, Logical, and Physical Data Models
- Dimensional Modeling
- Data Architecture Principles
- Data Warehouse Design
- Data Lakehouse Architecture
- Data Product Design
Databricks & Lakehouse
- Databricks Delta Lake
- Databricks Unity Catalog
- Delta Sharing
- Lakehouse Architecture
- Databricks Lakebase / Cloud-Native Transactional Data Platforms
- Metadata Governance
Cloud Platforms
- Microsoft Azure
- Amazon Web Services (AWS)
- Google Cloud Platform (GCP)
Database Migration & Modernization
- Oracle Database Migration
- Oracle to Cloud Modernization
- Databricks Delta Lake Migration
- Snowflake Migration
- Azure SQL Database
- Azure Synapse Analytics
- PostgreSQL
- MongoDB
ETL / ELT & Data Integration
- Azure Data Factory (ADF)
- dbt
- Informatica
- Fivetran
- Data Pipeline Design
- Data Transformation Frameworks
Data Governance
- Microsoft Purview
- Collibra
- Alation
- Informatica Enterprise Data Catalog (EDC)
- Data Lineage
- Metadata Management
- Master Data Management (MDM)
- Data Quality Frameworks
Preferred Skills
- Experience designing healthcare, insurance, or financial services data models.
- Knowledge of regulatory and compliance requirements for highly governed data environments.
- Experience supporting AI/ML-ready data platforms and feature engineering pipelines.
- Familiarity with ML feature stores and analytical data products.
- Experience with SQL, Python, and data analysis techniques.
- Understanding of cloud security, access controls, and data privacy practices.
- Experience working with Agile delivery teams.
Required Qualifications
- Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or related field.
- 5+ years of experience as a Data Modeler, Data Architect, or similar data engineering role.
- Strong experience designing enterprise data models and supporting modernization programs.
- Hands-on experience with Databricks Delta Lake and modern cloud data platforms.
- Experience migrating workloads from Oracle to cloud-based data platforms.
- Strong understanding of data governance, metadata management, and data quality practices.
- Excellent analytical, communication, and problem-solving skills.
Preferred Certifications
- Databricks Certified Data Engineer
- Databricks Certified Data Architect
- Azure Data Engineer Associate (DP-203)
- Snowflake Certification
- Cloud architecture certifications
Success Measures
- Successful delivery of scalable and optimized enterprise data models.
- Smooth migration of Oracle workloads to modern cloud platforms.
- Improved data governance, quality, lineage, and discoverability.
- Enablement of analytics and AI/ML-ready data products.
- Increased efficiency and reliability of enterprise data platforms.
Work Location: Hybrid remote in Remote
