BI Analyst and Architect - 1790

Jordan Human Resource; Pretoria; On-site; ZAR 300,000 - 600,000; Full time

Job summary

An established industry player is seeking a BI Analyst and Architect with extensive experience in relational databases and ETL. This role involves designing, developing, and implementing complex solutions that integrate various technologies. You will work within an Agile environment, focusing on data preparation for front-end applications like SAP BO and QlikSense. If you have a strong command of AWS services and a passion for business intelligence tools, this is an exciting opportunity to make a significant impact in a reputable global company based in Gauteng. Join a dynamic team and take your career to the next level!

Qualifications

• Extensive experience in relational databases and ETL.
• Strong knowledge of BI tools and cloud computing technologies.

Responsibilities

• Design and implement complex BI solutions integrating various technologies.
• Prepare data for front-end applications using SQL and Oracle Scheduler.

Skills

Relational Databases (Oracle / PostgresSQL)

ETL

AWS S3

SQL PL / SQL

Agile Environment

Data Preparation

Business Intelligence Tools

Cloud Computing Technologies

Tools

AWS

QlikSense

SAP BO

Oracle Scheduler

Aurora PostgreSQL

Apache Web Server

Job description

BI Analyst and Architect with extensive experience in relational databases (Oracle / PostgresSQL) and ETL, and experience in designing, developing, and implementing complex solutions with integrations to other technologies and solutions required for a reputable global company based in Gauteng.

Duties & Responsibilities

• Understanding of other BI Tools
• AWS S3
• Ability to develop within a specific sought-after programming language and/or Cloud services
• Strong working knowledge with software development tools, techniques, and approaches used to generate and prepare data to be used by the application solutions
• Cloud computing technologies, business drivers, and emerging computing trends
• Working within an Agile environment
• Oracle & ETL (Extract, Transform, and Load)

Data preparation for the Front-End Applications (e.g. SAP BO, Webi, QlikSense)

• Write SQL PL / SQL (packages, stored procedures, functions) and use Oracle Scheduler to automate ETL of source data for full and delta loads to an Oracle persistence layer.
• AWS (Amazon Web Services)

Quicksight Must have

• Glue ETL data integration
• Elastic Cloud Computing (EC2)
• Aurora PostgreSQL fully managed relational database engine
• Database Administration

Please send CV to:

If you have not received any feedback within 7 days, please consider your application unsuccessful.

Package & Remuneration: Hourly

Required Experience:

Key Skills: Accounts Receivable, Brand Management, Apache Web Server

Employment Type: Full-Time

Vacancy: 1