Power BI Analyst

A global financial services organisation whose core purpose is to seek out and invest in exceptional individuals and whose values align and pride themselves with attracting intellectual leaders, seeks a highly skilled and forward-thinking Power BI Specialist Join a pioneering business that’s renowned for technical innovations that make a difference to our clients, communities and society – and be part of a workplace where you can grow, belong and thrive.

Responsibilities:

• End to end data acquisition and data management (Event/Streaming based data pipelines, ETL, Data Lake, Data warehousing and dimensional data modelling).
• Import the data into the corporate data lake/ data warehouse.
• Querying: Managing SSIS packages and maintenance
• Transformations: Creating and managing SQL stored procedures
• Troubleshooting: Investigating and resolving SQL bugs
• Data design: Designing and building SQL datasets for reporting
• Data handling: Loading and verifying SQL monthly source data
• Data analysis: Manipulating and analysing data
• Reporting: Running month-end packs in Tableau
• Daily reporting: Managing daily SQL data and Tableau reports
• Report development: Developing and automating new BI reports

Qualifications and experience:

• IT related degree/ Diploma / Microsoft Certification / Cloud Certification.
• Min 5 years’ experience in BI (SSIS, SSRS).
• Min 5 years’ experience in data warehousing (Kimbal Methodology) (SSIS).
• Insurance industry knowledge required.
• Database technologies SQL Server 2012 or later (Database, table, view and stored procedure creation, SQL query, SQL Security).
• Experience using Tableau
• Exposure to any cloud technologies
• Hadoop components including HDFS, Hive, Spark, Oozie and Impala
• Streaming based data pipelines (e.g. Kafka or Nifi)
• Object-oriented/object functional scripting languages: Python, Java, Scala or related
• SQL architectural experience preferable.
• Working knowledge of C# / VB.Net / VBA advantageous.

The reference number for this position is NG60442 which is a permanent Hybrid role offering a salary of R600k up to R800k per annum salary negotiable based on experience. E-mail Nokuthula on az.oc.egreM-e@galuhtukon or call her for a chat on 011 463 3633 to discuss this and other opportunities.

Are you ready for a change of scenery? e-Merge IT recruitment is a niche recruitment agency. We offer our candidates options so that we can successfully place the right people with the right companies, in the right roles. Check out the e-Merge IT website www.e-merge.co.za for more great positions.

Do you have a friend who is a developer or technology specialist? We pay cash for successful referrals!

Posted on 05 Jun 09:49, Closing date 4 Aug