This role is for one of the Weekday's clients

Salary range: Rs 1800000 - Rs 2200000 (ie INR 18-22 LPA)

Min Experience: 4 years

Location: Bangalore, Bengaluru

JobType: full-time

We are seeking a skilled and detail-oriented Data Modeller with 4–6 years of experience to join our growing data engineering team. In this role, you will play a critical part in designing, implementing, and optimizing robust data models that support business intelligence, analytics, and operational data needs. You will collaborate with cross-functional teams to understand business requirements and convert them into scalable and efficient data solutions, primarily leveraging Amazon Redshift and Erwin Data Modeller.

Key Responsibilities:

- Design and implement conceptual, logical, and physical data models that support business processes and reporting needs.
- Develop data models optimized for Amazon Redshift, ensuring performance, scalability, and integrity of data.
- Work closely with business analysts, data engineers, and stakeholders to translate business requirements into data structures.
- Use Erwin Data Modeller (Erwin ERP) to create and maintain data models and maintain metadata repositories.
- Collaborate with ETL developers to ensure efficient data ingestion and transformation pipelines that align with the data model.
- Apply normalization, denormalization, and indexing strategies to optimize data performance and access.
- Perform data profiling and source system analysis to validate assumptions and model accuracy.
- Create and maintain detailed documentation,



including data dictionaries, entity relationship diagrams (ERDs), and data lineage information.
- Drive consistency and standardization across all data models, ensuring alignment with enterprise data architecture and governance policies.
- Identify opportunities to improve data quality, model efficiency, and pipeline performance.

Required Skills and Qualifications:

- 4–6 years of hands-on experience in data modeling, including conceptual, logical, and physical modeling.
- Strong expertise in Amazon Redshift and Redshift-specific modeling best practices.
- Proficiency with Erwin Data Modeller (Erwin ERP) or similar modeling tools.
- Strong knowledge of SQL with experience writing complex queries and performance tuning.
- Solid understanding of ETL processes and experience working alongside ETL engineers to integrate data from multiple sources.
- Familiarity with dimensional modeling, data warehousing principles, and star/snowflake schemas.
- Experience with metadata management, data governance, and maintaining modeling standards.
- Ability to work independently and collaboratively in a fast-paced, data-driven setting.
- Strong analytical and communication skills with the ability to present technical concepts to non-technical stakeholders.

Preferred Qualifications:

- Experience working in a cloud-native data environment (AWS preferred).
- Exposure to other data modeling tools and cloud data warehouses is a plus.
- Familiarity with data catalog tools, data lineage tracing, and data quality frameworks.

📌 Data Modeller (Bengaluru)
🏢 Important Company of the Sector
📍 Bengaluru