About the position
Amazing opportunity available for a Data Engineer within the renewable energy industry, based in Bellville. This position supports a sustainability-focused team and oversees the data infrastructure of an internally developed platform. The role involves optimizing data architectures, automating data flows, integrating software and BI layers, and ensuring that actionable insights are reliably available to key stakeholders.
Duties and responsibilities:
- SQL development
- Write efficient SQL queries to solve problems and add technical features given business logic requirements from Product Owner.
- Update and maintain existing reporting platforms and tools.
- Find data quality issues, trends, actionable insights and project opportunities within the data.
- Develop and implement automated reporting solutions to reduce manual effort and improve accuracy.
- Data flows
- Evaluate, optimise, and implement improvements to data flow architecture to ensure efficiency, scalability, and reliability.
- Identify and resolve bottlenecks or inefficiencies in data pipelines.
- Collaborate with teams to streamline data collection, integration, and transformation processes.
- Support integration of data between the database and BI reporting layers.
- Subject matter
- Research and investigations into company's business-related topics (e.g., energy, water, load shedding, municipal utility tariffs, ESG standards etc.).
- Ongoing drive to ensure best-practice data principals are adhered to.
- Other
- Updating and creating technical documentation.
- Teamwork and collaboration within the Software Development and Analyst teams.
- Peer reviews of technical work, as well as mentorship of junior resources.
Requirements:
- Bachelor's degree in an Engineering, Programming, Data Science or similar discipline.
- At least 3 years of relevant work experience in Data Engineering, Development or related fields.
- Proficient in working with multiple datasets from different sources with a strong understanding of how to leverage existing tools and methods to solve data-related problems.
- Skilled at data cleaning, aggregation, and the automation of repetitive data processing pipelines using software tools.
- Demonstrated understanding of data processing principles, data warehousing, cleaning, ETL and building scalable models and data pipelines - data should be of a technical nature such as Engineering data.
- Able to write efficient SQL queries to solve problems and add technical features given business logic requirements from Product Owner.
- Experience working with GCP (Google Cloud Platform), SQL and Google BigQuery.
- Ability to work within tight deadlines in a high-pressure environment.
- Strong logical and systematic thinking with an eye for finding insights and solutions within data.
- Attention to detail with high level of accuracy and quality assurance.
Beneficial
- Experience with Microsoft Excel.
- Experience with using software for data processing (e.g., Python, R, Matlab).
- Experience with development of BI tools (e.g., Power BI, Tableau).
- An understanding of basic electrical systems, energy assets, utilities and sustainability principals.
- Exposure to the Energy Management or Sustainability industries.
- Comfortable with Agile development processes.
- Mentorship experience of junior resources.
Desired Skills:
- Data engineering
- SQL
- Data Flows
- Subject Matter
- BigQuery
- Google Cloud Platform
