Jobs

Developer Post (SQL Analysis x3) at the South African Revenue Service: SARS

admin April 27, 2023

3 minutes read

DEADLINE: 05 May 2023

Developer Post (SQL Analysis x3) at the South African Revenue Service: SARS
About the Position

SARS Case selection and Analysis is looking for individuals with a passion for working in a high-volume data environment to analyze and assist the organization to mitigate risk and fraud. The candidate should be highly proficient in dealing with large volumes of data and the relevant technologies as well as writing of Functional Specifications. The individuals must be proactive, forward thinking, and self-motivated.

Job Purpose

To ensure effective management of the information life cycle or value chain that includes the identification, analysis and development of information assets and the assessment of business information needs.

Supporting the various tax streams within the team with data extracts and input on data analysis.

Education and Experience

Minimum Qualification & Experience Required

Relevant Bachelor’s Degree / Advanced Diploma: Information System/ Statistics (NQF 7) AND 5-7 years’ experience in Data Engineering / Business Data Intelligence / Data Science , of which 2-3 years ideally at functional specialist level

Senior Certificate (NQF 4) AND 10 years in experience in Data Engineering / Business Data Intelligence / Data Science, of which 2-3 years ideally at functional specialist level

Minimum Functional Requirements

Experience in Data Engineering / Business Data Intelligence / Data Science
Intermediate (practical application) technical expertise regarding data processes, data cleaning, analysis, reporting, data models, and database design and testing
Knowledge and experience of creating data analysis expression queries
Knowledge and experience in writing Functional Specifications
Intermediate (practical application) Data warehouse knowledge
Be proficient in the application of:
- Basic Data Migration
- Basic Data Visualization
- Business Intelligence Methodologies
- Database Knowledge
Intermediate (practical application) Programming Skills i.e. SQL
Microsoft skills (Proficient in Excel, Word, PowerPoint, etc.)

Job Outputs:

Process

Accumulate information to review work progress that provides input to reporting, decision making and the identification of improvement opportunities.
Interpret and brainstorm business requirements to write Functional Specifications.
Apply practical and applied knowledge and act authoritatively on methods, systems and procedures to identify trends and potential risks.
Communication of situational interpretation and judgement of work outputs and queries in area of specialisation.
Correctly apply policies, practices, standards, procedures and legislation in the delivery of work outputs.
Draw on own knowledge and experience to diagnose symptoms, causes and possible effects in order to solve emerging problems.
Initiate process and procedural change, implement the change and provide guidelines and support related to new requirements because of the change.
Plan for value-added process improvements, initiatives and services to deliver on operational strategy and objectives.
Execute specialist input through investigation &opportunities within the product process including risk concern.
Provide specialist input through the investigation of opportunities for operational and process product and risk optimisation.
To acquiring data from primary or secondary data sources and maintaining databases, applying the knowledge of data extraction, transformation and business modelling.
To design, develop and test medium to complex data analytics solutions like Reports, Dashboards, Analysis, Extracts, Models, etc.
To identify, analyses and interpret trends and patterns in medium to complex data sets, based on data findings.
Communicate the results of their analysis and findings by using medium to complex data visualisation techniques with both internal and external customers.
To ensure the availability of existing data analytics solutions (like reports, etc.) by maintaining them as well as improving them where shortcomings exist.
To research best practices and supports developing the solutions and recommendations for the current business operations
To assist in the filtering and ¡§cleaning¡¨ of imported data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.