Junior BI Engineer (JHB)

BETSoftware


Date: 11 hours ago
City: Johannesburg, Gauteng
Contract type: Full time
Responsibilities

What You’ll Do:

Job Responsibilities

Reporting and Implementation:

  • Ability to implement Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.
  • Responsible for the creation of Stored procedures, dashboards, reports and ETL processes.
  • Learn, use and maintain an established set of tools and technologies, as necessary.
  • Must be able to follow project Specifications, corporate coding standards and policies.
  • Must be able to provide support on the report offerings.
  • Participates in or supports workstream planning process.
  • Collaborates with the Business Analysts to understand customer needs.
  • Keeps customers informed about business intelligence tool problems and resolutions, timeously.

Develop and Implement

  • Responsible for Collecting, analysing and sharing of data to help business teams drive improvement in key business metrics, customer experience and business results.
  • Utilises database and web application technologies to develop and evaluate innovative, business intelligence tools and automated reports.
  • Develops and tests BI solutions such as databases, queries, views, reports, and dashboards.
  • Assists in data conversions, imports, and exports of data within and between internal and external software systems.
  • Documents new and existing models, solutions and implementations.
  • Design and build reporting and analysis tools that help streamline the business and make reporting, analysing, planning and forecasting more efficient.
  • Supports and assists with the integration of BI platforms with enterprise systems and applications.

Production Support

  • Ensures Troubleshooting of BI tools, systems and software.
  • Ability to track performance and production issues.
  • May assist in performance tuning of BI applications.
  • Escalates production issues as appropriate.

Quality Assurance

  • Responsible for Performing Quality checks on all work before giving approval to the stakeholder.
  • Ensures the collected data is within required quality standards.
  • May maintain the quality of Metadata Repository by adding, modifying and deleting data.

Living The Spirit

  • Engages in cross-functional collaboration and problem solving whilst encouraging a culture of inclusivity.
  • Actively drives a culture of versatility and adaptability by supporting other Team Members not only within the department, but within BET Software as a whole.
  • Shows up in an authentic manner and leverages off the team’s diversity to achieve deliverables.
  • Views challenges as opportunities to expand on their knowledge base and takes a creative approach to overcoming the challenges.

Qualifications

You Bring:

  • Degree or diploma in IT or related technical discipline.
  • Minimum 1+ years proven experience in Microsoft BI Stack (SSIS, SSAS, SSRS, SQL).
  • Experience in end-user report development.
  • Experience with data staging (ETL) components.
  • Ability to support and update existing products, and debugging, monitoring and troubleshooting BI solutions.
  • Ability to create efficient T-SQL objects and processes according to spec (databases, tables, stored procedures, business rules and functions).
  • Experience in T-SQL query optimization, troubleshooting and debugging.
  • Understanding of database management systems, online analytical processing and ETL framework.
  • Communicate with various departmental team members to understand the business requirements.
  • Knowledge of the Kimball data warehouse lifecycle.
  • Relevant Microsoft SQL certifications.
Post a CV

See more jobs in Johannesburg, Gauteng