Sr BI Consultant

Job Title: Senior BI - Semantic Modeler Consultant

Location: Mumbai / Pune, Maharashtra, India

Responsibilities:

• Business 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 models
• Design 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 Tools
• Self-service solution design, architecture & implementation in one of the BI Tools at least
• Proven 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.
• Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Understanding of Agile software methodology and Cloud Applications.
• Familiar with AI fundamentals & tools, APIs, chatbot integration.

Candidate Profile - Successful candidate must

• Possess strong interpersonal and communication skills.
• Be proficient in the use of both written and spoken business English.
• Proven skills in creative-problem-solving of complex and advanced technical subject matter.
• Possess a solid understanding of the value of data and how technology enables companies to compete better in the marketplace.
• Collaborative team player, professional attitude with a strong drive and positive mind.
• Be self-starter with a positive attitude, intellectual curiosity and a passion for analytics and solving real world problems.
• Be willing to travel.

Job Types: Full-time, Permanent

Work Location: In person