Star Personnel Recruitment

Great career opportunity with a well-known industry leader in the Financial Services sector. Typically, your role as a Senior Business Intelligence/ETL Developer will be to derive insights and assist stakeholders with understanding the measures and implications of these figures. Consequently, you will be engaged in all phases of the software development lifecycle for the company’s reporting solutions. These phases will include the entire journey from gathering and analysing user/business requirements, creating ETL pipelines in order to feed reporting models and delivering reports / dashboards to the users. It will also include a support function in the event of an outage to ensure stability of the environment as well as being involved in the growth and mentorship of junior and intermediate team members.

"In line with our Employment Equity plan, suitably qualified African Black candidates who meet the criteria for the role will be given preference."

Duties

Budgeting
- Contributes to cost efficiencies

Business Process
- Ensures operational excellence through the delivery of work processes according to defined quality standards
- Optimises work through the application of learning experiences
- Provides production support
- Partners with business to inform research, analysis and to share business generating advice and solutions
- Creates conceptual and physical designs for business intelligence solutions
- Performs end-user scorecard testing and refinement and uses statistical analysis to support ad-hoc projects
- Integrates various teams to ensure implementation and delivery
- Compiles and distributes operational reports

Customer Excellence
- Delivers customer service through adherence to quality service standards

Knowledge Sharing
- Shares knowledge and provides specialist advice

Business Consultation
- Advises and consults business on people analytics

Reporting
- Develops and designs accurate reports for the business

System Design
- Generates systems and tools that enable line managers to understand the cost drivers of all activities in the area
- Designs and builds scalable enterprise data warehouse solutions

People Development
- Participates in planned activities that are appropriate for own and staff development

Teamwork
- Promotes teamwork amongst peers and team members

Requirements

- National certificate 
- Relevant IT qualification or certification

Skills
- Business Insight And Risk Awareness
- Verbal and Written Communication skills (incl. listening)
- Analysis
- Learning Agility
- Business Acumen

Behavioural
- Attention to detail
- Customer Service Orientation
- Commitment and Deadline Driven
- Teamwork
- Self-Starter

Experience

6 years experience as a BI Developer
6 years of substantial practical experience in a structured BI environment 
4 years experience in Data design, systems design experience in a BI environment
5 years Experience in both ETL and data integration processes
5 years Experience designing complex Data Warehousing project implementations
5 years Experience in performance tuning i.e. designing ETL for optimal performance
3 years Experience with Relational and Dimensional Data Modelling (Conceptual, Logical & Physical)
5 years of Solid working experience in SSRS, SSAS (Multidimensional and / or Tabular) and SharePoint
6 years Experience with Data Analysis and Integration, with the ability to understand complex models and business processes and help gather business requirements as needed
6 years Experience writing/tuning complex queries, stored procedures, views, and indexes for major RDBMS: (MS SQL Preferred)
5 years Experience developing complex Executive reports, dashboards for Enterprise level metrics
5 years Experience with Data Profiling, Data Mappings, Data Quality checks, Data Classification and Auditing, etc
2 years Experience with Data Visualization tools (Power BI preferred)

3 years Experience with Project Management and Agile methodologies