Senior BI – Semantic Modeler Consultant

Overview

We are seeking a highly skilled Senior BI – Semantic Modeler Consultant to join our team on a contract basis. The ideal candidate will have extensive experience in dimensional modeling, Teradata technologies, and BI tool implementation, with a passion for translating business needs into efficient semantic models. This role involves close collaboration with stakeholders to design, optimize, and maintain data models that drive insightful reporting and analytics.

Key Responsibilities

• Conduct business analysis, discovery, interviews, data analysis, and develop use cases and end-to-end solutions for business users, including requirement analysis and documentation.
• Collaborate with business stakeholders, data architects, and data engineers to understand, create, and translate business requirements into semantic models and implement them in BI tools.
• Design, implement, and maintain semantic/dimensional models using Teradata tools and technologies, incorporating industry analytical models.
• Design dimensional models for faster data access through reporting tools by understanding BI tool architecture and 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 and resolve data anomalies.
• 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 the 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 the presentation layer in BI Tools.
• Self-service solution design, architecture, and implementation in at least one BI Tool.
• 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, and chatbot integration.

Candidate Profile

The successful candidate must:

• Possess strong interpersonal and communication skills.
• Be proficient in the use of both written and spoken business English.
• Demonstrate 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.
• Be a collaborative team player with a professional attitude, strong drive, and positive mindset.
• Be a self-starter with a positive attitude, intellectual curiosity, and a passion for analytics and solving real-world problems.
• Be willing to travel.