Specialist: Power BI Data Engineers (10089) at The South African Revenue Service (SARS)

Minimum Qualification & Experience Required

• Relevant Bachelor's Degree / Advanced Diploma (NQF 7) AND 8-10 years' experience in a data analytics or data engineering environment, of which 3-4 years ideally at operational specialist level.

ALTERNATE

• Senior Certificate (NQF 4) AND 15 years' experience in a data analytics or data engineering environment, of which 3-4 years ideally at operational specialist level.

Minimum Functional Requirements

• Experience in Data Engineering / Business Data Intelligence / Data Science
• Advanced (applied theory) technical expertise regarding data processes, data cleaning, analysis, reporting, data models, and database design and testing
• Knowledge of and experience with reporting packages (SQL or equivalent, etc), databases (SQL etc), programming (SQL, R, Python, etc.)
• Advanced (applied theory) knowledge of statistics and experience using statistical packages for analysing datasets (Excel, SPSS, SAS, R etc.)
• Advanced (applied theory) Data warehouse knowledge

Be advance in the application of:

• Basic Data Migration
• Basic Data Visualization  
• Business Intelligence Methodologies
• Database Knowledge
• Advanced (applied theory) Programming Skills – i.e. SQL, and/or Python, R, etc. 
• Microsoft skills (Advance in)– i.e. 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.
• 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.
• Initiate process and procedural change, implement the change and provide guidelines and support related to new requirements because of the change.
• Note potential problems and obstacles, accumulate supporting data and initiate actions to prevent or overcome predicted problems as may be identified.
• Research and support workable recommendations/solutions that meet business needs through information analysis.
• To perform complex / advance business analysis using various techniques, e.g. statistical analysis, explanatory and predictive modelling, data mining.
• To design, develop and test complex / advance data analytics solutions like Reports, Dashboards, Analysis, Extracts, Models, etc.
• To assist in the filtering and “cleaning” of imported data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
• Conducts analysis, summarizes key findings and trends, and produces data sheets, graphics and presentations.
• Works with research analysts to plan, create and distribute surveys
• Analyses data, creates summary reporting, and performs analysis to support the decision making of research, senior management, member companies and internal departments.
•  Builds and manage/maintain database to house data collected from various sources.

Governance

• Implement and provide input into the development of governance, compliance, integrity and ethics processes within area of specialisation.

People

• Develop and maintain productive working relationships with peers and team members to achieve predefined objectives.
• Search for, integrate and share new knowledge attained through formal and informal learning opportunities in the execution of your job.

Finance

• Adhere to organisational policies and procedures to ensure cost effectiveness and reduction of financial costs.

Client

• Contribute to a culture of service excellence, which builds positive relationships and provides opportunity for feedback and exceptional service.
• Provide authoritative, specialist services, expertise and advice to internal and external stakeholders.
• Build and maintain relationships with clients and internal and external stakeholders that promote cross-functional process delivery solutions.