Partner with stakeholders, account teams, and clients to create regular and ad hoc reports and analysis for occupancy planning, operations, client needs, and to support team and account's initiatives
Generate performance dashboards, operational metrics, and compliance reporting, with focus on automation and efficiency
Track KPI performance, identify issues requiring attention, and recommend solutions
Support preparation and presentation development for leadership meetings and translate complex data findings into clear, actionable insights for non-technical audiences
Validate data accuracy before distribution of reports and presentations
Support and improve data quality across operational systems
Monitor data quality metrics and flag and escalate issues requiring attention
Review operational workflows and processes to identify issues impacting data quality
Implement and maintain data governance standards within operational systems as defined by Account and Client Operations and Governance Teams
Develop solutions using native Excel functionality including advanced formulas, pivot tables, Power Query, and conditional logic
Identify opportunities to streamline reporting processes and automate repetitive tasks using Power Automate and advanced Excel capabilities
Develop and maintain Smartsheet and JLL Tracker solutions to streamline processes and enhance productivity
Support development of BI requirements and coordinate with technical teams on development
Build and maintain trusted relationships and partnerships with diverse stakeholders including operations staff, client personnel, IT teams, and leadership
Demonstrate strong communication skills with ability to manage stakeholder expectations across competing demands
Provide guidance to stakeholders and cross-functional teams on data standards, best practices, proper data entry, report interpretation, use of analytical tools, and understanding of data definitions, sources, and appropriate usage
Demonstrate flexibility in managing multiple concurrent requests and adapting to changing client and business priorities
Proactively identify issues before they escalate and respond to time-sensitive analytical requests
Maintain playbooks and standard operating procedures for data collection, validation, and reporting processes
Document data flows, reporting processes, and analytical methodologies to support team coverage, knowledge transfer, and high-quality data maintenance
Support development and maintenance of data dictionaries
Requirements
Bachelor's degree in Business Administration, Finance, Operations Management, Facility Management, or related field; or equivalent combination of education and experience
3-5 years of experience in CMMS/work order applications, Performance Management, Data and Analytics (Corrigo experience preferred)
Experience in a business analyst or similar analytical role
Demonstrated experience working across multiple application systems and business functions in an enterprise environment
Prior experience in facilities, property management, hospitality, customer experience, or related field preferred; experience with occupancy planning data a plus
Strong data analysis proficiency with ability to conduct analyses, translate findings into actionable insights, and maintain high level of attention to detail and accuracy
Advanced native Excel skills including advanced formulas, pivot tables, and Power Query to analyze and manipulate data and generate meaningful reporting efficiently and effectively
Proficiency with Power Automate for workflow automation
Strong skills with developing and maintaining Smartsheet solutions to streamline processes, enhance productivity, and facilitate efficient collaboration within teams
Excellent MS PowerPoint and Word skills; proficient with Outlook and Teams
Experience with or aptitude to quickly learn a wide variety of JLL and client technology platforms, operational tools, and reporting applications with minimal training
Ability to develop reporting and BI requirements and collaborate effectively with BI team preferred
Skilled at utilizing JLL AI tools to automate tasks, generate insights, and increase productivity
Familiarity with database management processes and SQL a plus
Understanding of data quality management, data governance principles, and how they impact business processes preferred