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

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 optimization 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 behaviors at the leadership level appropriate for this job.  Refer to the Leadership Competency Guidebook for more information about the organizations’ Leadership Competencies
• Leadership Level “Leading Self” – Associate, Coordinator, Specialist

Communicates 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

Puts the Customer First

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

Builds and Leverages 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 organisation'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 shares updates and information with others
• Seek opportunities to collaborate, even when their own viewpoints may not align with others

Leads 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 Other BI Packages experience
• SAP system experience
• Analysis and Problem Solving
• Database Architectures/Topologies

Ref: JHB000114/LM