Data Engineer/GIS Developer for Automated Florida Land Sales Database

I am a commercial real estate broker specializing in land and development in Florida (Citrus County through Lee County).

I am looking to build a centralized land sales intelligence database that:

• Ingests bulk county property appraiser sales files (CSV/DBF)
• Standardizes inconsistent county field structures
• Filters for vacant and redevelopment land sales
• Handles multi-county data (5–9 counties initially)
• Connects to ArcGIS Pro for mapping and spatial analysis
• Allows ongoing monthly automated updates

I am open to recommendations on the best database or storage solution (cloud or local), as long as it is scalable and can handle large datasets (potentially 1–3 million total records).

⸻

Scope of Work

• System Architecture
• Recommend and implement an appropriate database/storage solution

Design a clean, scalable schema for:

• Land sales
• Parcels
• Buyers / sellers
• Ensure performance and ability to filter/search efficiently
• Data Normalization & Automation

For multiple Florida counties:

• Create field-mapping structure for each county's raw sales file

Normalize:

• Parcel IDs
• Sale dates
• Acreage
• Use codes

Apply filters:

• Sale date ≥ 2021 (configurable)
• Vacant or redevelopment sales
• Acreage

≥ 1 acre (configurable rule)

• Prevent duplicate imports
• Create automation so new files can be processed monthly with minimal manual effort

Python or comparable scripting language preferred.

• GIS Integration
• Ensure database connects cleanly to ArcGIS Pro
• Enable unified multi-county land sales layer
• Confirm spatial filtering and querying works properly

⸻

Deliverables

• Functional land sales database
• Unified multi-county land sales table
• Automated processing workflow for new monthly files
• Documentation of structure and update process
• Instructions for long-term maintenance

⸻

Scale of Data

• 1–3 million potential raw sales records
• Working filtered dataset likely 50,000–150,000 records
• Must be designed to handle growth

⸻

Ideal Candidate

• Experience with large structured datasets
• Experience with GIS data
• Familiarity with property appraiser / parcel data
• Strong database design skills
• Automation scripting experience

Contract duration of 1 to 3 months.

Mandatory skills:

Data Mining, Data Scraping, Microsoft Excel, Python