About the position
An exciting opportunity available within the energy solutions industry for a SQL Analyst, based in Bellville, Cape Town. This person will be responsible for maintaining and developing scripts and programs to perform specific database functions and to analyse data for an in-house developed platform. This role involves optimizing data flow architectures, enhancing automation capabilities, adding new analysis/reporting features, and ensuring that data-driven insights are accessible and actionable for stakeholders.
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 EP's business-related topics (e.g., energy, water, load shedding, municipal utility tariffs, ESG standards etc.).
- Other
- Updating and creating technical documentation.
- Teamwork and collaboration within the Software Development and Analyst teams.
- Peer reviews of technical work.
REQUIREMENTS:
- Bachelor's degree in an Engineering, Programming, Data Science or similar discipline.
- At least 2 years of relevant work experience in data analysis, development or related field.
- 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.
- Able to write efficient SQL queries to solve problems and add technical features given business logic requirements from Product Owner.
- Experience working with databases, 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.
- 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.
Desired Skills:
- SQL Analyst
- SQL
- Data Analysis
- BigQuery
- ETL
