The JLL Data Analyst interview guide, interview questions, salary data, and interview experiences.

JLL Data Analyst Interview Guide

<p>Getting ready for an Data Analyst interview at JLL? The JLL Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for JLL Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at JLL.</li>
<li>Practice real JLL Data Analyst interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the JLL Data Analyst interview.</p>


Getting ready for an Data Analyst interview at JLL? The JLL Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for JLL Data Analyst roles.
- Gain insights into the Data Analyst interview process at JLL.
- Practice real JLL Data Analyst interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the JLL Data Analyst interview.
        

Overview

JLL Data Analyst Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

JLL Data Analyst Interview Process

<p>As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).</p>

<p>Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.</p>

<p><strong><em>Note:</em></strong> <em>The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.</em></p>

<h3><strong>Example:</strong></h3>

<p><strong>Input:</strong></p>

<p><code>departments</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><code>expenses</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Calculate total and average expenses for each department.

Department Expenses

<p>Let’s say that you’re a data scientist at Robinhood. </p>

<p>How do we measure the launch of Robinhood’s fractional shares program?</p>


<p>Let’s say you are a data scientist at Robinhood.</p>

<p>Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.</p>

<p>Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood’s platform for new users?</p>


Let's say you are a data scientist at Robinhood. 



Robinhood is introducing a program to allow users to buy fractional shares of publically listed companies.



Focusing in on the activity of new users, which of the following metrics would be the LEAST important to keep track of in determining if the program added value to Robinhood's platform for new users?

Fractional Shares Metrics

Fractional Shares

<p>What are time series models? Why do we need them when we have less complicated regression models?</p>


<p>What can happen if a traditional regression model is used on data that has autocorrelation?</p>

What can happen if a traditional regression model is used on data that has autocorrelation?

Why Do We Need Time Series Models? I

<p>Why can't standard regression models be used effectively for data points where current values are influenced by past values?</p>

Why can't standard regression models be used effectively for data points where current values are influenced by past values?

Why Do We Need Time Series Models? II

Why Do We Need Time Series Models?

JLL Data Analyst Interview Questions

Jones Lang LaSalle    Senior Data Analyst    Boulder ,  Colorado     Apply Now    About the role:We are seeking a talented professional to join us as a Senior Data Analyst todevelop and deliver data insights and solutions through your technical andbusiness expertise. The successful candidate will join the Portfolio Insightsteam, responsible for managing and optimizing JLL Client (one of thelargest tech companies in Silicon Valley)'s strategic real estate plans.Responsibilities:Develop and deliver actionable insights and recommendations with theappropriate analytics methodologies and techniques to help Client makeinformed portfolio decisionsGenerate queries, dashboards, and reports using complex datasets from awide range of sourcesCollaborate cross-functionally on advanced analytics projects (predictive/ prescriptive) that solve various business problems at scaleTake ownership of projects end-to-end, from initial requirements and datagathering to user testing and deploymentImplement best practices for knowledge transfer and documentation to achieveinternal consistency and long-term scalabilityCreate action plans to resolve data-related issues and drive qualityimprovement to our data ecosystem over time, including the data itself,the analytical data warehouse and the tools used to analyze and interpretresults and trendsMinimum Requirements:Strong analytical skills and an abundance of intellectual curiosityBachelor's Degree in Math, Statistics, Economics, Computer Science,Engineering, or other quantitative field3+ years of experience in data analysis and data visualizationExperience building and deploying ML modelsProficient in SQL (any dialect), R and PythonExperience working with large codebasesExpertise with spreadsheet-based tools like Google Sheets or ExcelSolution-oriented mindset with the ability to thrive in a fast-pacedenvironment and deliver under pressureStrong communication skills and can clearly communicate business concepts anddata findings to all levels of the organizationExcellent attention to detail, exhibiting the highest standards ofprofessional integrity and work ethicPreferred Qualifications:Corporate Real Estate knowledgeFamiliarity with Google Cloud Platform (e.g., BigQuery, Cloud Storage,App Engine)Track record of making business impact by mining and extracting value fromlarge and disconnected datasetsJLL Is an Equal Opportunity Employer JLL is committed to developing andmaintaining a diverse workforce. JLL strongly believesin equal opportunity extended to all individuals in all aspects of theemployment relationship, including recruitment, hiring, training,promotion, transfer, discipline, layoff,recall and termination without regard to race, color, religion,belief, creed, age, sex, pregnancy or maternity (includingchildbirth and related conditions),family responsibility (e.g. child care, elder care), nationality,ethnic or national origin or ancestry, citizenship, marital status,civil partner status, sexual orientation, genderidentity or expression, transgender status, veteran's status, geneticinformation, trade union membership, social position, political view orstatus as a qualifiedindividual with a disability, protected leave status or any other protectedcharacteristic in accordance with applicable law. The company also endeavorsto make reasonable accommodations for known physical or mental limitations ofotherwise qualified employees and applicants with disabilities unless theaccommodationswould impose an undue hardship on the operation of our business and ensuresthat employment decisions are based only on valid job requirements.#J-18808-Ljbffr<p>by Jobble</p>

