Business Data Analyst (BDA) – Insurance Data

Experience 9 - 12 years

No. of Positions 4

Duration 6-12 months

Location : Noida

Work Mode Hybrid • Contract

Start Date 31 Jul 2026

Primary Skills P&C; Insurance Domain, Medallion architecture, Advanced SQL, Data Vault,

XML/JSON, STTM

Key Responsibilities

- Elicit and document data requirements from QBE SMEs, product owners, and reporting/actuarial consumers; run structured workshops across time zones.
- Profile and analyse source system data (SQL against SQL Server/Oracle/Databricks) to assess quality,

completeness, grain, and edge cases before build.
- Author precise source-to-target mapping (STM) specifications: field-level mappings, transformation/derivation logic, filter/join rules, SCD behaviour, reject/exception handling, reference-data lookups.
- Define data quality rules and acceptance criteria per dataset; agree reconciliation and control totals with business and testing teams.
- Maintain the business glossary and metadata; align terminology with the Data Modeler's entities and governance definitions.
- Support engineering during build; support SIT/UAT with test-scenario design and defect triage.
- Perform impact analysis for change requests and source-system changes; keep STMs versioned and current.




- Produce clear analysis artefacts and walkthroughs for onshore stakeholders; convert ambiguous asks into documented decisions.

Must-Have Skills & Experience
- 9–12 years total with strong recent experience as a data/business analyst on data warehouse or lakehouse programmes.
- Advanced SQL for profiling/validation on large datasets (window functions, aggregation reconciliation); comfort querying Databricks (Spark SQL).
- Proven authorship of source-to-target mappings and transformation specifications consumed by engineering teams.
- Insurance domain depth — P&C; preferred: policy & claims lifecycle, premium/exposure, bordereaux/reinsurance concepts, KPI/reporting needs.
- Data quality analysis: rule definition, exception analysis, reconciliation approaches.
- Agile delivery with Jira/Confluence discipline.
- Excellent stakeholder management and written documentation — specs a current engineer can build from without a meeting.

Good to Have

- Databricks/PySpark familiarity; Power BI semantic models; actuarial data marts.
- Guidewire/Duck Creek or London-market data structures; ACORD standards.
- Python/pandas for ad-hoc analysis; Alteryx; data catalog tools (Purview/Collibra).
- Insurance certifications (III/CII/AINS) a plus.

Qualification: Bachelor's degree; business, finance, statistics, or computer science preferred.

📌 Senior Business Data Analyst (BDA) – Insurance Data (Noida)
🏢 Resource Bazaar Technologies
📍 Noida