Intermediate BI Engineer

Responsibilities
Design, Development and Reporting:

• Ensures the Design, development and maintenance of 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.
• Follow project Specifications and corporate coding standards and policies.
• Must be able to provide support on the report offerings.
• Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions.
• May participate in project management estimation process.
• Responsible for Developing demand forecasts.
• Collaborates with BI Analysts to understand customer needs.
• Analyses business and functional requirements and translates these requirements.
• Ensure all BI related incidents or service requests are resolved effectively.

Develop and Implement

• Responsible for Collecting, analysing and sharing data to help business teams drive improvement in key business metrics, customer experience, and business results.
• Ensures the Utilization of database and web application technologies to design, develop, and evaluate innovative business intelligence tools and automated reports.
• Designs, develops and tests BI solutions such as databases, data warehouses, queries and views, reports, and dashboards.
• Performs data conversions, imports, and exports of data within and between internal and external software systems.
• Merges BI platforms with enterprise systems and applications.
• Enhances the performance of business intelligence tools by defining data to filter and indexes.
• Documents new and existing models, solutions, and implementations.

Production Support

• Troubleshoots BI tools, systems, and software.
• Troubleshoots reported data loads or reconciliation inconsistencies in conjunction with the sites for data models and/or reports.
• Tracks, monitors and analyses performance and production issues, and implements improvements.
• Supports and helps manage external resources, such as service providers and vendor support.

Quality Assurance

• Responsible for ensuring the collected data is within required quality standards.
• Maintains the quality of Metadata Repository by adding, modifying, and deleting data.
• Provides input to the development of data/information quality metrics.

Coaching/Mentoring

• Provides guidance, training, and problem-solving assistance to other team members.
• Designs and delivers end-user training and training materials.

Living Our Spirit

• Engages in cross-functional collaboration and problem solving whilst encourages a culture of inclusivity.
• Actively drives a culture of versatility and adaptability by modelling and encouraging team members to support each other 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 as well as encourages junior team members to do the same, and takes a creative approach to overcoming the challenges.

Qualifications

• Degree or diploma in IT or related technical discipline.
• Minimum 2-3 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. Debugging, monitoring and troubleshooting BI solutions.
• Identify and resolve data reporting issues.
• 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.
• Ability to work unsupervised.