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.   

Shaping the future of real estate for a better world!

At JLL, we see a Brighter Way forward for our clients, our people, our planet, and our communities. With over 200 years of real estate experience, we are, and always have been, in continual pursuit of brighter ways of working.

We bring to life see a Brighter Way in all that we do by seeking better, smarter, more innovative ways of working. We approach our work in a warmer, more optimistic, and inclusive way.

JLL is a global leader in helping clients envision where people live, work, play, shop, and eat.

What this opportunity involves:

The purpose of this role is to ensure the Finance team are leveraging all available data sets, technology and innovative practices to ensure processes are efficient and reporting is fit for purpose, insightful and current for Finance and the Business. This is achieved via the utilisation of data from finance and non-finance systems, leveraging the Finance Reporting function, and via JLLT partnering.

A snapshot of the role:

Drive efficiencies in key finance deliverables (forecasts and budgeting) via the automation and simplification of processes and interfaces between finance Business Partners and relevant finance systems – Smart view, EPM (budgeting and forecast system), PeopleSoft and the finance data mart.Work with Finance, Business representatives and IT in the development of business focused dashboards using Tableau BI and Power BI, leveraging financial and non-financial data sets from PeopleSoft, CRM, payroll and other systems.Support with key reporting deliverables (financial and non-financial – Annual leave, LSL, Operative performance reports, Revenue tracking) and work with broader Finance Reporting team towards automation of the same.Design, maintain and improve monthly reporting templates using IBM Planning and Analytics for Excel (PAX).Assist in the design and implementation of best practice reporting including system assessment, process design, report design, implementation and stabilisation.Support ad-hoc specialised reporting and data requirements to meet operational, statutory and regulatory deliverables using SQL and the PeopleSoft Finance Data mart and other non-financial data sources (Allocations, revenue, headcount, year-end provisions LSL, etc)Support local delivery of regional and global reporting initiatives lead by the Finance Reporting functionSupport the Finance team with design and maintenance of complex workflows in Alteryx
 

Sound like you? This is what we are looking for:

Advanced Excel Modelling including VBA knowledgeAdvanced BI tool knowledge (i.e. Power BI / Tableau or similar)General systems competency – ability to pick up new systems and changes quicklySound understanding of relational data, joins, primary keys, query logic.Ability to work autonomously, accurately and quicklyAbility to multi-task, manage change requests, be flexible with working hours and prioritise work with hard deadlinesHigh attention to detail with high volume businessExperience with chart field finance system GL structuresStrong reporting and analytical skills

Experience with TM1, Peoplesoft Finance, SQL Server, IBM Planning Analytics / PAX, SmartView, Alteryx, Python preferred. Candidate ideally will have 5 years experience focusing primarily on advanced technical reporting type roles desired

What you can expect from us:

As an organisation, we don’t just accept that we are a place of many different people, but we embrace it, we celebrate it, and we proactively support the needs that difference brings. JLL is committed to equal opportunity and building an inclusive workplace.  This is why, for more than a decade, we continue to rank among the World’s Most Ethical Companies. We support applications from all underrepresented groups, including Aboriginal and Torres Strait Islanders, LGBT+, people with disability and people of all age, religions and race. We are dedicated to offering veterans from all ranks and services a successful civilian career as they transition out of the military. We recognise and appreciate the skills acquired in their service careers as vital and transferable to our workforce.

Apply today, quoting job reference number ATREQ417345 

Please note, although developing relationships with agencies forms a component of the JLL talent acquisition strategy, on this occasion agency submissions will not be accepted.

Location:

On-site –Sydney, NSW

If this job description resonates with you, we encourage you to apply even if you don’t meet all of the requirements.  We’re interested in getting to know you and what you bring to the table!

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.