Business Analyst

MONTICELLOAM, LLC; New York (NY); On-site; USD 100,000 - 125,000; Full time

Job summary

MONTICELLOAM, LLC, based in New York City, is seeking a Business Analyst to work onsite. This role involves using SQL and Python to analyze data and generate reports for business stakeholders.

The successful candidate will work closely with team members to develop solutions that meet business challenges. Monticello offers a competitive salary between $100,000 and $125,000/year, along with bonuses based on performance.

Qualifications

• Proven ability to understand business challenges and deliver data-driven solutions.
• Experience generating ad hoc reports and analyses for business stakeholders.
• Strong SQL skills for querying and data modeling.
• Familiar with Python for data analysis, automation, and reporting.

Responsibilities

• Partnering with business stakeholders to understand and document business requirements.
• Generating ad hoc reports and analyses that answer time-sensitive business questions.
• Writing Python and SQL to extract, transform, and analyze data across the business.
• Taking projects end to end – from business problem through delivered solution.

Skills

SQL

Python

Data analysis

Reporting

Tools

Snowflake

DBT

Airflow

Git

Job description

Monticello is a real estate and asset-based lender providing asset management and comprehensive capital solutions for healthcare, multifamily, and commercial real estate assets throughout the US. We are seeking motivated, collaborative professionals who bring creativity, compassion, and a strong work ethic to a dynamic team environment.

This role is fully in person. Candidates must be able to work onsite at our New York City office.

Tech Stack

At Monticello, we build and operate our data platform using modern, scalable technologies. As a Business Analyst, you’ll work hands‑on with the following:

Analysis & Reporting

• Python for data analysis, automation, and reporting
• SQL for querying, data modeling, and ad hoc analysis

Data Platform

• Snowflake as our cloud data warehouse
• DBT for modular, version‑controlled data transformations
• Airflow for orchestration and workflow automation
• Git for version control

About Your Team

You’ll join a small, collaborative team that builds the data, reporting, and analytics systems powering Monticello’s real‑estate finance operations. You’ll work closely with business stakeholders and our offshore development teams to turn requirements into delivered solutions. Each team member owns their solutions, beyond just the technical implementation.

What You’ll Own

• Partnering with business stakeholders to understand and document business requirements
• Generating ad hoc reports and analyses that answer time‑sensitive business questions
• Writing Python and SQL to extract, transform, and analyze data across the business
• Taking projects end to end – from business problem through delivered solution

You’ll Also Contribute To

• Project management support – helping coordinate and manage our offshore development teams to keep delivery on track
• Automated data quality and QC processes that keep reporting accurate and trusted
• Dashboards and reporting that drive portfolio decisions
• AI initiatives across the business – including workflow automation, data ingestion, and analysis and insights

Qualifications

Core

• Proven ability to understand business challenges and deliver data‑driven solutions
• Experience generating ad hoc reports and analyses for business stakeholders
• Strong SQL skills for querying and data modeling
• Familiar with Python for data analysis, automation, and reporting

Also Valuable

• Git for version control
• DBT for data transformations
• Snowflake or another cloud data warehouse
• Working with offshore or distributed development teams
• Airflow or other orchestration tools
• LLMs for effective coding and productivity

What We Value

• A strong team player who thrives in a collaborative environment
• Excellent communication – a good listener asks insight‑generating questions
• Comfortable being uncomfortable – able to navigate ambiguity and rapid change
• An entrepreneurial mindset – be willing to take a risk on something new to improve the business, not just prescribed work
• Strong finance domain knowledge

At Monticello, we believe that finding creative solutions for our clients comes from the collaboration of people with diverse backgrounds and perspectives. We strive to build an inclusive work environment that celebrates differences and empowers all individuals with opportunities to channel their entrepreneurial spirit. Monticello is an EEO employer.

Monticello offers a competitive base salary and bonus. The base salary range for this position in New York City is $100,000 to $125,000/year. The specific compensation that will be offered is based on an understanding of the hired candidate’s qualifications at the time of hire. Employees are eligible for a discretionary bonus based on employee work performance reviewed during the annual review process.