<p>Job Description: Area Engineering Manager <br><br>Please note: This is an on-site role not virtual/remote. This position will be based in the Tyson’s Corner/Washington DC or Richmond, VA or Plano TX area. Domestic and Canadian travel will be required as needed. Travel expectation less than 15% time. <br><br>Primary Role <br><br>Primary responsibility for this role is ownership and management of regional engineering operations and maintenance of all building system environments, manage incidents as defined by the client’s incident management program, support and serve as SME for engineering related <br><br>projects, support IFM team as trusted advisor to assure all PM programs are completed on time and efficiently, as well as support the implementation of best in class programmatic initiatives defined by the Engineering Center of Excellence . Ensure maintenance of facility electrical, mechanical, structural, life safety and critical back-up systems are maintained and system up time is maximized. Apprise the owner’s representative of any and all conditions affecting system operations and reliability. The specific areas of responsibility include but are not limited to program management, procedure development and tracking of operational indices. <br><br>Duties And Responsibilities <br><br>Support the site staff to create a high performing team at the assigned campus or region. <br><br>Support building operations through a highly integrated account and engineering team to assure high infrastructure availability and client satisfaction.Drive a cohesive team. Ensure that communication with the engineering and client staff is effective and thorough. <br><br>Job Description <br><br>Drive a strong collaborative relationship with the Site Team, the Account Team, the Client and your Peers.
Foster an environment of partnership.
Maintain and support a Critical Environment Management program reflecting client requirements and industry best practices.
Provide Subject Matter Expertise to the region and account to support improvements in reliability, service delivery and problem management as required.
Develop and implement operational guidelines for client’s critical environments to be implemented by our Engineering teams.
Monitor performance against key performance indicators including uptime and business interruptions.
Monitor PM work order performance across the portfolio, working collaboratively to address issues and ensure completion times meet KPI targets.
Work with the engineers and the client to prioritize work to ensure uptime.
Understand the engineering design and operational aspects of all facility’s systems and equipment. Strong emphasis on UPS, MEP, BAS, high rise environment systems and diverse knowledge of remote office facilities
Must be able to immediately recognize system shortcomings, respond to operational and emergency situations, and provide technical guidance and direction during real time problem management.
Also, must be able to act in a consulting capacity on projects and new design.
Partner with program management team to drive growth programs with engineering staff, fostering a learning environment designed to strengthen engineering succession planning
Ability to effectively communicate in emergency situations, providing guidance where needed in a calm and effective manner
Support operations and capital budget development to ensure equipment, systems and critical environment considerations are met.
Recommend and estimate facility infrastructure repairs and improvements for inclusion in the annual budget.
Responsible for ensuring that staff and vendors working in the Critical Environment space are properly trained and familiar with all critical environment practices and guidelines.
Assure the change control processes are administered to Client standards.
Create a working environment that supports the O&M Continuous Performance Improvement Process which solicits new ideas to reduce risk and cost.
Team with engineering management counterparts in other regions in the sharing of new ideas, methods and processes which support the goals and financial objectives of the Client and provide the highest standard of professionalism, accountability and reliability in support of operational and business objectives.
Provide technical support to Facility and Engineering staff on building related issues or challenges.
Performs other duties as required to meet clients’ objectives and acts in other capacities when required. <br><br>Minimum Requirements <br><br>Bachelor’s Degree in mechanical or electrical engineering preferred or equivalent operations experience equivalent.
Extensive mechanical, electrical, plumbing and fire suppression system knowledge of commercial/critical facilities required.
Data Center/Critical Facility operations experience a plus
8-10+ years in commercial facility operations required
Managerial experience of non direct reports. Ability to get peers on board through vision sharing and trust.
Excellent interpersonal skills, ability to communicate well in both oral and written reports.
Must have fundamental skills in critical systems such as emergency/stand-by generators, automatic transfer switches, uninterruptible power systems, power distribution units, battery systems required.
Must be able to to respond 24/7 as needed outside of time off requests
Ability to manage urgent matters with thought leadership, collective reasoning, and a leadership mentality <br><br>#J-18808-Ljbffr</p>

