Analytics Engineer / Data Analyst Azure Synapse & Data Platform

Analytics Engineer / Data Analyst Azure Synapse & Data Platform Claidroid Technologies Pvt. Ltd. Location: Thiruvananthapuram, Kerala / Pune, Maharashtra Work Mode: Hybrid Experience: 58+ years Engagement: Full-time opportunity Claidroid Technologies Pvt. Ltd. is hiring an experienced Analytics Engineer / Data Analyst Azure Synapse & Data Platform to join an existing enterprise data platform team. At Claidroid Technologies, our name is derived from Cloud, AI, and Automation the three pillars that define our innovation-driven approach to digital transformation. Claidroid Technologies is a global digital transformation and technology services partner built by IT professionals with over three decades of industry experience, with a presence across India, Europe, and the USA. We help enterprises modernize platforms, improve operational efficiency, strengthen governance, and accelerate business outcomes. We work with leading enterprises in regulated industries, delivering scalable, high-quality technology solutions with a strong focus on governance, quality assurance, and business alignment. Role Overview As an Analytics Engineer / Data Analyst, you will join an existing enterprise data platform team and play a key role in validating, analysing, and improving data products across the platform. This is not a traditional reporting analyst role. We are looking for someone who is equally comfortable writing complex SQL, understanding data architecture, tracing data lineage, and identifying data gaps, inconsistencies, and quality issues. You will act as a critical bridge between engineering teams and business stakeholders, helping validate what the platform produces and surfacing what is missing, incorrect, or inconsistent. The role requires strong technical analysis skills, curiosity, persistence, and the ability to work with complex, undocumented, or legacy datasets in an enterprise-scale environment. Key Responsibilities Interrogate foundational and use-case data products to assess completeness, correctness, and consistency. Write complex SQL queries to explore, profile, and validate data across multiple layers, from raw ingestion through to conformed and consumption datasets. Trace data lineage end-to-end, understanding where data originates, how it is transformed, and what reaches the consumption layer. Identify data gaps, anomalies, unexpected transformations, and discrepancies between source systems and downstream data products. Validate business logic embedded in transformation layers by comparing expected versus actual outputs across datasets. Reverse-engineer data transformations by reading query outputs and comparing results across platform layers. Read and interpret pipeline logic to understand what the pipeline is doing and whether the output is correct. Document findings clearly through structured gap analyses, data quality assessments, data dictionaries, and investigation notes. Work closely with senior data engineers and solution architects to provide ground-level data evidence for re-engineering and migration decisions. Support data governance efforts by profiling datasets, cataloguing findings, and contributing to data quality rule definitions. Collaborate with business and analytics stakeholders to understand expected data behaviour and reconcile it against platform outputs. Translate business questions into well-structured analytical data models. Contribute to semantic views, analytical datasets, and self-serve reporting assets where required. Key Requirements 58+ years of experience in a data analyst, analytics engineering, or BI engineering role with a strong technical focus. Expert-level SQL, including multi-table joins, window functions, aggregations, CTEs, and recursive logic. Strong ability to profile and explore unfamiliar datasets without prior documentation. Experience querying large-scale data platforms, including partitioned tables, Delta tables, and distributed query engines. Experience with Azure Synapse SQL Pool and/or Synapse Serverless SQL. Solid understanding of medallion / lakehouse architecture, including Raw, Harmonized, Conformed, and Consumption layers. Familiarity with data modelling concepts such as surrogate keys, slowly changing dimensions, denormalization, and conformed dimensions. Understanding of CDC and SCD patterns and their impact on historical data. Experience working with Azure Data Lake Storage Gen2 and Delta Lake format, including Parquet and Delta tables. Familiarity with Azure Synapse Analytics environments, including SQL Pools, Spark outputs, and storage layers. Experience building or contributing to semantic layers, data models, or analytical datasets consumed by BI tools. Experie Analytics Engineer / Data Analyst Azure Synapse & Data Platform Claidroid Technologies Pvt. Ltd. Location: Thiruvananthapuram, Kerala / Pune, Maharashtra Work Mode: Hybrid Experience: 58+ years En