Analyst - Johannesburg at TransUnion

What We'll Bring:

Associate is responsible for:

• SQL script maintenance and development.
• BI Report maintenance development (Tableau and SSRS).
• A>I graph maintenance and development.
• Execution of Namibia synoptic reports.
• Data analytics and specified analytics investigations.
• Testing of SQL and A>I graphs for SIT and PROD deployments.
• Scheduling of BI reports. (Tableau and SSRS)
• Data ingestion. (new and current processes)
• Automation of processes.

What You'll Bring:

User Support

• Administer the process for requesting information from the Big data Team and reporting to the Big Data Manager on all the requests processed each month.
• Build and deliver key reports in Tableau and SSRS
• Assist the marketing / ISG / Sales department with product development utilizing the Data on Hive
• Assisting users in customizing and automating reporting solutions.

Quality Assurance:

• Ensure accurate, compliant reports with business value are being delivered according to Big data Reporting Standards.
• Facilitation and alerting of Data Quality issues.
• Assist in the testing of new data sets from Ispark as well as testing the validity of reports and analysis.

Report Development

• Development, maintenance and automation of specialized reports.
• Creating Adhoc reports by using the appropriate tools, e.g. Tableau, SSRS or HSQL.

Analysis/Design: 

• Involvement in the full development life cycle, which may require tasks such as:  Business Requirements, Data analysis / profiling tasks.

Documentation: 

• Data Analysis / profiling documentation.

Communication & Collaboration: 

• With Fellow Team members, business users, as well as subject matter experts to be able to translate business requirements into a report.

General:

• Performs other related duties as assigned.

Impact You'll Make:

The duties and responsibilities described above are the essential functions of the job.  

The qualifications below are representative of the knowledge, skills, and/or abilities required.  

• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Diploma or Degree in computer science or a related discipline
• At least 1 years experience Supporting and Administering Tableau environment (Version 2020.4  experience preferred).
• At least 1 years experience support business users from a Data Warehouse environment. 
• At least 1 years SQL Programming experience, in order to create reports using complex queries.
• Participation in at least 2 major Data Warehouse projects.
• Practical Involvement and experience in the full Data Warehouse development life cycle (At least 1 years experience required). 
• Tableau Report building and server administration
• Tableau Prep Builder.
• Dimensional Data Modeling and Design understanding required.
• Practical Experience with MapR Hadoop (advantage).
• Knowledge of Abinito (advantageous)