Semantic Layer

3 days ago

Bengaluru Chennai Hyderabad, India Systechcorp Inc Full time ₹ 15,00,000 - ₹ 20,00,000 per year

Role & responsibilities

Job Summary:

We are looking for a skilled Data Engineer / BI Developer with experience in designing and managing the semantic layer for business intelligence platforms and performing historical data loads for analytical systems. This role will support enterprise data models, enhance reporting efficiency, and ensure consistent and reliable access to historical data for decision-making.

Key Responsibilities:

Semantic Layer Development

  • Design and implement a semantic layer using tools like Tableau, Power BI, Looker, SAP BO, or custom views.
  • Translate business requirements into logical models that abstract complex data into user-friendly, business-oriented terms.
  • Define business metrics, dimensions, hierarchies, and calculated fields to support consistent analytics.
  • Optimize semantic layer performance for large-scale reporting and self-service BI.

Historical Data Loading

  • Design and implement processes for initial and incremental historical data loads into data warehouses or data lakes.
  • Use ETL/ELT tools (e.g., Informatica, Talend, DBT, Azure Data Factory, AWS Glue) to load and transform large historical datasets.
  • Ensure data accuracy, versioning, and maintain proper data lineage for historical records.
  • Implement and maintain SCD (Slowly Changing Dimensions) and time-based data tracking logic.

General Responsibilities

  • Collaborate with data modelers, analysts, and business stakeholders to define semantic and data retention requirements.
  • Document semantic models and historical data load processes.
  • Troubleshoot data issues and support UAT and production deployments.
  • Ensure compliance with data governance and data quality standards.

Required Skills & Qualifications:

  • Bachelors degree in Computer Science, Information Systems, or related field.
  • 4+ years of experience in data engineering or BI development.
  • Hands-on experience with semantic modeling tools (Tableau semantic layer, Power BI datasets, LookML, etc.).
  • Proficient in SQL, data modeling, and ETL/ELT pipelines.
  • Experience with historical data handling techniques, including SCD Type 1/2, snapshots, and time-series data.
  • Familiarity with data warehouse technologies (Snowflake, Redshift, BigQuery, etc.).
  • Strong communication and documentation skills.

Preferred Qualifications:

  • Experience with data virtualization or BI metadata management tools.
  • Cloud platform experience (AWS, Azure, or GCP).
  • Understanding of data governance, security, and compliance frameworks.
  • Knowledge of Agile/Scrum project methodologies.

Preferred candidate profile

  • Data Engineer-Semantic layer and History data load

    3 days ago

    Bengaluru, Hyderabad, Mumbai, India Systechcorp Inc Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Job Title:BI/Data Engineer Semantic Layer & Historical Data Specialist.Job Summary:We are seeking a skilled and detail-oriented BI/Data Engineer with expertise in semantic layer design and historical data loading to join our data engineering team. The ideal candidate will be responsible for building and maintaining semantic data models, ensuring smooth...

  • Enterprise Data Architect

    1 week ago

    Hyderabad, Telangana, India beBeeData Full time ₹ 1,86,35,952 - ₹ 2,44,46,700

    Key ResponsibilitiesDesign and implement scalable enterprise analytics solutions using Databricks, Power BI, and other modern data tools.Leverage data virtualization, ETL, and semantic layers to balance the need for unification, performance, and data transformation with the goal of reducing data proliferation.Support development planning by breaking down...

  • Chief Data Engineer

    6 days ago

    Bengaluru, Karnataka, India beBeeDataArchitect Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Job Overview:The Data Architect will be responsible for designing and implementing a robust data warehousing platform. The goal is to ensure seamless integration of diverse data sources, maintain high standards of data quality and governance, and enable advanced analytics through the definition and management of semantic and common data layers.Key...

  • Senior Data Architect Specialist

    1 week ago

    Hyderabad, Telangana, India beBeeDataArchitect Full time US$ 1,50,000 - US$ 2,00,000

    Data Architecture RoleThe ideal candidate will design and implement scalable analytics solutions using Databricks, Power BI, and other modern tools. This role involves leveraging data virtualization, ETL, and semantic layers to balance the need for unification, performance, and data transformation with the goal of reducing data proliferation.

  • Microsoft Fabric Architect

    4 weeks ago

    Bengaluru, Karnataka, India Intelex Technologies Ulc Full time

    Job Description- Design and implement scalable BI and data architecture using Microsoft Fabric and Lakehouse paradigms, including medallion architecture.- Architect and optimize ELT/ETL pipelines using SQL Server, Dataflows, and Fabric Pipelines.- Integrate on-premises data sources using On-prem Data Gateway (ODG) with cloud-based solutions.- Develop a...

  • Senior Business Intelligence Developer

    1 week ago

    Bengaluru, Karnataka, India beBeeData Full time ₹ 15,00,000 - ₹ 25,00,000

    DBT ETL Lead Job DescriptionThe role of the DBT ETL Lead involves overseeing the creation and implementation of data integration projects using DBT on Azure.This position requires a candidate with 6+ years of experience in hands-on development with DBT, as well as proficiency in Aptitude, Snowflake, Dataflow, Data Ingestion, Data Storage & Security.A strong...

  • Power BI Developer

    3 days ago

    Hyderabad, Telangana, India IDESLABS PRIVATE LIMITED Full time US$ 80,000 - US$ 1,20,000 per year

    Type: Contract DescriptionExtensive experience in Power BI Visualization , Data Modeling and Semantic layer implementationExperience in Tabular model implementationExperience in Client interactions and requirement analysis.Excellent communication and comprehension skills.Experience in requirement documentation.Excellent presentation and coordination skills

  • Senior Data Architect

    6 days ago

    Chennai, Tamil Nadu, India Axtria - Ingenious Insights Full time

    Job Title:- Senior Data Architect Location:- NCR/(Bangalore preferably) Experience:- 10+ Years JOB OBJECTIVE: To leverage expertise in data architecture and management to design, implement, andOptimise a robust data warehousing platform for the pharmaceutical industry. The goal is toensure seamless integration of diverse data sources, maintain high standards...

  • Senior Business Intelligence Architect

    6 days ago

    Bengaluru, Karnataka, India beBeeData Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Job Title: Data Architect LeadLocation:Experience: 10+ YearsThe goal of this role is to design, implement and optimise a robust data warehousing platform for the pharmaceutical industry.Key Responsibilities:• Design logical and physical data models to ensure efficient data storage and retrieval.• Develop and optimise ETL processes to accurately and...

  • Data Validation Specialist

    5 days ago

    Hyderabad, Telangana, India beBeeDataValidation Full time ₹ 2,00,00,000 - ₹ 2,50,00,000

    Job Title: Data Validation SpecialistWe are seeking a skilled Data Validation Specialist to join our team. This role will involve collaborating with the QA Manager to design and implement end-to-end test strategies for data validation, semantic layer testing, and GraphQL API validation.Key Responsibilities:Design and implement automated data validation...