Background
Andover Properties is an investment firm specializing in alternative real estate asset classes such as self storage, manufactured housing, RV parks, small bay industrial, and car washes. Andover is one of the largest private owner-operators of self storage facilities in the United States and invests on behalf of high-net-worth individuals and institutional capital partners like TPG Angelo Gordon, Ares, and Blackstone.
Andover’s current self storage portfolio totals over 14 million square feet across 169 properties in 19 states and operates under the Storage King USA brand. The company is a best-in-class, vertically-integrated, owner-operator with entrepreneurial spirit and expertise in acquisitions, development, capital markets, investment structuring, property management, and asset management.
Andover was founded in 2003 by Brian and William Cohen and is headquartered in New York City with offices in Miami and San Francisco.
Responsibilities
This role will report to Andover’s head of Data & AI and support high-impact analytics initiatives across the firm.
- Help design and monitor ETL pipelines to move and transform data reliably from operational and financial systems into reporting environments
- Participate in maintaining and optimizing SQL Server databases, including basic performance monitoring, backup validation, and routine maintenance tasks
- Collaborate on integration processes with property management APIs (operational data) and Microsoft Business Central (accounting data), including updating ETLs and functions under guidance
- Contribute to implementing data security best practices, including access controls and data handling procedures
- Continuously look for opportunities to streamline data access and improve performance of reporting systems
- Work closely with internal and external constituents to support ongoing data initiatives and infrastructure improvements
- Support the development of scalable data models and tabular datasets to prepare operational and financial data for reporting and analytics.
Ideal Skills & Qualifications
Education:
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field
- Up to 2 years of experience in data engineering or software development
Technical Skills:
- Strong knowledge of SQL and basic understanding of Python or another scripting language
- Familiarity with databases such as SQL Server, PostgreSQL, or MySQL
- Experience with data integration and ETL tools, such as Apache Spark, Apache Kafka, or Talend
- Basic understanding of data structures, algorithms, and data modeling
- Familiarity with cloud platforms and services (e.g., AWS, Azure, or GCP)
- Comfortable using GenAI tools to enhance productivity
Soft Skills:
- Verbal and written communication skills, with the ability to explain technical concepts and data-driven findings to business stakeholders, and to explain processes, concepts, challenges, and issues to technical resources
- Project and time management skills with the ability to organize and prioritize multiple tasks
- Collaborative across teams such as accounting, asset management, marketing, revenue, and acquisitions
- Good problem-solving skills and willingness to learn new technologies
The ideal candidate will thrive in an entrepreneurial environment, be a proactive and motivated individual, have strong work ethic and unquestionable integrity, and be excited to join a growing and hungry team.
Andover Properties, LLC is an equal opportunity employer. Our employment decisions are based on individual qualifications, job requirements and business needs without regard to race, color, marital status, sex, sexual orientation, gender identity and/or expression, age, religion, disability, citizenship status, national origin, pregnancy, veteran status and or any other legally protected characteristics.
