Junior Semantic Modeler

Junior Semantic Modeler & SQL Data Engineer

Overview

We are seeking a Junior Semantic Modeler & SQL Data Engineer to shape the next generation of AI enabled data products. This is a future-facing role where you will architect and optimize semantic models, design robust data pipelines, and build knowledge graphs using agentic Retrieval-Augmented Generation (RAG) techniques. Your work will enable intelligent data products, actionable BI dashboards, and self-serve analytics for critical business decisions. You will drive a modern, AI-assisted development workflow — moving beyond traditional data engineering to leverage the power of generative AI, advanced SQL, and agentic tools across batch, streaming, and cloud-native platforms.

What You’ll Do

Data Modeling & Engineering

• Design and implement semantic data models governed by Domain-Driven Design (DDD) principles to support discoverability, self-service analytics, and scalable data product delivery.
• Build data transformation workflows using SQL-based stream processing with Apache Flink for real-time analytics and low-latency data products.
• Develop SQL-based batch and micro-batch data pipelines using Apache Spark to process largescale
• datasets efficiently.
• Engineer robust, performant pipelines using BigQuery, Snowflake, and Databricks SQL—leveraging cloud-native best practices for storage, compute, and data engineering automation.
• Apply Data Mesh and Lakehouse architectural patterns to drive domain-oriented ownership and high data quality.
• Develop and maintain user-defined metadata layers and semantic catalogs for governed querying and consistent reporting.
• Optimize schema design, indexing, and data storage for both analytical and transactional performance across streaming and batch environments.

Agentic AI, Knowledge Graphs & Automation

• Rapidly upskill on RAG-based knowledge graph creation and fine-tuning, applying the latest AI models to accelerate semantic discovery.
• Rely on AI-assisted development tools (e.g., GitHub Copilot, Claude Code, Cursor, Aider) for code generation, documentation, and optimization—minimizing hand-coding while maximizing productivity.
• Automate ETL/ELT workflows, implement robust data validation, and establish CI/CD practices for data pipelines, including regression and anomaly testing.
• Integrate and optimize stream, batch, and micro-batch workflows to ensure seamless, end-to-end data processing and analytics delivery.

Data Product & BI Delivery

• Design, version, and deliver data products with clear contracts and lineage, supporting reusable and testable analytics building blocks.
• Develop advanced BI reports and dashboards (using tools like Tableau, Power BI, Looker, Superset) that surface key data-driven insights and metrics.
• Ensure data integrity, quality, and consistency throughout the lifecycle via automated tests, validation frameworks, and detailed documentation.
• Monitor, profile, and proactively improve pipeline reliability, performance, and scalability—across real-time, batch, and micro-batch environments.

Leadership, Collaboration & Mentoring

• Partner with data scientists, business analysts, and product teams to co-create high-impact, user-centric solutions.
• Mentor junior engineers on advanced SQL, semantic modeling, AI-augmented workflows, and modern data processing paradigms (streaming, batch, micro-batch).
• Communicate complex technical concepts clearly across technical and non-technical audiences.

What Sets You Apart

Qualifications

• Bachelor’s in Computer Science, Software Engineering, or a related field from a top-tier engineering college
• 2+ years in data engineering or data product roles, with deep experience in SQL, semantic modeling, and pipeline design.
• Hands-on expertise in RDBMS, cloud data platforms (AWS, Azure, GCP), and cloud data warehouses (BigQuery, Snowflake, Databricks).
• Proven experience in SQL-based stream processing (Apache Flink), batch/micro-batch processing (Apache Spark), and cloud-native SQL data engineering.
• Proficiency in Python (preferred) or Java/Scala for data transformation and automation.
• Familiarity with big data (Spark, Kafka, Hadoop) and NoSQL (MongoDB, Cassandra, Redis) is a plus.
• Proven experience using AI code assistant tools for productivity and workflow acceleration.
• Strong foundation in data architecture, version control, data governance, and metadata management.

Core Competencies

• Integrity, sound judgment, and a relentless commitment to data quality and innovation.
• Strategic, adaptive thinker with the ability to translate complex business needs into actionable data solutions.
• Excellent communicator, influencer, and collaborator across diverse technical and business teams.
• Self-starter with a sense of urgency, ownership, and drive to deliver high-impact results.

Skills & Mindset

• Advanced SQL mastery: Joins, CTEs, window functions, analytical functions, UDFs, stored procs, query optimization.
• Experience with SQL-based stream processing (Flink), batch/micro-batch (Spark), and cloud SQL data platforms (BigQuery, Snowflake, Databricks) is a Plus.
• Semantic modeling: Ability to abstract, organize, and represent data for business meaning and usability.
• Metrics & dashboard development: Track record building high-value data-driven insights and reporting products.
• Critical thinking, analytical rigor, and attention to detail.
• Continuous learner—excited to work at the cutting edge of data and AI.

Join us to architect intelligent, agentic data solutions that power smarter decisions—across streaming, batch, and cloud data environments.

Location & Travel:

• Coimbatore/Chennai/Bangalore

About Steerwise:

Steerwise is a value-focused intellectual products & experiential services firm, providing business technology strategy, creative solution design, & software product delivery for organizations across industries, sectors, & geographies. We bring strategy advisory, solution design, software product development, and system operation competencies to actualize transformation & optimization endeavors. We work with clients to build capabilities that empower organizations to create digital customer experience, harmonize and monetize data assets, and exploit modern technologies for gaining competitive advantage by leveraging our Steerwise Vae™ intellectual capital. Our Business Value First™ culture makes us a valuable partner for our clients and an inspiring place to work for our employees.