Technical Consultant-Data Modeler

Titan Company; Bengaluru; Hybrid; INR 1,800,000 - 3,000,000; Full time

Job summary

Titan Company is seeking a Data Modeler in Bengaluru to design and build standard and benchmark data models using Layered Scalable Architecture/Medallion Architecture. You will deliver data marts across Titan’s businesses, focusing on data quality, governance, and scalable analytics.

You will work with AWS services, SQL, Python, and reporting tools to enable self-service analytics and efficient decision-making. Strong collaboration across product, analytics and IT teams is expected.

Qualifications

• Strong SQL knowledge including advanced SQL, stored procedures, and performance tuning.
• Experience in Data Warehousing, Data Modelling, and RDBMS concepts.
• Exposure to AI/ML, Gen AI, NLP and analytics-related tooling.
• Experience with Layered Scalable Architecture/Medallion Architecture for data modeling.

Responsibilities

• Design and create standard and benchmark data models for Titan's Data Marts.
• Deliver high-quality data models across multiple business domains with scalable architecture.
• Collaborate with data engineering, analytics, and business teams to ensure data quality and governance.
• Implement reporting and self-service data capabilities using Tableau/Power BI/AWS QuickSight.
• Apply agile delivery practices to manage data architecture projects.

Skills

Data modeling

Data architecture

Medallion architecture

Data marts

Data quality

AWS Redshift

AWS S3

AWS Lambda

AWS RDS

AWS Glue

Tableau

Power BI

AWS QuickSight

Python

SQL

Advanced SQL

NLP

Gen AI

Polyglot programming

Tools

ERWin

ERStudio

Tableau

Power BI

AWS Glue

SQL tools

Quicksight

Job description

Job Requirements

• Data Modeler in the Data Architecture domain responsible for the design and creation of standard and benchmark data models using Layered Scalable Architecture principles / Medallion Architecture to deliver the Data Marts across all Businesses of Titan with highest data quality.
• This includes complexities like several decades of Business Data, external data, high volume, complex structure, Performance & Costs.
• Should have expertise in AWS stack (RedShift, S3, Lambda APIs, RDS, Glue, Q), DevOps, RDBMS concepts, data warehousing, modelling, agile concepts, Python, Awareness in AI / ML, Gen AI, NLP and have strong hands on experience in SQL/advanced SQL and polyglot programming.
• Should have good understanding of Reporting Tools such as Tableau / Power-BI / AWS Quicksight Should have exposure to Data Governance Mechanisms to ensure highest data quality and self-service capabilities to end users Should have experience in Agile Methodology of delivery

Work Experience

• Strong Technical knowledge of SQL (Advanced SQL store procedures, performance tuning), Data Warehousing, Data Modelling and RDBMS
• ER Modelling using tools such as ERWin/ ERStudio – Forward & Reverse Engineering should have worked on modelling tools and extensive knowledge on Conceptual, Logical and Physical Models
• Should have independently managed customers and projects
• Minimum 3 projects implementation experience in Retail/Merchandizing/Manufacturing/HR/Finance domains
• Good Knowledge on ETL tools (min 1 tool) preferably SAP Data Services/IBM Data Stage/AWS Glue
• Good process knowledge of minimum one Domain Experience in Leading Projects in agile framework – at least 1 medium to complex project
• Good Managerial Skills & Communication & Interpersonal skills
• Excellent Analytical skills - Problem solving/troubleshooting
• Excellent Team player
• Experience in implementation of SF Customer Data Cloud would be an added advantage
• Good to have – Statistical data modelling / Predictive modelling skills