Data Analytics And Engineering
PropHero is an AI-driven marketplace transforming property investment. Backed by global VCs and founded by McKinsey alumni, we’re expanding our team. Join our thriving, and flexible culture, surrounded by ambitious individuals driving change. At PropHero, we’re making property investment as simple as shares or ETFs—be part of the future we’re building!
We are value-driven!
🤝 BELIEVE: We have a contagious passion and entrepreneurial spirit.
🔍 CONNECT: We care for each other and create a “one-team” spirit.
📈 RAISING THE BAR: We push for exceptional performance and never settle for mediocrity.
🔥 OWN IT: We are owners no matter the circumstances.
🌐 DELIVER: We deliver meaningful, measurable outcomes driving a positive impact.
Do these values resonate with you? Keep reading!
How you will shape Prophero:
As a Senior Data & Analytics Engineer at PropHero, you will own the complete data lifecycle - from real-time ingestion to analytics-ready insights. You'll architect event-driven pipelines to stream data from external sources (HubSpot, APIs, webhooks) into PostgreSQL, then transform raw data into dimensional models and actionable dashboards. Working in an AWS ecosystem, you'll build the data infrastructure (Lambda, EventBridge, RDS) while also designing snowflake-modeled data marts and Metabase visualizations. This is a true end-to-end role with equal emphasis on both data engineering (50%) and analytics engineering (50%), where you'll bridge technical infrastructure and business intelligence, ensuring our teams have both reliable data pipelines and clean, business-ready datasets for property valuation models and market analysis.
- Event-Based Data Streaming: Design and implement event-driven pipelines using AWS services (Lambda, EventBridge, Kinesis/MSK, SQS) to ingest data from external sources in real-time.
- External API Integration: Develop robust connectors for third-party APIs, webhooks, and data sources, ensuring reliable data capture with proper error handling and retry logic.
- AWS Infrastructure Management: Deploy and manage AWS resources (Lambda, RDS, EventBridge, CloudWatch, S3) for scalable data solutions.
- Data Transformation Pipelines: Build SQL-based transformation workflows to convert operational database tables into analytics-ready data marts, ensuring data consistency and business logic integrity.
- Data Marts Development: Create purpose-built data marts for different business domains (property valuation, customer analytics, market trends) optimized for analytical queries.
- Analytics & Reporting: Perform data analysis to answer business questions, identify trends, and deliver actionable insights to product and leadership teams.
- Metrics Definition: Partner with business stakeholders to define KPIs, metrics, and business logic; document metric definitions and calculation methods.
- Data Quality & Validation: Implement schema validation, data type checking, and automated quality gates at both the ingestion layer and transformation layer to ensure data accuracy and consistency.
- SQL & Database Optimization: Write efficient, performant SQL queries; optimize query performance and database design through proper indexing, query structure, materialized views, and connection pooling.
- Documentation & Collaboration: Maintain clear documentation of pipeline architecture, data flows, API integrations, data models, transformation logic, and metric definitions; work closely with distributed teams across different time zones.
- End-to-End Ownership: Take full ownership of data systems from ingestion to insights, ensuring seamless integration between infrastructure and analytics layers.
What you will bring to our team:
- 4+ years of experience in data engineering and analytics roles with proven end-to-end data pipeline ownership.
- Strong proficiency in Python for building ETL/ELT pipelines, API integrations, and data validation logic.
- SQL proficiency: Advanced SQL skills including window functions, CTEs, complex joins, and query optimization for PostgreSQL.
- Hands-on AWS experience with Lambda, EventBridge, Kinesis/SQS, RDS/PostgreSQL, CloudWatch, and S3.
- Event-driven architecture: Proven experience with event buses, message queues, webhooks, and streaming architectures.
- Snowflake data modeling: Deep understanding of dimensional modeling principles, star/snowflake schemas, fact/dimension tables, and normalization techniques.
- PostgreSQL expertise: Strong knowledge of PostgreSQL-specific features, indexing strategies, materialized views, performance tuning, and connection pooling.
- API integration expertise: Strong experience with REST APIs, authentication methods (OAuth, API keys), rate limiting, and error handling.
- BI tools experience: Hands-on experience with Metabase, Tableau, Looker, or similar BI platforms for dashboard development.
- Professional English proficiency: Excellent written and verbal English communication skills for technical documentation, code comments, analysis reports, presenting insights, and daily collaboration with Australia and Spain-based team members.
- Problem-solving: Analytical mindset with ability to debug complex pipeline issues, optimize query performance, and implement robust error recovery.
- Remote collaboration: Comfortable working remotely with distributed teams across different time zones, able to communicate complex technical concepts clearly in English.
- dbt experience (preferred): Familiarity with dbt or similar transformation frameworks for building modular, tested SQL pipelines.
- HubSpot or CRM API experience (bonus): Familiarity with CRM APIs (HubSpot, Salesforce, Zoho, or similar) is a strong plus.
- PropTech/Real Estate (bonus): Experience with property data, valuation models, real estate or construction project analytics is a plus.
What can we offer you:
🚀 Growth Mindset
We believe in pushing boundaries and embracing challenges. Whether it’s exploring new tools, improving processes, or taking on uncharted projects, we support a culture of curiosity and innovation where learning never stops.
🌎 A Diverse, Collaborative Team
Join a global team that celebrates diversity and thrives on collaboration. With team members from all over the world, we bring together unique perspectives, ideas, and experiences to create meaningful impact and drive innovation.
📚 Continuous Learning & Development
No matter your background or field of study, you’ll find endless opportunities to learn, grow, and contribute. Our open, transparent environment encourages the exchange of ideas, helping you unlock your full potential.
🌟 Career Growth in an Early-Stage Startup
Be part of a fast-growing startup with global ambitions. As we scale, so will your opportunities to take on more responsibility, shape our success, and advance your career.
💰 Competitive Compensation Package
We value your contributions and offer a competitive economic package to match your impact.
Diversity Statement
At PropHero, we are committed to fostering an inclusive and equitable workplace where diverse perspectives and backgrounds are not only welcomed but celebrated. We believe that diversity drives innovation and empowers us to build stronger connections with our clients and communities.
PropHero is an equal opportunity employer and is dedicated to ensuring a hiring process free from discrimination based on race, ethnicity, gender, age, disability, religion, sexual orientation, or any other characteristic protected by law. Our mission is to create a workplace where everyone feels valued, supported, and empowered to achieve their full potential.
Salary Range
Monthly: 2,000 - 2,600 AUD
Yearly: 24,000 - 31,200 AUD
Top Skills
What We Do
Unlock your property investment potential Winners of the PropTech Most Innovative Award for Consumer Start-up and the Proptech Start-up of the Year at the #PropTechAwards We help you find, purchase and manage the best investment properties. PropHero is a data-driven and AI-enabled digital property investment platform that helps you find, buy and manage the best investment properties. We make property investing simple, transparent and more profitable. Our mission is to help you build wealth through property investment. Harnessing the power of data and AI, our proprietary technology identifies the right investment properties with the potential for high return and low risk. Our national network of trusted real estate professionals assists with the ownership process including inspections, offers, financing, conveyancing, tenants and property management. We aim to reduce the time required to invest in property by 90% by using technology as much as possible for market discovery, research & analysis, and communications. The human touch remains vitally important for trust and confidence, so we give you a personal Property Coach. Your Property Coach will help you to define your investment strategy and support you through all the stages of buying and managing your property. Many of our clients now own multiple properties. Our Co-Founders, Pablo Gil Brusola and Mickael Roger, are experienced and enthusiastic property investors, who wanted “an app for that” to streamline this complex process. At the same time, they wanted to make property investing more accessible for a new generation to invest with confidence. PropHero was launched with the ambition to make property investment simple, time-efficient and more profitable by using data, proprietary AI algorithms and an online platform to offer an end-to-end property investment service. It’s the “next gen” in buyer’s agent services.
