Business Information Manager-MIDRAND
Altech
Johannesburg North, South Africa
3d ago

Job Description :

Key Responsibility Areas :

  • Providing business intelligence solutions using all database environments, including Vigil MPR, Vigil+, Vigil Cloud, Telematics, Dynamics AX and Dynamics CRM SQL and big data
  • BI performance management and improvements across the Netstar Data Landscape
  • Translate business needs to technical specifications
  • Design, build and deploy BI solutions
  • Maintain and support data analytics platforms
  • Create tools to store and analyze data (e.g. OLAP cubes)
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Assist DBA team in performing regular testing of BCP, DR and backup systems in line with audit requirements
  • Maintain archiving strategies for on premise, hosted, multitenant and shared services
  • Adhere to data security policies and controls in line with audit requirements
  • Work with dev-ops on performance, index tuning, stored proc and database development
  • The development, maintenance and automation of SSIS ETL & maintenance
  • The development and maintenance of SSRS environments as per business requirements
  • Job Requirements :

    Educational Requirements & experience needed :

  • Grade 12 or matric equivalent
  • Tertiary certification, diploma or degree in computer science or equivalent
  • Must be willing to work after hours
  • Must have his own transport
  • Core Technical Competencies :

    Advantageous

  • 7+ years T-SQL programming experience
  • 7+ years of SSRS experience
  • 7+ years of SSIS experience
  • In-depth knowledge of data warehousing methodologies
  • In-depth experience in data warehouse architecture
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL frameworks
  • Background in data warehouse design, dimensional modeling and data mining
  • Microsoft Database Administrator Certification
  • Experience with Microsoft Azure and / or AWS
  • Experience with Dynamics AX & CRM
  • Background in Azure Sql as a Service Architecture and design
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form