Azure Databricks Data Modeler
- Sutherland
- 4 - 6 years
- Hyderabad
- 25 days ago
- Email to a friend
- Report this job
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
- Data Modeling Expertise: Strong experience in dimensional modeling, 3NF, and hybrid modeling approaches.
- Automotive Industry Knowledge: Understanding of customer, vehicle, material, and dealership data models.
- SAP ECC Data Structures: Hands-on experience with SAP ECC tables, business objects, and extraction processes.
- Azure & Databricks Proficiency: Experience working with Azure Data Lake, Databricks, and Delta Lake for large-scale data processing.
- SQL & Database Management: Strong skills in SQL, T-SQL, or PL/SQL, with a focus on query optimization and indexing.
- ETL & Data Integration: Experience collaborating with data engineering teams on data transformation and ingestion processes.
- Data Governance & Quality: Understanding of data governance principles, lineage tracking, and master data management (MDM).
- Strong Documentation Skills: Ability to create ER diagrams, data dictionaries, and transformation rules.
Preferred Qualifications
- Experience with data modeling tools such as Erwin, Lucidchart, or DBT.
- Knowledge of Databricks Unity Catalog and Azure Synapse Analytics.
- Familiarity with Kafka/Event Hub for real-time data streaming.
- Exposure to Power BI/Tableau for data visualization and reporting.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Data Science & Analytics
Role Category: Data Science & Analytics - Other
Role: Data Science & Analytics - Other
Employement Type: Full time
Contact Details:
Company: SutherlandLocation(s): Hyderabad
Keyskills: SAP ECC erwin Data Bricks Data Integration Data Modeling Metadata power BI Performance Tuning sql Lucidchart Delta Lake Database Management DBT ETL Data Governance
Similar positions
Sutherland
Sutherland Established in 1986, Sutherland Global Services is a global provider of business process and technology management services. Sutherland offers an integrated portfolio of analytics-driven back-office and customer facing solutions that support the entire customer lifecycle. One of the l...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in