JLL empowers you to shape a brighter way.
Our people at JLL and JLL Technologies 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.
Areas of Responsibility:
Business Intelligence Reporting & Analytics:
Perform data management analysis using SQL, including retrieving data from multiple sources, profiling, processing, validating, and migrating data to centralized data platforms.Regularly work in SQL and be able to create views, tables, and develop queries to answer questions.Design, develop and deploy BI solutions, including interactive dashboards in Tableau, sourcing data from internal SQL Server databases, Tableau published data sources, external sources, and leveraging ETL tools when needed. Devise and promote creative data visualizations, reports, tools and dashboards to derive actionable real-time insights to business data pertinent to the audience (SSRS, Tableau, ect.)Validate the calculations and results against known figures, other reports, peer reviews, etc.Develops, executes and monitors simple to moderately complex data management / analytic processes to support ad hoc data and information delivery for assigned projects.Proactively identify opportunities to optimize the performance and efficiency of existing processes/procedures.Translate the business questions and hypothesis into a data analysis plan. Execute the analysis either autonomously or in collaboration with others, depending on what the task calls for. Translate the results of the analysis into actionable recommendations and concrete answers to the business questions.Independently develop, execute, and monitor complex data management/analytic processes to ensure deadlines are met for all assigned deliverables.Financial modeling, analysis and compilation of quantitative dataForecast/trending of performance data.Process mapping and efficiency analysisProvide subject matter expertise for all data related processes and analysis.Data Validation & Governance Assistance:
Leverage industry tools (i.e. Alteryx/SSMS) to assess data quality and assist to resolve data quality problems.Assist the BI and Analytics team and Work Dynamic data governance leads to define and document data remediation activities, processes and quality rules.Work with business line data stewards and other stakeholders to identify remediation actions when Critical data quality falls below the accepted threshold.Validate and cleanup input data, ensure assumptions are correct, manage outliers appropriately, raise any questions or issues with the input data if any exists, and help find the root cause of those issues.Interpersonal/Communication:
Present in front of management groups as the subject matter expert on specific reports or modeling.Excellent presentation skills (verbal and written), Strong understanding of analytic/statistical concepts with the ability to explain them to others.Collaborate with other analysts, data scientists and leaders to get to the best solution for complex questions.Lead problem solving teams to develop recommendations based on data interpretation and analysis to transform behaviors and techniques.Work closely with business stakeholders to understand business questions/requirements/opportunities, and to support the accurate business usage and interpretation of JLL data as well as provide insight/answers to meet the needs of the business.Engage with colleagues and internal customers to reverse engineer existing business processes and identify core business requirements for new information deliverables and data infrastructure.Distribute reports on a regular cadence as defined by the specific task.Minimum Qualifications:
Bachelor’s degree in Business Administration, Information Systems, Data Analytics, Information Technology, Construction or Project Management, or related field.2+ years of BI, business or data analyst experience required ideally in an enterprise environment across multiple application systems and business functions.Must have 2+ years of business experience in Corporate Real Estate, Construction Management, Transaction Management and Lease Brokerage, Property Management or related field.High level of technical skills with demonstrated ability to manage, manipulate, analyze raw data, research data issues, draw conclusions, provide resolution, and develop actionable recommendations.Strong SQL skills with experience developing complex queries and stored procedures.Experience with data visualization tools.Proficiency in ETL processes/tools.Proficient user of Microsoft Office applications (Excel, Word, PPT).Preferred Qualifications:
Experience with Tableau / Alteryx preferred.Exposure to SharePoint Power Applications and SSRS (Report Builder) a plus.Business analysis, consulting/advisory and/or project or client management experience will be a strong plus.Behavioral Traits:
Comfortable with senior managers and clients; can present without undue tension and nervousnessExcellent interpersonal skills - Ability to collaborate across many levelsExcellent oral, written, and presentation communication skills.Knowledge of data lifecycle and maintenance processesExperience with Agile methodologies and framework a plus.Must have demonstrated experience in building and analyzing reports and dashboards along with summarizing the data for business users - Able to take abstract ideas or requirements and work independently towards development of a report/dashboard.Reliable, self-motivated, and self-disciplined individual capable of planning and executing multiple projects simultaneously within a fast-paced environment – works well in a remote environment.Impeccable attention to details and never compromising attitude for data accuracy.Estimated total compensation for this position:
100,000.00 – 120,000.00 USD per yearThe total compensation range is an estimate and not guaranteed. An employment offer is based on an applicant's education, experience, skills, abilities, geographic location, internal equity and alignment with market data .
Location:
Remote –Chicago, ILIf this job description resonates with you, we encourage you to apply, even if you don’t meet all the requirements. We’re 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 contributions
Comprehensive Medical, Dental & Vision Care
Paid parental leave at 100% of salary
Paid Time Off and Company Holidays
JLL Privacy Notice
Jones 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 JLL’s 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.
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.
Pursuant to the Arizona Civil Rights Act, criminal convictions are not an absolute bar to employment.
Pursuant to Illinois Law, applicants are not obligated to disclose sealed or expunged records of conviction or arrest.
Pursuant to Columbia, SC ordinance, this position is subject to a background check for any convictions directly related to its duties and responsibilities. Only job-related convictions will be considered and will not automatically disqualify the candidate.
California Residents only
If you are a California resident as defined in the California Consumer Privacy Act (CCPA) please view our Supplemental Privacy Statement which describes your rights and disclosures about your personal information. If you are viewing this on a mobile device you may want to view the CCPA version on a larger device.
Pursuant to the Los Angeles Fair Chance Initiative for Hiring Ordinance, JLL will consider for employment all qualified Applicants, including those with Criminal Histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
Accepting applications on an ongoing basis until candidate identified.