Azure Databricks Data Modeler

Sutherland; United States; Remote; USD 80,000 - 130,000; Full time

Job summary

A leading company in the automotive industry is looking for a Data Modeler to design and optimize data architectures. This role focuses on integrating data from SAP ECC and enhancing analytics solutions by collaborating with various teams while ensuring data integrity and governance.

Qualifications

• Strong experience in dimensional modeling and hybrid approaches.
• Hands-on experience with SAP ECC tables and extraction processes.
• Ability to create ER diagrams and data dictionaries.

Responsibilities

• Design and maintain data models for structured and unstructured data.
• Define data structures for integrating SAP ECC data into Azure.
• Work with stakeholders to align models with business needs.

Skills

Data Modeling Expertise

Automotive Industry Knowledge

SAP ECC Data Structures

Azure & Databricks Proficiency

SQL & Database Management

ETL & Data Integration

Data Governance & Quality

Strong Documentation Skills

Tools

Erwin

Lucidchart

DBT

Power BI

Tableau

Job description

Job Summary

We are looking for a Data Modeler to design and optimize data models supporting automotive industry analytics and reporting. The ideal candidate will work with SAP ECC as a primary data source, leveraging Databricks and Azure Cloud to design scalable and efficient data architectures. This role involves developing logical and physical data models, ensuring data consistency, and collaborating with data engineers, business analysts, and domain experts to enable high-quality analytics solutions.

Key Responsibilities:

1. Data Modeling & Architecture: Design and maintain conceptual, logical, and physical data models for structured and unstructured data.

2. SAP ECC Data Integration: Define data structures for extracting, transforming, and integrating SAP ECC data into Azure Databricks.

3. Automotive Domain Modeling: Develop and optimize industry-specific data models covering customer, vehicle, material, and location data.

4. Databricks & Delta Lake Optimization: Design efficient data models for Delta Lake storage and Databricks processing.

5. Performance Tuning: Optimize data structures, indexing, and partitioning strategies for performance and scalability.

6. Metadata & Data Governance: Implement data standards, data lineage tracking, and governance frameworks to maintain data integrity and compliance.

7. Collaboration: Work closely with business stakeholders, data engineers, and data analysts to align models with business needs.

8. Documentation: Create and maintain data dictionaries, entity-relationship diagrams (ERDs), and transformation logic documentation.

Skills & Qualifications

1. Data Modeling Expertise: Strong experience in dimensional modeling, 3NF, and hybrid modeling approaches.
2. Automotive Industry Knowledge: Understanding of customer, vehicle, material, and dealership data models.
3. SAP ECC Data Structures: Hands-on experience with SAP ECC tables, business objects, and extraction processes.
4. Azure & Databricks Proficiency: Experience working with Azure Data Lake, Databricks, and Delta Lake for large-scale data processing.
5. SQL & Database Management: Strong skills in SQL, T-SQL, or PL/SQL, with a focus on query optimization and indexing.
6. ETL & Data Integration: Experience collaborating with data engineering teams on data transformation and ingestion processes.
7. Data Governance & Quality: Understanding of data governance principles, lineage tracking, and master data management (MDM).
8. Strong Documentation Skills: Ability to create ER diagrams, data dictionaries, and transformation rules.

Preferred Qualifications

1. Experience with data modeling tools such as Erwin, Lucidchart, or DBT.
2. Knowledge of Databricks Unity Catalog and Azure Synapse Analytics.
3. Familiarity with Kafka/Event Hub for real-time data streaming.
4. Exposure to Power BI/Tableau for data visualization and reporting.