19 Nov
|
Jones Lang LaSalle (JLL)
|
Gurugram
19 Nov
Jones Lang LaSalle (JLL)
Gurugram
Job highlights
- Experience: A bachelors or masters degree in a quantitative,information systems or related discipline,with 3-5 years in data management,data quality or analytics engineering
- Data modelling: Working knowledge of reference and master data,hierarchies,keys and versioned or time-variant data
- A data governance certification,such as DAMA CDMP
- Required Skills Qualifications
Senior Analyst - Research, JLL Business Services (JBS) Role Overview The Market Analysis is the single source of data for Strategy Research teams. It holds third-party market data, internal forecasts, Fair Value inputs and model outputs, all mapped to one common data model of geography, sector and field hierarchies. This role sits between data engineering and the research teams.
You will work with engineers to build the pipelines that load data into Market Analysis, and you will own the quality, consistency and documentation of that data once it is there.
Key Responsibilities
- Ingest and map data into Market Analysis. Work with data engineering to design and run pipelines that load third-party and internal datasets into Market Analysis. Examples include 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. Handle scheduled refreshes and user template uploads.
- Own definitions and classification. 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. Document the judgement calls made at ingest so they stay consistent over time.
- Protect the structure of the database.
Because the platform does not enforce key relationships automatically, run regular integrity checks. These include records with no valid parent, broken or circular hierarchy chains, nodes sitting at the wrong level, duplicate entries and formatting defects such as stray whitespace that silently break joins.
- Automated quality checks.
- Range bands, stale or constant values, missing periods, and accounting-identity checks, for example completions minus withdrawals against the change in stock.
- Detection of restatements and reclassifications by comparing each new load against prior versions held in the database's version history.
- Checks that mandatory classifications are present on every record before data is released to users.
- Monitor and report. Build dashboards covering data freshness, coverage by region and sector, check failures and an open-issue log.
- Work with data owners. Route exceptions to named owners, including regional quant teams, research teams, Securities and the JLL data teams. Track issues to resolution, coordinate changes to hierarchies and definitions, and keep lineage and version history documented.
- Govern access and licensing. Make sure vendor data is used within its license terms and that access follows the firm's information-classification and access-control requirements.
- Keep the data usable downstream. Market Analysis feeds dashboards, Excel downloads,
Databricks data lake modelling pipelines and AI tools that query it directly with SQL. Make sure metadata and definitions are transparent enough that these consumers pull the right data without manual interpretation.
Required Skills Qualifications
- Experience: 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.
- SQL: Advanced, including validation, reconciliation and anti-join checks on large tables, and querying JSON-structured data. PostgreSQL experience preferred.
- Python: For ingestion scripts and automated checks (PySpark is a plus).
- Data modelling: Working knowledge of reference and master data, hierarchies, keys and versioned or time-variant data. Familiarity with hub-and-satellite (Data Vault) patterns is an advantage.
- BI tools: Power BI or Tableau, for operational dashboards.
- Ways of working: Disciplined documentation. Comfortable working with owners across time zones and chasing issues through to closure.
What Sets You Apart
- 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 data sources).
- A data governance certification, such as DAMA CDMP.
- Hands-on experience managing data licensing constraints.
Location
Gurugram, Haryana
Scheduled Weekly Hours
40
Job Tags
- JBS
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Sr Analyst, Research (Gurugram)
🏢 Jones Lang LaSalle (JLL)
📍 Gurugram