Senior BI - Semantic Modeler Consultant - SysTechuss

Systechcorp Inc

5 - 10 years

7 - 11 Lacs

mumbai pune

Posted:-1 days ago| Platform:

Apply

Skills Required

computer science performance tuning data analysis data modeling business analysis agile qlikview troubleshooting information technology analytics

Work Mode

Work from Office

Job Type

Full Time

Job Description

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

More Jobs at Systechcorp Inc

Technical Writer

Bengaluru

3 - 6 yrs

INR 1 - 6 Lacs

Architecture/Design/Development - Application Developer II

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

4 - 7 yrs

INR 6 - 9 Lacs

IT - Datastage Developer

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

3 - 7 yrs

INR 5 - 9 Lacs

Consultant

Noida, Hyderabad, Bengaluru

7 - 10 yrs

INR 15 - 30 Lacs

Developer

Noida, Hyderabad, Bengaluru

5 - 10 yrs

INR 12 - 22 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Business Analysis Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.