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

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