A forward-thinking property management group is hiring a Lead Data Engineer to design and build an enterprise data architecture from scratch to power a unified intelligence platform for financial forecasting and AI-enabled tenant services, driving data-driven decision-making and operational excellence.
Requirements
- 6+ years’ experience in data integration and migration
- Demonstrated success designing and building data architecture/environments from scratch
- Experience designing, building, and implementing new data solutions
- Proven track record building & operationalizing data lake and data warehouse architectures in an enterprise environment
- Deep understanding of KPI-driven design and data modeling techniques such as star scheme, data vault, etc.
- Deep expertise with SQL Server (including SQL stored procedures, SSIS, SSRS)
- Experience working with external vendors and API’s to ingest and normalize 3rd party data
Responsibilities
- Develop architecture and deploy scalable, cloud-native data lake and warehouse architecture to support structured, semi-structured and streaming data (this could be Azure or the most suitable platform/solution)
- Design & build ingestion pipelines that unify data from property mgmt systems, financial platforms, banking and HR systems, as well as CSV files, JSON logs, Excel exports, and IoT sensor feeds, with schema drift handling and metadata tagging
- Collaborate with 3rd party vendors to securely and reliably integrate external data sources
- Prepare data for future AI and LLM consumption, including entity resolution, lineage tracking, and governance frameworks
- Define and establish standards for data quality monitoring, documentation and handoff processes for operational teams
Other
- Proven ability to interface and collaborate with, as well as present solutions, to senior executives
- Excellent communication and interpersonal skills, must be personable
- Must have ability to confidently work autonomously and be a self-starter
- This person will be a strategic partner to the executive team, presenting innovative solutions while working autonomously.
- This is a highly visible position with close collaboration with executives across the holding company and its operating companies.
