Data Engineer

Job Title: Data Engineer – Automobile Dealership

Key Responsibilities

• Design and manage data pipelines across dealership systems.
• Integrate DMS, CRM, Website, WhatsApp, Meta, and Google lead sources.
• Build and maintain centralized databases and data warehouses.
• Develop ETL/ELT processes for automated data movement.
• Ensure data quality, accuracy, and consistency across systems.
• Create API integrations between business applications.
• Automate data collection and reporting workflows.
• Support Power BI and analytics teams with clean and structured datasets.
• Monitor database performance, backups, and security.
• Develop scalable data architecture for future AI and automation initiatives.
• Required Skills
• Advanced SQL
• Python
• REST API Integration
• Database Management (SQL Server / MySQL / PostgreSQL)
• ETL/ELT Concepts
• Data Warehousing
• Data Modeling
• Data Quality & Validation
• Power BI Data Connectivity
• Microsoft Excel (Intermediate)

Preferred Skills

• Azure Data Factory
• SSIS
• Apache Airflow
• CRM & DMS Integration
• WhatsApp API Integration
• Cloud Platforms (Azure / AWS / GCP)
• Experience in the Automobile Industry
• Key Deliverables
• DMS ↔ CRM Integration
• Lead Management Data Pipeline
• WhatsApp & Digital Lead Integration
• Automated Data Warehouse
• Centralized Reporting Database
• Automated MIS Data Feeds
• AI-Ready Structured Data Environment