J

Senior Analyst, Research

jll
NewPosted today

LOCATION

Gurugram · Onsite

EXPERIENCE

3 - 5 Years

TYPE

FullTime

SKILLS REQUIRED

Data GovernanceData QualityData ModelingSQLPythonPower BiData PipelinesMetadata Management

Job description

Overview

Senior Analyst in Research at JLL Business Services, responsible for the data pipelines, classification, quality and governance of the Market Analysis database that serves as the single source of data for Strategy & Research teams.

What you'll do

  • Design and run pipelines with data engineering that load third-party and internal datasets into Market Analysis, such as Oxford Economics, MSCI, NCREIF, Altus, Green Street, JLL data and Fair Value input files.
  • Map each dataset to the data model, assigning every value of its required classifications, and handle scheduled refreshes and user template uploads.
  • Maintain the data dictionary, the sector classification and its cross-walks to external taxonomies, and the multi-level geography hierarchy.
  • Decide with research owners when a third-party category maps to an existing entry and when it needs a new one, and document judgement calls made at ingest.
  • Run regular integrity checks for records with no valid parent, broken or circular hierarchy chains, nodes at the wrong level, duplicate entries and formatting defects.
  • Build automated quality checks covering range bands, stale or constant values, missing periods, accounting-identity checks, restatement and reclassification detection against version history, and mandatory classification checks before release.
  • Build dashboards covering data freshness, coverage by region and sector, check failures and an open-issue log.
  • Route exceptions to named owners, track issues to resolution, coordinate hierarchy and definition changes, and keep lineage and version history documented.
  • Govern vendor data use within license terms and ensure access follows the firm's information-classification and access-control requirements.
  • Keep metadata and definitions clear enough for dashboards, Excel downloads, Databricks pipelines and AI tools querying via SQL to pull the right data.

What you'll need

  • A bachelor's or master's degree in a quantitative, information systems or related discipline, with 3–5 years in data management, data quality or analytics engineering.
  • Advanced SQL, including validation, reconciliation and anti-join checks on large tables, and querying JSON-structured data.
  • Python for ingestion scripts and automated checks.
  • Working knowledge of reference and master data, hierarchies, keys and versioned or time-variant data.
  • Power BI or Tableau for operational dashboards.
  • Disciplined documentation, and comfort working with owners across time zones and chasing issues through to closure.

Nice to have

  • PostgreSQL experience.
  • PySpark.
  • Familiarity with hub-and-satellite (Data Vault) patterns.
  • Experience with Databricks or Unity Catalog, and with data-validation frameworks.
  • Git.
  • Familiarity with real estate or economic data sources and their classification systems, for example MSCI, NCREIF or Altus.
  • A data governance certification, such as DAMA CDMP.
  • Hands-on experience managing data licensing constraints.

Details

  • On-site, Gurugram, Haryana, India.
  • Scheduled weekly hours: 40.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Senior Analyst, Research