Hybrid Pune 5–10 yrs Apply by Oct 30, 2026

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.

Experience

5–10 yrs

Employment Type

Full-time

Openings

1 position

Apply By

Oct 30, 2026

Required Skills

– Analytics Engineer / Data Analyst (Azure Synapse & Data Platform)

Requirement Name Number of open recruitments Experience range Job Location Work mode Per Month Rate Card Amount Mandatory Skill Data 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 governance Data Analyst, Synapse, SQL, Data Lineage and quality, Medallion, Power Bi, Insurance domain expertise

– Analytics Engineer / Data Analyst (Azure Synapse & Data Platform) Role Overview We 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 Skills SQL & 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 layers

Data 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 layers

Analytics 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 products Data Quality & Investigation • Robust 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 Glance

Work ModeHybrid EmploymentFull-time

Experience5–10 yrs

Openings1

LocationPune

DeadlineOct 30, 2026

[ Hiring process ]

What to expect

Four stages, typically completed within 2–3 weeks. We respect your time — every stage has a clear purpose and timely feedback.

- STEP 0130 min

Screening Call

Introductory conversation with our talent team to understand your background and motivations.
- STEP 0260–90 min

Technical Round

Live problem-solving with a senior architect on Salesforce design, integrations, or domain depth.

- STEP 0345 min

Culture Fit

Conversation with practice leadership covering working style, ownership, and how you collaborate.

- STEP 04Within 5 days

Offer

Formal offer with full compensation breakdown, start date, and onboarding plan.

📌 Analytics Engineer / Data Analyst (Azure Synapse & Data Platform) (Pune)
🏢 Techila Global Services
📍 Pune