JB001891 Analytics Engineer / Data Analyst (Azure Synapse & Data Platform) Pune · Hybrid

Techila Global; Pune District; Hybrid; INR 2,232,000 - 3,348,000; Full time

Job summary

Techila Global is seeking an Analytics Engineer / Data Analyst to join our enterprise data platform team in Pune. This role focuses on validating data products, tracing lineage, and surfacing insights beyond traditional reporting.

You will work closely with senior data engineers and the solution architect to ensure data completeness, accuracy, and governance across the platform. The ideal candidate has 5–8+ years of experience, expert SQL skills, and familiarity with Azure Synapse, Delta Lake,

Qualifications

• 5–8+ years of experience in data analyst/analytics engineering or BI engineering roles with strong technical focus.
• Experience with complex SQL, data profiling, lineage, and quality assessments.
• Familiarity with Azure Synapse SQL Pool/Serverless SQL, Delta Lake, Parquet and Data Lake Storage Gen2.
• Knowledge of medallion/lakehouse architecture and data governance concepts.
• Experience with Power BI or similar BI tools and data models.

Responsibilities

• Interrogate foundational data products across the platform to assess completeness and consistency.
• Write complex SQL queries across raw to conformed datasets.
• Trace data lineage end-to-end across layers and identify gaps or discrepancies.
• Document findings as gap analyses and data quality assessments for engineers and business stakeholders.
• Collaborate with data engineers and architects to inform platform re-engineering and migration decisions.
• Validate business logic in transformation layers by comparing expected vs. actual outputs.

Skills

SQL

Azure Synapse

Data profiling

Data lineage

Data quality

Delta Lake

CDC/SCD

Power BI

Data governance

Medallion architecture

Tools

dbt

Azure Purview

Unity Catalog

Job description

# Analytics Engineer / Data Analyst (Azure Synapse & Data Platform)Join Techila's team of Salesforce experts. We build senior-led transformations that deliver measurable outcomes for clients worldwide.Apply Now →← All JobsExperience5–10 yrsEmployment TypeFull-timeOpenings1 positionApply ByOct 30, 2026## Required Skills– Analytics Engineer / Data Analyst (Azure Synapse & Data Platform)## Job DescriptionRequirement Name Number of open recruitments Experience range Job Location Work mode Per Month Rate Card Amount Mandatory SkillData Analyst 1 5-8+ TVM / Pune Hybrid 2L-3L Expert SQL, Data profiling, Data lineage tracing, Gap/discrepancy analysis, Medallion/Lakehouse architecture, Azure Synapse (SQL Pool/Serverless SQL), Azure Data Lake Storage Gen2, Delta Lake/Parquet, CDC/SCD patterns Data quality frameworks, Data governanceData Analyst, Synapse, SQL, Data Lineage and quality, Medallion, Power Bi, Insurance domain expertiseJob Description – Analytics Engineer / Data Analyst (Azure Synapse & Data Platform)Role OverviewWe are looking for a technically strong Analytics Engineer / Data Analyst to join an existing enterprise data platform team. This is not a traditional reporting analyst role — we need someone who is equally comfortable writing complex SQL and understanding the underlying data architecture as they are surfacing insights. The primary focus will be on interrogating foundational data products, tracing data lineage across platform layers, and identifying gaps, inconsistencies, and quality issues in what has been built. This person will act as a critical bridge between the engineering team and the business, helping to validate what the platform produces and surface what is missing or incorrect.---Key Responsibilities• Interrogate foundational and use case data products across the platform 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: understand where data originates, how it is transformed at each layer, and what reaches the consumption layer• Identify data gaps, anomalies, unexpected transformations, and discrepancies between source systems and downstream data products• Document findings clearly — translating technical observations into structured gap analyses and data quality assessments that both engineers and business stakeholders can act on• Work closely with senior data engineers and the solution architect to provide ground-level data evidence that informs re-engineering and migration decisions• Validate business logic embedded in transformation layers by comparing expected versus actual outputs across datasets• 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 against what the platform currently delivers• Contribute to the development of semantic views, analytical datasets, and self-serve reporting assets where required---Core Technical SkillsSQL & Data Querying• Expert-level SQL — able to write complex analytical queries involving 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 — comfortable working with partitioned tables, Delta tables, and distributed query engines• Experience with Azure Synapse SQL Pool and/or Synapse Serverless SQL• Ability to reverse-engineer data transformations by reading query outputs and comparing across layersData Platform & Architecture Literacy• Solid understanding of medallion / lakehouse architecture (Raw / Harmonized / Conformed / Consumption) — able to navigate a multi-layer platform and understand the purpose and content of each layer• Familiarity with data modelling concepts: surrogate keys, slowly changing dimensions, denormalization, conformed dimensions• Understanding of CDC and SCD patterns and their impact on historical data• Ability to read and interpret data pipeline logic — not necessarily build it, but understand what a pipeline is doing and whether the output is correct• Experience working with Azure Data Lake Storage Gen2 and Delta Lake format (Parquet, Delta tables)• Familiarity with Azure Synapse Analytics environment — navigating SQL Pools, Spark outputs, and storage layersAnalytics Engineering• Experience building or contributing to semantic layers, data models, or analytical datasets consumed by BI tools• Familiarity with dbt or similar analytics engineering frameworks is a plus• Ability to translate business questions into well-structured analytical data models• Experience with Power BI or equivalent BI tools — understanding of how semantic models consume underlying data productsData Quality & Investigation• Strong analytical mindset — able to form hypotheses about data issues, design SQL-based tests to validate them, and clearly document conclusions• Experience with data profiling: null rates, cardinality, referential integrity checks, distribution analysis• Ability to compare datasets across systems or layers and surface meaningful discrepancies• Familiarity with data quality frameworks and rule-based validation approaches---Nice to Have• Exposure to Python (Pandas / PySpark) for data exploration beyond SQL• Familiarity with Azure Purview or Unity Catalog for data cataloguing and lineage• Experience with dbt for analytics engineering and data model documentation• Exposure to data observability or monitoring tooling• Background in financial services or insurance data (policy, sales, CRM data structures)---Experience & Profile• 5–8+ years of experience in a data analyst, analytics engineering, or BI engineering role with a strong technical focus• Demonstrated ability to work directly with complex, undocumented, or legacy datasets and make sense of them independently• Comfortable operating in ambiguity — this role requires curiosity and persistence when the data does not behave as expected• Strong documentation skills — able to produce clear gap analyses, data dictionaries, and investigation findings that non-technical stakeholders can understand• Collaborative and inquisitive — works well embedded within an engineering team while also engaging directly with business users• Detail-oriented without losing sight of the bigger picture — able to flag granular data issues in the context of platform-level quality and completeness• Experience working in regulated or enterprise-scale environments (financial services a plus)### At a GlanceWork ModeHybridEmploymentFull-timeExperience5–10 yrsOpenings1LocationPuneDeadlineOct 30, 2026Apply for this Role →[ Hiring process ]## What to expectFour stages, typically completed within **2–3 weeks**. We respect your time — every stage has a clear purpose and timely feedback.1. STEP 0130 min ### Screening Call Introductory conversation with our talent team to understand your background and motivations.2. STEP 0260–90 min ### Technical Round Live problem-solving with a senior architect on Salesforce design, integrations, or domain depth.3. STEP 0345 min ### Culture Fit Conversation with practice leadership covering working style, ownership, and how you collaborate.4. STEP 04Within 5 days ### Offer Formal offer with full compensation breakdown, start date, and onboarding plan.Apply