EngineeringDec 2024
Building Asset 360: An End-to-End Property Intelligence Platform
How we built a comprehensive asset modeling system that tracks 80,000+ properties and powers investment decisions at Pretium.
8 min readRead
Hey, I'm
Spencer Dobbs
Senior Analytics Engineer
Currently at Pretium Capital Markets
I build data systems that power investment decisions across a multi-billion dollar real estate portfolio. From predictive models to executive dashboards, I bridge the gap between raw data and strategic insights.
01
About
I'm a Senior Analytics Engineer at Pretium Capital Markets, where I build the analytical infrastructure that powers investment decisions across a multi-billion dollar real estate portfolio.
My work sits at the intersection of data engineering, analytics, and strategic thinking. I don't just build pipelines—I architect solutions that directly influence C-suite decisions on asset acquisition, disposition, and operational optimization.
With nearly 4 years at Progress Residential and now expanding my impact across Pretium's portfolio companies, I've developed a deep expertise in real estate analytics, predictive modeling, and translating complex data into actionable insights.
Pretium Capital Markets
2024 - PresentSenior Analytics Engineer
Leading cross-company analytics initiatives, developing advanced models for real estate investment and debt strategies across Pretium's portfolio companies.
Progress Residential
2021 - 2024Analytics Engineer → Senior Analytics Engineer
Spearheaded pivotal projects including Asset 360, an end-to-end asset model tracking property DNA, appliances, and operational data to forecast performance and guide investment decisions.
Walmart
PreviousCompetitive Intelligence
Managed competitive intelligence data collection on a $10M+ contract. Drove major cost reductions by transitioning from manual to tech-driven data collection.
Acosta
PreviousData Analyst
Developed insights and analytics for CPG and retail optimization.
02
Featured Projects
End-to-End Asset Modeling
Asset Management 360
Developing a comprehensive asset model to understand the records, quality, and performance of assets across our real estate portfolio. This system will automate asset management decisions and streamline operational workflows, transforming how we manage property assets at scale.
ReactPalantir FoundryData PipelinesPython
Impact
Automating asset decisions across 80K+ properties
IoT & Predictive Analytics
Trespasser Prediction
Built a custom algorithm leveraging IoT device data to predict properties with trespassers in vacant homes. This accelerated removal processes and enabled arrests before fake leases could be generated—a critical initiative addressing a multi-million dollar annual problem.
PythonSQLIoT APIsSalesforce
Impact
50%+ accuracy · Millions in annual savings
Predictive Maintenance
HVAC Failure Prediction
Engineered a custom algorithm using thermostat data APIs to predict underperforming HVAC devices before failure. Enables preventative maintenance that saves significant costs per avoided emergency repair.
PythonThermostat APIsMachine Learning
Impact
90%+ accuracy · ~$1,000 saved per alert
Data Infrastructure
Collections Data Mart
Complete overhaul of the company's collections data structure, building an end-to-end data mart that unlocked advanced collection insights and early warning systems for at-risk accounts.
SQLSnowflakeData Modelingdbt
Impact
Enabling proactive collections strategy
Data OperationsWalmart
Competitive Intelligence Platform
Managed competitive intelligence data collection operations on a contract valued at over $10M. Drove significant cost reductions by transitioning from manual efforts to automated tech-driven data collection solutions.
Data CollectionProcess AutomationVendor Management
Impact
$10M+ contract · Major cost reduction
03
Skills & Expertise
Languages & Frameworks
Python95%
SQL95%
React85%
TypeScript80%
Data & Cloud
Snowflake95%
dbt90%
Airflow85%
AWS80%
AI & Analytics
Gen AI / LLMs90%
Machine Learning85%
Data Modeling95%
Visualization90%
SnowflakePythonReactNext.jsSQLdbtAirflowTableauGitDockerAWSOpenAIPandasScikit-learnPostgreSQLRedisSnowflakePythonReactNext.jsSQLdbtAirflowTableauGitDockerAWSOpenAIPandasScikit-learnPostgreSQLRedis
04
Thoughts & Writing
DataNov 2024
Analytics Engineering at Scale: Lessons from Real Estate
Key insights from building data infrastructure that supports billions in real estate investments and debt portfolios.
6 min readRead
AIOct 2024
Applying Gen AI to Real Estate Analytics
Exploring practical applications of large language models in property analysis, document processing, and decision support.
10 min readRead