Senior Analytics Engineer

About the role

Payrails is looking for a Senior Analytics Engineer to develop and maintain its data warehouse and analytics-ready datasets. You will work closely with analysts and stakeholders to turn data into actionable insights that drive product and business decisions.

Key responsibilities

• Develop and maintain the data warehouse and curated, analytics‑ready datasets used across the company.
• Own and evolve the dbt codebase, applying best practices in modularity, testing, and documentation.
• Integrate third‑party data sources such as HubSpot, GitHub, and Linear into the data ecosystem.
• Build and maintain tooling and infrastructure to improve the development experience for analytics and business users.
• Partner with analysts to design scalable data models that support self‑serve analytics.

Required profile

• Proven experience in analytics or data engineering with a focus on downstream analytics and reporting.
• Strong proficiency in Python for scripting, tooling, and data transformation.
• Hands‑on experience with dbt and SQL‑based transformation pipelines.
• Excellent communication skills and ability to work cross‑functionally.

Required skills

• Python
• dbt
• SQL
• Data modeling (dimensional, star/snowflake schemas)
• Snowflake, BigQuery or Redshift
• Airflow or similar orchestration tools
• AWS, GCP or Azure
• Docker (Kubernetes a plus)

What we offer

• High‑impact, high‑velocity environment with talented colleagues.
• Real ownership and freedom to build, test, and lead.
• Hybrid working with an office in New Cairo.
• Competitive salary and equity package.
• 27 days of annual paid vacation.