Entry Level Data Analysis Excel Jobs in Colorado

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 peopleand empowering them tothrive, 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.

The Debt Management System (DMS) is a SaaS platform that serves institutional borrowers and lenders in the commercial real estate debt market. It manages loan data, financial calculations, covenant monitoring, and reporting across complex CRE debt structures.

As a DMS Analyst - Quality & Data, you will own end-to-end validation of new features and system changes - testing against defined Acceptance Criteria, surfacing defects, and ensuring calculations are accurate from first principles before they reach clients. Alongside this, you will support data integrity and system configuration tasks that keep the platform running cleanly day to day.

This is an excellent opportunity for a finance, real estate, or accounting professional who is analytical, detail-oriented, and technically capable, and who wants to deepen their understanding of sophisticated debt structures, hedging instruments, and financial modeling in a product-driven environment. You will work directly alongside product management, engineering, and client success teams and will receive hands-on training in advanced topics including cashflow modeling, AI development, and derivative valuations.

• Review and validate new features and system changes against Acceptance Criteria defined in Azure DevOps (ADO) prior to production release
• Execute functional, exploratory, and regression testing across DMS in a dedicated test environment, covering calculations, data workflows, navigation, and usability
• Independently replicate system calculations - including loan cashflows, covenant metrics, and effective interest rates - from first principles to confirm accuracy
• Log defects, test results, and observations directly in ADO with sufficient detail for engineering triage; ensure visibility for Product Management
• Validate that UI changes, page layouts, and permission configurations behave correctly across relevant user profiles and data scenarios
• Assist with release readiness reviews and provide a structured sign-off on tested features

• Maintain and validate data records across loans, investments, funds, and properties, ensuring configurations are applied correctly and flagging inconsistencies
• Review and reconcile client-facing data reports, focusing on loan balances, hedge activity, effective interest rates, and related financial metrics
• Maintain field mappings used to load financial information from client templates
• Modify UI page layouts to support new features or evolving client data needs
• Provision new feature access across user groups and profiles as releases are deployed
• Add new property financial field mappings as new data types or asset classes are introduced
• Validate system data accuracy on an ongoing basis as the platform evolves
• Review and investigate report discrepancies flagged by internal teams or clients
• Assist with change management communications and materials related to new releases

• Background in finance, real estate, accounting, or a related analytical discipline
• Ability to read and reconstruct financial calculations independently - if given a loan term sheet, you can build the cashflow schedule in Excel without being walked through it step by step
• Strong attention to detail and a methodical approach to identifying discrepancies or unexpected behavior
• Comfort working with structured data in spreadsheets; able to spot errors, trace formulas, and reconcile outputs
• Clear written communication - you can describe a defect, a data issue, or a test result in a way that is unambiguous and actionable
• Organized and self-directed; able to manage a test cycle against defined criteria with limited supervision

• Familiarity with CRE debt concepts: loan structures, covenants, LTV/DSCR/debt yield metrics, floating rate mechanics
• Experience with or exposure to Salesforce as an end user or administrator
• Experience using Azure DevOps, Jira, or similar tools for issue tracking
• Understanding of interest rate hedging products (caps, swaps) at a conceptual level
• Prior involvement in software testing, UAT, or data validation in a financial or real estate context

This role is explicitly structured to develop your technical finance skills and cross-functional collaboration. Working alongside product, engineering, and quant professionals, you can expect to build expertise in:

• Loan structuring and complex cashflow modeling across CRE debt structures
• AI-based development methods and their application in financial software workflows
• Interest rate cap and swap valuation mechanics
• Covenant calculation methodologies (ICR, LTV, debt yield) across CRE loan structures
• Salesforce platform administration concepts including profiles, permissions, and page layout configuration

This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship.

Estimated compensation for this position:

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:

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'repursuing.

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 ourSupplemental 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.