The Role
Build and support production data products, including batch, incremental, and change-data-capture pipelines. Develop trusted data models for analytics and Power BI, improve platform scalability and cost efficiency, and implement testing, monitoring, lineage, access controls, CI/CD, and infrastructure as code. The role also involves troubleshooting SQL Server and SSIS workloads, cloud development on AWS, production incident resolution, data governance, privacy, and AI integration.
Summary Generated by Built In
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
Skills Required
- Relevant tertiary qualification in Computer Science, Information Systems, Engineering, or a related field
- At least 4 years of experience in data or software engineering
- Experience owning production data pipelines
- Advanced SQL, complex querying, and performance tuning
- Strong Python skills for clean, testable code
- SQL Server and T-SQL experience
- Experience troubleshooting and reverse-engineering SSIS packages and SQL Server Agent jobs
- Experience with dimensional modeling, star and snowflake schemas, medallion architecture, and layered warehouse design
- Hands-on AWS experience with S3, Glue using Python or PySpark, and Lambda
- Experience deploying from development to production using version control and GitHub
- Experience monitoring production workloads, managing alerts, and conducting root-cause analysis
- Knowledge of data-quality testing, lineage, access controls, privacy, LLM integration, and Power BI workloads
- Snowflake development experience, including Snowpipe, streams, tasks, access control, and warehouse optimization
- Experience with orchestration tools such as Airflow, dbt, Dagster, or AWS Step Functions
- Experience with managed ingestion or CDC tools such as Fivetran, Airbyte, or AWS DMS
- Experience with fine-grained access control, PII detection, metadata management, and Data Mesh principles
- Infrastructure as Code experience using Terraform, AWS CDK, or CloudFormation
- Relevant certifications such as AWS Certified Data Engineer, AWS Solutions Architect, SnowPro Core, or dbt certification
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Parvana is an IT recruitment agency specializing in connecting top tech talent with leading companies in South Africa and the UK, focusing on software development, finance, and telecommunications.
