Analytics Engineer

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.The Analytics Engineer's primary responsibilities are:Build automated reporting systems and interactive dashboards for portfolio monitoring, including custom analyses for executive leadership, asset management, and originationImplement 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 workflowsDesign 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 QualificationsBachelor'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?" questionAt 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 is $90,000-$120,000/year. The specific compensation that will be offered is based on an understanding of the hired candidates' qualifications at the time of hire. Employees are eligible for a discretionary bonus based on employee work performance reviewed during the annual review process.

Created: 2025-01-25