Junior BI Engineer

BETSoftware; Johannesburg; On-site; ZAR 420,000 - 720,000; Full time

Job summary

BET Software in Johannesburg seeks a data-driven BI professional with 1+ year of experience in the Microsoft BI stack (SSIS, SSAS, SSRS, SQL) and Power BI to design and deliver end-to-end BI solutions. You will create stored procedures, dashboards and reports, develop ETL processes, and maintain a set of tools and technologies, ensuring alignment with project specifications and coding standards.

Collaborating with Business Analysts, you’ll translate customer needs into actionable insights,

Qualifications

• 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.

Responsibilities

• Implement BI solutions using Microsoft BI stack (SSIS/SSAS/SSRS/Power BI).
• Create stored procedures, dashboards, reports and ETL processes.
• Learn, use and maintain established tools and technologies as necessary.
• Follow project specifications and coding standards.
• Provide support on BI reports.
• Collaborate with Business Analysts to understand customer needs.
• Keep customers informed about BI tool issues and resolutions.

Skills

Power BI

SQL/T-SQL

ETL

Data analysis

Education

Degree or diploma in IT or related technical discipline

Tools

SSIS

SSAS

SSRS

SQL Server

Power BI

Job description

• 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.

Responsibilities

• 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, timelessly.

Develop and Implement

• Responsible for Collecting, analyzing and sharing of data to help business teams drive improvement in key business metrics, customer experience and business results.
• Utilizes 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 Our 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

• 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.