Technical Consultant-Data Modeler
Description
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