Job summary
Cape Town, South Africa, Africa
Mid Career (2+ years of experience)
Diploma
Full time
1
: Market Related incl Med Aid, Pension + Incentives
Senior Business Intelligence Developer (AA/EE)(Ref 117)
UNFORTUNATELY, THIS POSITION HAS BEEN FILLED. 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
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