Data Engineer-Semantic layer and History data load

2 weeks ago

Bengaluru Hyderabad Mumbai, India Systechcorp Inc Full time ₹ 15,00,000 - ₹ 25,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 integration of historical data, and supporting analytics and reporting through self-service capabilities. The role involves full-cycle project execution, from requirement analysis to production deployment and testing.

Key Responsibilities:

Semantic Layer Development

  • Conduct detailed requirement analysis and participate in requirement review sessions with stakeholders.
  • Design, develop, and maintain the semantic layer to enable easy access to business-friendly data for reporting and analytics tools (e.g., Power BI, Tableau, Looker).
  • Develop and optimize data models to support self-service BI and standardized reporting.
  • Collaborate with business analysts and users to support self-service reporting needs.

Data Integration & Historical Loading

  • Design and implement processes for history data loading, including sourcing, transformation, and integration of historical datasets.
  • Analyze data sources and schema, ensuring alignment with semantic models and business requirements.

Testing & Deployment

  • Develop test reports and test cases for SIT (System Integration Testing) and UAT (User Acceptance Testing) phases.
  • Support comprehensive testing cycles, resolving issues and validating business logic with QA and business teams.
  • Coordinate and execute production deployment, ensuring minimal disruption to existing processes.

Job Scheduling & Monitoring

  • Design and implement job scheduling workflows to automate ETL/ELT processes and semantic layer refreshes.
  • Monitor scheduled jobs for failures or delays and troubleshoot issues in a timely manner.

Required Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 4+ years of experience in BI development, data modeling, or semantic layer creation.
  • Strong understanding of ETL processes, data warehousing, and data modeling concepts.
  • Hands-on experience with tools like Informatica, DBT, Power BI, Tableau, or Looker.
  • Proficiency in SQL and scripting for data transformation and validation.
  • Experience in history data loading strategies such as SCD (Slowly Changing Dimensions) and snapshotting.
  • Familiarity with data governance, metadata management, and data quality best practices.

Preferred Qualifications:

  • Experience with cloud data platforms such as Snowflake, Redshift, Azure Synapse, or Google BigQuery.
  • Knowledge of Agile methodologies and DevOps practices in data engineering.
  • Experience with job orchestration tools such as Apache Airflow, Control-M, or Azure Data Factory.

  • Semantic Layer

    2 weeks ago

    Bengaluru, Chennai, Hyderabad, India Systechcorp Inc Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role & responsibilitiesJob 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...

  • Semantic Data Modeler

    2 weeks ago

    Hyderabad, Mumbai, Pune, India Crisil Full time ₹ 12,00,000 - ₹ 22,00,000 per year

    Job description:We are seeking a highly skilled Semantic Data Modeler to join our data and AI team. This role will focus on designing and implementing canonical models, ontologies, and taxonomies to enable a unified semantic layer that bridges structured data from multiple silos (RDBMS and other sources) into AI-ready, knowledge-driven assets. The ideal...

  • Semantic Data Modeler

    2 days ago

    Hyderabad / Pune / Mumbai, India CRISIL Ltd Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Semantic Data Modeler Department Corporate Group Job Description Job description: We are seeking a highly skilled Semantic Data Modeler to join our data and AI team. This role will focus on designing and implementing canonical models, ontologies, and taxonomies to enable a unified semantic layer that bridges structured data from multiple silos...

  • Sr. Analytics Engineer

    4 weeks ago

    Hyderabad, India Blue Yonder Full time

    Job Description Position Overview We are seeking an experienced Senior Analytics Engineer to join our data team and drive the design, implementation, and maintenance of our data architecture and semantic layers. This role combines deep technical expertise in data modeling with strategic thinking about how data can best serve our organization's analytical...

  • Crisil - Semantic Data Modeler

    2 weeks ago

    Mumbai, Maharashtra, India CRISIL LIMITED Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job description : We are seeking a highly skilled Semantic Data Modeler to join our data and AI team. This role will focus on designing and implementing canonical models, ontologies, and taxonomies to enable a unified semantic layer that bridges structured data from multiple silos (RDBMS and other sources) into AI-ready, knowledge-driven assets. The...

  • BI Semantic Layer Expert

    2 weeks ago

    Bengaluru, India C5i Full time

    The position requires a highly seasoned Senior Business Intelligence Consultant with strong expertise across semantic data modelling, data integration, management, delivery, and user-centered information consumption. The ideal candidate will have led multiple enterprise-scale initiatives across the full software development lifecycle, with a primary focus on...

  • BI Semantic Layer Expert

    1 week ago

    Bengaluru, India C5i Full time

    The position requires a highly seasoned Senior Business Intelligence Consultant with strong expertise across semantic data modelling, data integration, management, delivery, and user-centered information consumption. The ideal candidate will have led multiple enterprise-scale initiatives across the full software development lifecycle, with a primary focus on...

  • BI Semantic Layer Expert

    1 week ago

    Bengaluru, India C5i Full time

    The position requires a highly seasoned Senior Business Intelligence Consultant with strong expertise across semantic data modelling, data integration, management, delivery, and user-centered information consumption. The ideal candidate will have led multiple enterprise-scale initiatives across the full software development lifecycle, with a primary focus on...

  • Bi semantic layer expert

    1 week ago

    Bengaluru, India C5i Full time

    The position requires a highly seasoned Senior Business Intelligence Consultant with strong expertise across semantic data modelling, data integration, management, delivery, and user-centered information consumption. The ideal candidate will have led multiple enterprise-scale initiatives across the full software development lifecycle, with a primary focus on...

  • BI Semantic Layer Expert

    1 week ago

    Bengaluru, India C5i Full time

    The position requires a highly seasoned Senior Business Intelligence Consultant with strong expertise across semantic data modelling, data integration, management, delivery, and user-centered information consumption. The ideal candidate will have led multiple enterprise-scale initiatives across the full software development lifecycle, with a primary focus on...