Business Intelligence Analyst

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.   

Business Intelligence Analyst

Department: Retail Corporate Services
Location: Chicago, IL (Hybrid)
Reports to: Director of Business Intelligence

About JLL

JLL (NYSE: JLL) is a leading professional services firm that specializes in real estate and investment management. JLL shapes the future of real estate for a better world by using the most advanced technology to create rewarding opportunities, amazing spaces and sustainable real estate solutions for our clients, our people and our communities. JLL is a Fortune 500 company with annual revenue of $20.9 billion, operations in over 80 countries and a global workforce of more than 103,000 as of December 31, 2023.

About the Role

Join our growing Business Intelligence team supporting Retail Corporate Services at JLL. This role offers an excellent opportunity to develop expertise in modern analytics and Power Platform solutions while working directly with our Director of BI. You'll contribute to data analytics, reporting, and application development that directly impacts our client operations and decision-making.

This is an ideal position for someone early in their BI career who wants to expand their technical skillset in a dynamic, hands-on environment where you'll have direct mentorship and exposure to cutting-edge business intelligence solutions.

What You'll Do

Reporting & Analytics (Primary Focus):

• Develop and maintain business intelligence reports and dashboards using Power BI, SSRS, and Power BI Report Builder
• Create both internal and external client-facing reports and dashboards including portfolio summaries, site reports, and custom analytics packages
• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources
• Support Tableau reporting as needed
• Ensure data accuracy and reporting quality across all deliverables

Power Platform Development (Growing Responsibility):

• Contribute to PowerApps development for client portals and workflow solutions
• Assist with Power Automate flows for process automation
• Support existing production applications used across multiple client accounts
• Participate in requirements gathering and solution design discussions

Collaboration & Growth:

• Work closely with the Director of BI to understand business requirements and translate them into technical solutions
• Collaborate with stakeholders across Retail Corporate Services
• Apply strong problem-solving abilities to overcome technical challenges independently
• Stay current with emerging technologies and BI best practices

What You'll Bring

Required:

• Strong proficiency in Power BI (dashboard development, DAX, data modeling)
• Solid SQL skills and understanding of relational databases
• Experience with Power BI Report Builder or SSRS
• Strong analytical thinking and problem-solving abilities
• Ability to work independently and find solutions through research and resourcefulness
• Excellent attention to detail and commitment to data quality
• Strong communication skills for both technical and business audiences

Highly Preferred:

• Experience with Power Automate
• Familiarity with other Power Platform tools (PowerApps, Dataverse)
• Experience with Alteryx for data preparation and transformation
• Understanding of data visualization best practices

Nice to Have:

• Python experience
• Background in real estate or retail industries
• Exposure to AI/Copilot integration concepts

Education & Experience:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field, OR equivalent demonstrated experience
• 1-3 years of experience in business intelligence, data analytics, or reporting roles
• Portfolio or examples of BI work (dashboards, reports) preferred

What Success Looks Like

Year One:

• Master our reporting stack and take ownership of regular client deliverables
• Contribute to PowerApps pr