Job Details

Junior BI Engineer

About

Description

As a Junior BI Engineer, you’ll design, develop, and maintain BI solutions using the Microsoft stack (SQL Server, Power BI, SSIS/SSAS/SSRS). You’ll collaborate with cross-functional teams to deliver high-quality reports, dashboards, and ETL processes, ensuring data accuracy and performance

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

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