Senior BI - Semantic Modeler Consultant

Position: Senior BI - Semantic Modeler Consultant.
Location: Mumbai / Pune, India.Experience: 5+ yearsResponsibilitiesBusiness Analysis, Business discovery, conduct business interviews, data analysis, develop use case & end-to-end solution for business users & requirement analysis & documentation.Collaborate with business stakeholders, data architects, and data engineers to understand, create and translate business requirements into semantic models & implement in BI tool.Design, implement & maintain semantic/ dimensional models using Teradata tools & technologies and industry analytical modelsDesign dimensional models for faster access of data through reporting tool by understanding the BI tool architecture & optimization techniques.Create logical and physical models, ensuring data consistency, integrity, and performance optimization.Participate in data profiling and data quality assessment activities to identify data anomalies and resolve them.Collaborate with the data engineering team to integrate semantic models with the data warehouse infrastructure.Implement best practices for semantic modeling, ensuring adherence to data governance and security policies.Conduct performance tuning and optimization activities to enhance query performance and overall system efficiency.Provide guidance and support to other team members, assisting with troubleshooting, performance tuning, and model enhancements.Stay updated with industry trends, emerging technologies, and advancements in Teradata ecosystem to bring innovative solutions and improve data modeling practices.Collaborate with stakeholders to gather feedback and iterate on semantic models to meet evolving business needs. Qualifications: Bachelor's degree (or higher) preferably in Computer Science, Computer Applications, Information Technology or other related fields.5+ years of experience in dimensional modeling along with successful implementation of presentation layer in BI ToolsSelf-service solution design, architecture & implementation in one of the BI Tools at leastProven experience working as a Semantic Modeler, Data Modeler, or similar role, with expertise in Teradata.In-depth knowledge of Teradata database concepts, SQL, and performance optimization techniques.Strong understanding of data warehousing and dimensional modeling principles.Proficiency in Teradata tools such as Teradata SQL Assistant, Teradata Studio, Teradata Unity, and Teradata Viewpoint.Experience with ETL processes, data integration, and data governance principles.Familiarity with data visualization tools such as Tableau, Power BI, or QlikView is a plus.Understanding of Agile software methodology and Cloud Applications.Familiar with AI fundamentals & tools, APIs, chatbot integration.