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
