Excel Pivot Table Remote Jobs in Hawaii (NOW HIRING)

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.
JLL has a great opportunity to join our growing Property Management team in Hawaii. This position can be remote (Eventually could turn into Hybrid or In-Office) but the person must live on O'ahu.
What your day-to-day will look like:

• Prepare monthly, quarterly, and annual financial statements and management reports for assigned client properties, ensuring accuracy, timeliness, and compliance with GAAP and client-specific requirements
• Process accounts payable and accounts receivable transactions, including invoice coding, payment processing, tenant billing, and collections follow-up to maintain healthy cash flow
• Perform monthly account reconciliations for balance sheet accounts, including bank statements, tenant accounts, prepaid expenses, and accruals, investigating and resolving discrepancies promptly
• Coordinate and support annual budget preparation and quarterly forecast processes, working closely with property managers to develop accurate financial projections and variance analyses
• Serve as the primary finance contact for property management teams and client stakeholders, responding to inquiries, explaining financial results, and providing analytical support for decision-making
• Maintain organized documentation and filing systems in accordance with client requirements and JLL policies, ensuring audit readiness and proper support for all financial transactions
• Monitor compliance with lease agreements, service contracts, and client accounting policies, identifying issues proactively and collaborating with operations teams to resolve discrepancies

Required Qualifications:

• Bachelor's degree in Accounting, Finance, or related field from an accredited institution preferred
• Minimum of 5 years of progressive accounting experience, preferably in property management, real estate, professional services environment, or shopping center experience is a plus
• Strong working knowledge of Generally Accepted Accounting Principles (GAAP) and financial statement preparation
• Proficiency with accounting software systems (Yardi, MRI, or similar property management platforms strongly preferred) and advanced Microsoft Excel skills including pivot tables, VLOOKUP, sorting/subtotals and financial modeling
• Demonstrated ability to manage multiple properties or accounts simultaneously while meeting strict monthly close deadlines in a fast-paced environment
• Excellent analytical skills with proven ability to investigate variances, identify trends, and present financial information clearly to non-financial stakeholders
• Strong written and verbal communication skills with a client service orientation and ability to build productive working relationships across teams

Preferred Qualifications:

• CPA preferred but not required
• Previous experience in commercial real estate accounting, including familiarity with CAM reconciliations, percentage rent calculations, and lease accounting concepts
• Experience with large-scale property management organizations
• Knowledge of lease administration principles and ability to interpret lease documents for accounting purposes
• Familiarity with financial reporting tools and business intelligence platforms for enhanced data visualization and reporting
• Experience supporting annual audits and working with external auditors to provide documentation and respond to audit requests
• Exposure to process improvement initiatives and ability to identify opportunities for automation or enhanced efficiency in accounting workflows

This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship.
Estimated compensation for this position:
90,000.00 - 105,000.00 USD per year
This range is an estimate and actual compensation may differ. Final compensation packages are determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations.
Location:
On-site -Honolulu, HI, Kapolei, HI
If 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
• Early access to earned wages through Daily Pay

At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing.
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 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 email us at HRSCLeaves@jll.com. 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.