Regional Engineering Manager page is loaded    Regional Engineering Manager  Apply         remote type  On-site      locations  Newark, DE  Wilmington, DE        time type  Full time      posted on  Posted 2 Days Ago      job requisition id  REQ354106        JLL supports the Whole You, personally and professionally.Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology to our clients. We are committed to hiring the best, most talented people in our industry; and we support them through professional growth, flexibility, and personalized benefits to manage life in and outside of work. Whether youve got deep experience in commercial real estate, skilled trades, and technology, or youre looking to apply your relevant experience to a new industry, we empower you to shape a brighter way forward so you can thrive professionally and personally.The Regional Engineering Manager is responsible for managing all aspects of the Engineering Services system for a property or group of properties, primarily Engineering Services, Asset Management, Operations, Vendor performance, Safety, Reporting, and Customer Satisfaction. In this capacity the Regional Engineering Manager is accountable for the achievement of the Account Engineering Management Plan and all engineering key performance indicators including work performance, reliability, availability, quality, operations and maintenance, vendor management, interface with client counterparts and other key managers within the Account partner organization. This will include hands-on work to complete the necessary work within Jones Lang LaSalle standards and guidelines.The Regional Engineering Manager will identify and implement OM&R Strategies to ensure safe, reliable and efficient client facilities within a geographic territory.The Regional Engineering Manager will execute JLL Quality control audits and inspections conducted throughout the territory and deficiency reports provided to supervisors.The Regional Engineering Manager will provide technical assistance, training and support as requested and required including but not limited to Root Cause Analysis, CMMS administration, Asset management and vendor management and provide hands-on support of teams within a territory as needed or directed.The Regional Engineering Manager will perform other work to include hands-on repair & maintenance work on mechanical, electrical, plumbing, building automation systems, card access systems, door & gates systems, building envelope systems, grounds and parking lots, interior finish systems, lighting systems, and various other R&M tasks associated with operation of a commercial property.Area of ResponsibilityManagementEnsure client satisfaction with client Facilities/Property Management by providing a seamless interface into client real estate organizationAbility to effectively manage diverse relationships with team members, contractors, client, and customers.Ability to schedule and prioritize work for themselves and others to maximize efficiency and minimize overtime.Ability to engage others to gain cooperation and teamwork.Conduct performance counseling and performance management of direct reportsDay to day supervision of issues as they ariseSafetyDemonstrate leadership, responsiveness and creativityComprehensive knowledge of Safe Work practices especially regarding energized work, working at heights and confined spaces.Ability to recognize, assess and mitigate or eliminate risk.Ability to understand and use proper PPE for associated tasksTrainingEvaluate, train, teach and coach a work force of Lead Engineers, Facility Engineers, and Maintenance Technicians as requested by supervisors.Host virtual and live presentations.Establish training goals for each team memberDevelops Best practicesOperations, Maintenance and Repair  OM&RDevelop and implement innovative programs, processes and procedures that reduce short and long term operating costs and increase productivity.Ensuring compliance with work flow managementFully implement all standard operating systems and practices, including the following: Implementation of the CMMS, 360 Facility Preventive Maintenance System or similar. Maintain team standards for uniforms and appearanceReads and understands the applicable Service Level AgreementsEnsures appropriate follow up with customersSeeks to continuously improve processes, systems and overall client satisfactionProvides   direction/information   to vendors, facilities staff and service providers as required to ensure excellent   coordination/execution   of work within client environment with minimal disruptionPerform preventive maintenance and repair service work on Building Systems and equipment, and various other systems to maintain the properties in peak operational condition.Customer ServiceRecognize the authority and objectives of the client.Conduct all activities in a businesslike, competent, and professional manner.Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfactionAny and all other duties and tasks assigned.MINIMUM REQUIREDPREFERREDEducation/trainingCritical Systems experienceElectrical Engineering DegreeVocation degree program, apprenticeship.Years of relevant experience10 Years Trade7 - 10 years engineeringSkills and knowledgeApplicable codes, laws and regulationsCritical SystemsCritical LoadsOther abilitiesAbility to effectively use computers and computer programs (including use of Microsoft Office Suite)Skill in use of the internet to navigate to and use web based applications.Ability to use handheld electronic devices (PDA, Blackberry, cell phone, etc.)Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammarGood interpersonal and communication skills, both written and verbalPossess excellent communications skills, both written and verbal.Ability to create, modify and edit processes, procedures and reports.Location:On-site Newark, DE, Wilmington, DE If this job description resonates with you, we encourage you to apply, even if you dont meet all the requirements. Were interested in getting to know you and what you bring to the table!Personalized benefits that support personal well-being and growth:JLL recognizes the impact that the workplace can have on your wellness, so we offer a supportive culture and comprehensive benefits package that prioritizes mental, physical and emotional health. Some of these benefits may include:401(k) plan with matching company contributionsComprehensive Medical, Dental & Vision CarePaid parental leave at 100% of salaryPaid Time Off and Company HolidaysFlexible and Remote Work Arrangements may be availableJLL Privacy NoticeJones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLLs recruitment process. We           endeavour           to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.For more information about how JLL processes your personal data, please view our Candidate Privacy Statement    .For additional details please see our career site pages for each country.For candidates in the United States, please see a full copy of our Equal Employment Opportunity and Affirmative Action policy here .This position may require you to be fully vaccinated against COVID-19. If required, youll be asked to provide proof that youre fully vaccinated upon your start date. Youre considered fully vaccinated two weeks after you receive the second dose of a two-dose vaccine series (e.g., Pfizer or Moderna) or two weeks after a single-dose vaccine (e.g., Johnson & Johnson/Janssen). Failure to provide proof of vaccination may result in termination.Jones Lang LaSalle (JLL) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process  including the online application and/or overall selection process  you may       contact us at Accommodation Requests      . This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us    page > I want to work for JLL.Accepting applications on an ongoing basis until candidate identified.Activate your Personal JLL Job Alerts   Activate your Personal Job Alerts  now and receive opportunities as soon as they are advertised.At JLL, we give you the opportunity, knowledge and tools to own your success, because we value what makes each       ofusunique.       We help ourpeople thrive, grow meaningful careersand find a place where they       belong.Together,       we strive to be exceptional and shape a better world.For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM. JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated. For further information, visitjll.com .#J-18808-Ljbffr<p>by Jobble</p>

JLL Data Analyst Interview Guide

Overview

JLL Data Analyst Salary

JLL Data Analyst Interview Process

JLL Data Analyst Interview Questions

JLL Data Analyst Jobs