Data Engineer

Location: Cape Town | Work Type: Hybrid | Job ID: J107289

About our client:

Our client is a highly successful and purpose-driven group with a global shared services hub based in Cape Town. They are far more than a travel company; they act as a vital platform connecting world-class hospitality with large-scale environmental impact across Africa’s most iconic wilderness areas. The organization prides itself on a culture of continuous improvement and ethical behavior, where the mission is to ensure that natural ecosystems and local communities thrive together. You will join a collaborative, friendly team that avoids rigid hierarchies and values individual contribution. While they "think big" and move fast to protect vulnerable landscapes, they are deeply employee-centric, offering unusually generous benefits and a genuine commitment to work/life balance. This is an opportunity to bring your expertise to a stable yet growing organization where profit meets a profound sense of purpose. They are looking for adaptable, long-term partners who are ready to help drive positive change at scale.

What you will be doing:

• Translate requirements into practical designs and manage data products from build through to production support.

• Build and maintain batch, incremental, and change-data-capture pipelines from various sources.

• Develop tested, modular data models that analysts and Power BI users can trust.

• Deliver scalable, resilient, and cost-efficient changes to the data platform for analytics and AI.

• Implement automated testing, monitoring, lineage, access controls, CI/CD, and infrastructure as code.

What our client is looking for:

• A relevant tertiary qualification would be ideal(Computer Science, Information Systems, Engineering, etc.).

• 4+ years in data or software engineering, including ownership of production data pipelines.

• Advanced SQL expertise with complex querying and performance tuning, alongside strong Python skills for writing clean, testable code.

• Background in SQL Server and T-SQL, including troubleshooting and reverse-engineering SSIS packages and SQL Server Agent jobs.

• Proficiency in dimensional modelling, star and snowflake schemas, medallion architecture, and layered warehouse design.

• Cloud platform experience, specifically hands-on work with AWS services like S3, Glue (Python/PySpark), and Lambda.

• Experience managing deployments from development to production using version control and GitHub.

• Background in monitoring production workloads, handling alerting, and conducting root-cause analysis.

• Strong grasp of data-quality testing, lineage, access control, privacy, AI integration using LLMs, and supporting Power BI workloads.

Would would be advantageous:

• Proficiency in Snowflake development, including stages, Snowpipe, streams, tasks, role-based access control, and warehouse cost and performance management.

• Experience with workflow automation and orchestration tools (e.g., Apache Airflow, dbt, Dagster, AWS Step Functions) and managed ingestion or CDC tools (e.g., Fivetran, Airbyte, AWS DMS).

• Capability in enforcing fine-grained access control, privacy/PII detection, metadata management (Data Mesh principles), and Infrastructure as Code using Terraform, AWS CDK, or CloudFormation.

• Possession of relevant cloud or data certifications such as AWS Certified Data Engineer, AWS Solutions Architect, SnowPro Core, or dbt certification.

For a more comprehensive list of opportunities that we have on offer, do visit our website - https://www.parvana.co.uk/careers

Requirements

Data Engineer, Python, SQL, AWS, S3, Glue, Lambda, Snowflake, Airflow, dbt, T-SQL, SSIS, GitHub, Terraform, CI/CD, Data Governance, PII, Power BI