Data & Analytics Engineer
Orion Digital Solutions · Cairo, Cairo, Egypt
IT Services and IT Consulting · 51-200 employees
About the role
The Data & Analytics Engineer will design, build, and maintain efficient ETL pipelines while ensuring data quality and consistency across datasets. They will also develop interactive dashboards and collaborate with cross-functional teams to translate business requirements into technical solutions.
What they look for
Requirements
Candidates must hold a bachelor's degree in a relevant field and possess 2–3 years of experience in data engineering or business intelligence. Proficiency in SQL, Python, cloud platforms like Azure, and modern data tools such as Databricks or Snowflake is required.
Full description
- Investigate and assess data quality across datasets, ensuring completeness, accuracy, and consistency.
- Analyze raw data to surface meaningful insights and identify emerging business opportunities.
- Design, build, and maintain efficient and reliable ETL pipelines to ingest and transform data from diverse sources.
- Develop optimized calculation and transformation layers to support business logic and analytical requirements.
- Create interactive dashboards and reports that effectively visualize data and communicate insights to stakeholders.
- Maintain comprehensive documentation covering data models, transformation logic, and dashboard design decisions.
- Collaborate closely with business analysts, data scientists, and IT teams to align technical solutions with business goals.
Requirements
Education:
- Bachelor's degree in Computer Science, Data Science, Engineering, or a related field.
Experience:
- 2–3 years of experience in data engineering, business intelligence, or a closely related role.
- Demonstrated experience leading or contributing to data-focused teams or projects.
Technical Skills:
- Expertise in data warehousing, ETL/ELT processes, and end-to-end data pipeline development
- Strong understanding of database technologies, data lakes, and data governance frameworks.
- Hands-on experience with cloud platforms, with a preference for Microsoft Azure.
- Proficiency with Databricks/Fabric/Snowflake, and modern data tooling.
- Strong command of SQL, Python, and data integration technologies.
Soft Skills:
- Excellent analytical and problem-solving skills with a strategic, business-oriented mindset.
- Strong communication and interpersonal skills, with the ability to present technical concepts to non-technical audiences
- Demonstrated ability to manage multiple projects and competing priorities simultaneously.
- Excellent command of English, both written and spoken.