Junior Business Intelligence Support at BETSoftware

Skill Set

• BI Stack – MS SQL, SSIS, SSAS, SSRS and PowerBI
• T-SQL objects
• PowerBI Dashboards
• ETL components
• Requirements analysis
• Development and testing of BI solutions (Databases, queries, views, reports and Dashboards)
• Data import and export
• Job monitoring
• Data validation

Responsibilities

Production Support

• Ensures troubleshooting of BI tools, systems and software.
• Ability to track performance and production issues.
• Escalates production issues as appropriate.
• Monitors and supports scheduled ETL and cube refresh jobs, ensuring successful completion and accurate data loads into reporting systems.
• Takes ownership of job validation, proactively identifying and resolving failures or delays that may impact data availability or quality.
• Participates in a rotational working shift schedule, which may include early mornings, evenings, weekends, and public holidays, to support critical business operations and ensure continuous system availability.
• Documents production incidents, escalates issues as appropriate, and provides clear communication to stakeholders regarding the status and resolution of job-related issues.
• Tracks and reports on system performance and production issues; may assist in performance tuning of BI applications for optimal efficiency.

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, incorporate coding standards and policies.
• Must be able to provide support on the report offerings.
• Participates in or supports workstream planning processes.
• 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.
• Utilizes database and web application technologies to investigate and evaluate processes and can suggest innovative ways of identifying errors.
• 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.

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.

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.

Apply Before 08/29/2025