.png){kind=logo}
Seniority: Junior to Mid - level Individual Contributor
Core Focus: Python, SQL, Snowflake, ETL/ELT and LLM Integration
Project: Data & Reporting Transformation
Location: Johannesburg, South Africa
Employment Type: Full Time
Company: PYGIO
PYGIO is looking for a Junior to Mid Level Data Engineer to join a client project focused on developing and maintaining data pipelines using Snowflake.
This is a hands on engineering role for someone with a solid foundation in Python, SQL, and data engineering who is ready to contribute to production data solutions and grow their technical expertise. The role also offers opportunities to work with LLM-powered capabilities and integrate AI functionality into data workflows.
You will collaborate with experienced engineers and business stakeholders to build reliable data pipelines, improve data quality, and support the delivery of scalable data solutions.
Develop and maintain ETL/ELT data pipelines using Snowflake.
Write Python and SQL code for data transformation, automation, and validation.
Build and manage data workflows using ETL and orchestration tools
Work with Snowflake warehouses, pipelines, and deployment processes.
Support the deployment, monitoring, troubleshooting, and optimisation of data solutions.
Implement data quality checks and validation processes.
Translate business requirements into practical technical solutions.
Contribute to LLM integration initiatives, including prompt engineering, tool use, and function calling.
Build native web applications using Python (FastAPI) and/or React
Maintain technical documentation and follow established development practices..
Must have:
Practical experience with Python and SQL.
Experience working with Snowflake or another cloud data platform, with a willingness to develop deeper Snowflake expertise.
Understanding of ETL/ELT processes and data pipeline development.
Familiarity with data workflow orchestration tools
Understanding of data quality, validation, and production deployment practices.
Good analytical and problem-solving skills.
Ability to learn quickly, collaborate effectively, and take ownership of assigned tasks.
Good communication skills and the ability to work with technical and non-technical stakeholders.
Nice to have:
Hands-on experience with Snowflake warehouses, pipelines, and deployment.
Experience building, deploying and maintaining native web applications built using Python
Practical exposure to LLMs and GenAI, including prompt engineering, function calling, tool use, and deployment.
Experience integrating AI capabilities into data products or workflows.
You are a developing Data Engineer with a strong foundation in Python and SQL and an interest in building reliable, production-ready data solutions. You are comfortable working with data pipelines, eager to deepen your Snowflake expertise, and able to contribute to real-world engineering projects.
Experience developing web apps using any popular web applications (including the use of LLMs) will help you stand out, but the key requirement is a solid data engineering foundation and the ability to learn and deliver.