Data Engineer - Analytics - Property Finder

Founded by Michael Lahyani in 2005 as a magazine (Al Bab World), Property Finder today is a single technology platform and brand across multiple countries in the MENA region. We offer the most advanced tools and best-in-class user experience for home seekers, real estate brokers, and developers. Property Finder's most recent valuation secures our status among the Middle East's emerging unicorns, affirming a growth-oriented identity.

Over the years, we've expanded our operations to Bahrain, Egypt, Qatar, and Saudi Arabia, and secured a strategic shareholding in Hepsiemlak, the leading property portal in Turkey. With over 600 dedicated people in 6 regional offices, we facilitate more than 14 million monthly visits across our platforms, solidifying our position as a regional powerhouse in the proptech space.

As the pioneering portal for home seekers in the region, we are on a mission to motivate and inspire people to live the life they deserve.

Position Summary:

We are seeking a Professional Data Engineer Analytics to join our dynamic Data team, where you will play a crucial role in developing and maintaining robust data solutions.

As a Professional Data Engineer Analytics, you will drive innovation in analytics and uncover new perspectives and angles for analysis, serving as the critical link between raw data and actionable business insights. Your primary responsibility is to transform raw data into clean, organized, and accessible datasets that are optimized for analysis and decision-making.

This role combines data engineering, software development best practices, and business intelligence expertise to enable and empower data-driven decision-making across the organization.

The Data team operates with engineering precision, prioritizing security, privacy, and regulatory compliance in every initiative. You will contribute to the team's commitment to utilizing the latest tools and methodologies, ensuring that our data solutions align with industry best practices.

Our Tech Stack:

Languages: SQL & Python

Pipeline orchestration tool: Dagster (Legacy: Airflow)

Data stores: Redshift/Snowflake/Clickhouse

Platforms & Services: Docker, Kubernetes

PaaS: AWS (DMS, Kinesis, Glue, Athena, S3, and others)

ETL: FiveTran & DBT for transformation

Key Responsibilities:

• Apply Software Engineering Best Practices to Analytics Code: Bring engineering rigor to analytics workflows by applying key software engineering principles.
• Build Semantic Layers for Analytics: Manage the semantic layer of an analytics stack, which serves as the bridge between raw data and end-user reporting tools.
• Define Data Models: Design, implement, and maintain logical data models that represent business concepts, key metrics, and relationships.
• Establish Consistent Metrics: Create and enforce consistent definitions for business metrics and dimensions.
• Build a Self-Service Analytics Environment: Create a self-service analytics culture enabling business users to explore and analyze data independently.
• Automation and Pre-Built Templates: Develop reusable templates, automated reports, and predefined data models.
• Data Governance and Security: Implement robust data governance frameworks, access controls, and data security measures.
• Create User-Friendly and Innovative Dashboards for Business: Design and develop intuitive, interactive, and visually appealing dashboards.
• Performance Optimization: Ensure dashboards are optimized for performance, handling large data volumes efficiently.
• User-Centric Design: Work closely with business stakeholders to understand their requirements.
• Develop and maintain ETL pipelines using SQL and/or Python.
• Collaborate with cross-functional teams to understand and deliver data requirements.
• Use data transformation tools like DBT to prepare datasets for self-service.
• Ensure data quality and consistency in all data stores.
• Monitor and troubleshoot data pipelines for performance and reliability.

Essential Experience:

• 7 years of experience as a data engineer/data modeling.
• Extensive experience with BI tools such as Amazon QuickSight, Tableau, Qlik, Power BI, Looker for creating dashboards and reports.
• Proficiency in SQL.
• Proficiency in programming languages such as Python or R.
• Experience with modern cloud data warehousing and data lake solutions.
• Experience with ETL/ELT batch and streaming data processing pipelines.
• Excellent ability to investigate and troubleshoot data issues.
• Knowledge of AWS services (like S3, DMS, Glue, Athena, etc.).
• Familiar with dbt or other data transformation tools.

Other Desired Experience:

• Experience with orchestration tools like Dagster, Airflow, AWS Step Functions.
• Familiar with CI/CD pipelines and automation.
• Experience with AWS services and concepts.
• Familiar with Terraform and Terragrunt.
• Experience with pub/sub queuing and streaming frameworks such as AWS Kinesis, Kafka, SQS, SNS.

Our promise to talent:

We encourage our people, called creators, to move fast, be bold, and offer them countless ways to make an impact in a fast-growing and talent-centric organization.

Our goal is to ensure that our people find their time at Property Finder a rewarding experience where the company's growth also means personal growth.

Overall, it is a place for you to be your best self.

Property Finder Principles:

• Move fast and make things happen.
• Data beats opinions.
• Don't confuse motion with progress.
• Failure is success if we learn from it.
• People over pixels.