Senior Data Integration Analyst

Jones Lang Lasalle Property Consultants India Pvt Ltd; Gurugram District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Jones Lang LaSalle (JLL) is seeking a Senior Analyst – Energy & Sustainability Data Management to own the integration, quality and analysis of energy, utility and smart-building data across the JouLLe platform. You will transform large datasets into reliable reporting, budgets and insights, while coordinating with vendors, IT and client teams to deliver end-to-end data projects on time.

The role requires 3-5 years in data analysis and data integration, advanced Excel/Power Query skills, and

Qualifications

• Must have 3-5 years of data analysis, integration and migration experience across energy, sustainability, utilities, property or finance.
• Strong analytical skills with the ability to interpret complex data patterns.
• Proficient in Advanced Excel with Power Query for large structured/unstructured datasets.
• Experience with system implementation, administration and analysis.
• Experience with ticketing/issue-tracking tools (e.g., Jira, ServiceNow).
• Excellent stakeholder and vendor management with clear written/verbal communication.
• Project management capability from requirements through delivery.
• Proven track record of process improvement and automation.

Responsibilities

• Integrate smart-building and IoT data into JouLLe platform and ensure reliable data flows.
• Own data quality end-to-end: cleansing, migration, integration, QA, validation across datasets.
• Manage JouLLe structures: buildings, floors, tenants, meters across client sites.
• Produce utility consumption analysis and reporting for internal teams and clients.
• Translate raw data into clear, decision-ready insights and dashboards.
• Analyze energy data patterns to support optimization recommendations and identify anomalies.
• Lead tariff optimization and budget reporting to reduce costs and improve performance.
• Lead requirements gathering, process mapping and system implementation across platforms.
• Collaborate with vendors on scoping, delivery and improvements.
• Deliver end-to-end data projects on time and to specification.
• Provide dashboard access and training to clients and internal stakeholders.
• Support audits and drive automation and efficiency.

Skills

Data analysis

Data integration

Data migration

Advanced Excel / Power Query

System implementation

Stakeholder management

Project management

Documentation & reporting

Education

Degree in Data / IT / Engineering / Sustainability

Tools

Jira

ServiceNow

Salesforce

SharePoint / Teams

Power BI

Yardi Voyager ERP

Job description

Senior Analyst – Energy & Sustainability Data Management

JLL empowers you to shape a brighter way . Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.

Designation - Senior Analyst – Data Integration

Role purpose

The Senior Data Analyst owns the integration, quality and analysis of energy, utility and smart-building data across JLL's JouLLe platform and connected systems. The role turns large, complex datasets into reliable reporting, tariff and budget insight, and process improvements that support our clients' energy and sustainability performance. It combines hands-on data work with project delivery, vendor collaboration and stakeholder engagement, and sits at the intersection of data, technology and sustainability within the JBS business.

Key responsibilities

• Integrate smart-building and IoT solutions, API connectors and data feeds into JLL's energy management and sustainability platform (JouLLe), ensuring reliable, timely data flows.
• Own data quality end to end - data cleansing, migration, integration, QA checks and validation across structured and unstructured energy and utility datasets.
• Manage organizational structures within the JouLLe platform, including buildings (blocks), floors, tenants, and meter assignments across different client sites.
• Produce utility consumption analysis and reporting for internal teams and clients, translating raw data into clear, decision-ready insight.
• Conduct analytical reviews of energy data patterns to support optimization recommendations and identify anomalies.
• Manage utility budget reporting and develop tariff optimisation strategies that reduce cost and improve energy performance.
• Lead requirements gathering, process mapping and system implementation — including platform enhancements and interfaces to finance, accounting and CRM systems.
• Manage and collaborate with platform and smart-building solution vendors on scoping, delivery and ongoing improvements.
• Deliver data and platform projects end to end, on time and to specification.
• Generate and manage client dashboard access via secure links, and provide platform training and reporting to clients and internal stakeholders on a regular basis.
• Support compliance and quality audits, and drive process streamlining, automation and efficiency initiatives.

Essential skills & experience

• Significant experience (typically 3-5 years) in data analysis, integration and migration - typically across energy, sustainability, utilities, property or finance.
• Strong analytical skills with the ability to interpret complex data patterns.
• Advanced Microsoft Excel, including Power Query, for handling large structured and unstructured datasets.
• Experience with system implementation, administration and analysis.
• Ticketing system or issue tracking tool experience (e.g., Jira, ServiceNow, or similar) for managing workflows and contractor coordination.
• Strong stakeholder and vendor management, with clear written and verbal communication.
• Project management capability, from requirements through to delivery.
• Methodical, proactive and independently motivated, with high standards for data quality and accuracy.

Desirable skills & experience

• Experience with energy management, utility billing or consumption platforms.
• Experience with API based data flows, edge devices, IoT systems or building management systems (BMS) Smart building / IoT data / API Connector experience.
• Working knowledge of tariffs, utility budgeting and energy procurement.
• ERP experience (e.g. Yardi Voyager or a comparable property ERP).
• Exposure to CRM (Salesforce).
• Relevant certifications in data analytics.
• A proven track record of process improvement, automation and efficiency gains.
• Technical toolset (familiarity valued) MS Office 365 Excel & Power Query Energy management & utility billing platforms Smart-building / IoT data Ticketing/Issue-tracking systems Salesforce SharePoint / Teams.

Qualifications

• Degree in a relevant discipline (Data / IT, engineering, finance or sustainability), or equivalent practical experience.
• Data analytics or data-foundations certification desirable.

Personal attributes

• Methodical, proactive and detail-oriented, with a quality-first mindset.
• Curious and a continuous learner - comfortable exploring new tools and solutions.
• A collaborative team player who values transparent communication.
• Comfortable working across multiple teams, systems and, where relevant, jurisdictions.

Location: On-site –Gurugram, HR

Scheduled Weekly Hours: 40

Job Tags: Microsoft Power Business Intelligence (PBI)

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services.

Jones Lang LaSalle(“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities.

For more information about how JLL processes your personal data, please view our Candidate Privacy Statement.