Position Purpose The Business Intelligence Developer will administer all forms of data flow through the stages of extraction, transformation and load into the organisationâ??s data warehouse Build new data structures, load programs, meta data layers (includes multi-dimensional cubes) and reports that meet organisationâ??s Business Intelligence needs. Work closely with the Business Intelligence Archite

Principal Accountabilities

In addition to following organization’s policies and procedures, principal accountabilities include, but are not limited to:

Database (Warehouse/Relational) Management and Development

• Develop, enhance and mature the databases
• Undertake database optimization and performance management
• Continuous optimisation and refinement of extract, transform and load (ETL) packages
• Develop new ETL packages as per growing business needs
• Ensure a 24/7 365 database uptime

Data and Information Management

• Ensure completeness and accuracy of data
• Constantly validate data integrity
• Derive and implement gold standard “source to fact” traceability
• Derive and implement data management architecture changes
• Enhance and mature meta data schemas, cubes and repositories

 Database (Warehouse/Relational) Governance and Security

• Continuously upgrade databases to latest versions
• Continuously implement database patches and threat management
• Define and implement database user access controls
• Define and implement database governance controls and policies
• Recommend system vulnerabilities to the system consultants / outsourced partners

Database (Warehouse/Relational) Backup and Restore

• Ensure all databases are fully backed-up
• Continuously test database backup and restore process
• Manage and participate in data/database projects and drive innovation within the ERP and Analytics function of IT (10%)
• Enhance, upgrade and modify existing dashboards and reports to meet business needs (5%)

Leadership Competency Profile

• The following profile indicates the expected leadership behaviours at the leadership level appropriate for this job
• Leadership Level “Leading Self” – Associate, Coordinator, Specialist

Communicate Effectively and Candidly

• Convey written and spoken information clearly, concisely, and in a timely manner
• Listen carefully to different opinions and ideas
• Communicate in a way that demonstrates respect for individual differences
• Share viewpoints openly, even if they are contrary to the majority viewpoint

Put the Customers First

• Approach problems with curiosity and open-mindedness
• Pick up on/adapt to different or new ways of doing things
• Identify and surface opportunities to improve systems

Build and Leverage Talent

• Provide constructive feedback to others to help improve their performance
• Share own expertise and experience with others
• Acknowledge others' efforts and accomplishments
• Demonstrate respect for the diversity of talent on a team

Plan and Act Strategically

• Align own activities with the work group's goals and strategies
• Promote and demonstrate commitment to the organization's vision, values, and direction
• Develop plans for completing work including the sequence of activities, realistic time estimates, and required resources
• Break assignments down into manageable tasks
• Coordinate planning efforts with other areas of the business

Achieve through Teamwork

• Readily involve others, as appropriate, to accomplish individual and team goals
• Volunteer to help others
• Proactively share updates and information with others
• Seek opportunities to collaborate, even when their own viewpoints may not align with others

Lead through Influence

• Build networks to increase personal effectiveness
• Engage others in own work by demonstrating a sense of optimism, ownership and commitment
• Provide a sound rationale to gain support for ideas and/or recommendations
• Link ideas to needs and benefits

Execute for Results

• Set high standards for own performance
• Ask questions to clarify assignments and priorities as needed
• Gather data to evaluate processes and programs
• Take the initiative to resolve routine problems and understands when issues should be escalated
• Stay focused on most important work activities, even when distractions occur
• Uphold all of organization’s Standards of Business Conduct

Requirements:

• Minimum of 5 years’ database (warehouse / relational) administration experience
• Minimum 5 years’ experience working with Microsoft SQL Server
• Minimum 5 years’ experience working with SSIS and SSAS
• Qlik and /or another BI Packages experience
• SAP system experience
• Analysis and Problem Solving
• Database Architectures/Topologies                                                                                                                                                        

Ref: JHB000115/LM