(Senior) Analytics Engineer

Payrails is a global payment software company helping leading enterprises to take control of their payment operations and maximize performance. At Payrails, data is at the core of everything we do. We don't just analyze data; we turn it into actionable insights that fuel smarter decision-making and drive the future of our products.

Responsibilities

Develop and maintain our data warehouse and curated, analytics-ready datasets used across the company; Own and evolve our dbt codebase, applying best practices in modularity, testing, and documentation; Integrate 3rd party data sources (e.g. HubSpot, GitHub, Linear) into our data ecosystem to enrich reporting and analytics; Build and maintain tooling and infrastructure to improve the development experience (DevX) of our analytics and business users; Partner with analysts and stakeholders to design and implement scalable data models that support self-serve analytics; Advocate for data engineering and analytics best practices, ensuring a culture of data trust, documentation, and reproducibility; Champion data democratization, ensuring teams have the right tools and trusted data to make informed decisions

Requirements

Proven experience in analytics or data engineering roles, with a strong focus on enabling downstream analytics and reporting; Strong proficiency in Python for scripting, tooling, and data transformation tasks; Hands-on experience with dbt and SQL-based data transformation pipelines; Deep understanding of data modeling principles (e.g. dimensional modeling, star/snowflake schema); Familiarity with modern OLAP data warehouses like Snowflake (preferred), BigQuery, or Redshift; Experience working with orchestration tools such as Airflow or similar; Familiarity with cloud platforms (AWS, GCP, or Azure) and containerized environments (Docker; Kubernetes is a plus); Excellent communication skills and the ability to work cross-functionally with technical and non-technical stakeholders; Self-starter mindset with a passion for clean, documented, and tested data code

Nice to have

Snowflake (preferred); Kubernetes (plus)

Benefits

High impact and high velocity environment with the most talented and ambitious people; A chance to shape the story of a company and a category from the ground up; Real ownership with the freedom and trust to build, test, and take lead; A product used by the best brands around the world; Hybrid working with an office in the heart of New Cairo; Regular team events, activities and off-sites; Competitive salary and equity package; 27 days of annual paid vacation