Analytics Engineer

MONTICELLOAM • New York, NY

3h • $110,000 - $140,000

About The Position

MONTICELLOAM, LLC and its affiliates (“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. Monticello is seeking team players who can work in a collaborative environment and possess drive, integrity, creativity, compassion, and a strong work ethic.
We are seeking a talented Analytics Engineer to join our dynamic team, focusing on optimizing our asset management operations and business intelligence capabilities. This role combines technical data engineering expertise with analytical science skills to drive data-informed decision-making across our portfolio.

Requirements

• Bachelor's or Master's Degree in Computer Science, Data Science, or related field with 3-7 years of experience; additional experience may be considered in lieu of degree
• Expert-level Python programming with strong proficiency in data science libraries (pandas, numpy, scikit-learn) and ML frameworks (TensorFlow, PyTorch)
• Experience building and optimizing ETL pipelines using modern data platforms (experience with Nexla preferred) and working with Snowflake or similar cloud data warehouses
• Demonstrated experience with large language models (LLMs), prompt engineering, and NLP frameworks (e.g., Hugging Face Transformers) for document processing and information extraction
• Proficiency in data preprocessing, cleaning, and transformation techniques for both structured and unstructured data sources
• Experience with supervised and unsupervised learning algorithms, model evaluation metrics, and ML deployment in production environments
• Advanced SQL expertise, particularly with Snowflake, including optimization and security best practices
• Intellectual curiosity, asking the “Why?” question

Responsibilities

• Build automated reporting systems and interactive dashboards for portfolio monitoring, including custom analyses for executive leadership, asset management, and origination
• Implement machine learning (AI) models for asset valuation, market analysis, and investment opportunity screening
• Build and optimize Snowflake databases and queries to support real-time business intelligence needs
• Design and implement quality assurance processes for data extraction, transformation, and analysis workflows
• Design and maintain scalable data pipelines in Nexla and Python to integrate property management systems, financial databases, and market data feeds into our Snowflake data warehouse
• Develop and implement OCR/NLP models to extract, validate, and classify key information from loan agreements, property reports, and other financial documents
• Create predictive models to identify asset performance trends, risks, and opportunities across the real estate portfolio, with a focus on occupancy rates and NOI metrics
• Design and optimize ETL processes to ensure data quality and consistency, with robust monitoring and alert systems

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level