Senior BI Engineer-(DBN) at BETSoftware

You Bring:

• 5-7 years' solid working experience within the BI environment.
• Design, develop, maintain and work towards sustainable, long-term Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.
• Creation of stored procedures, operational reports and dashboards.
• Design, develop and maintain ETL process using SSIS.
• Datawarehouse design, maintenance and re-architecture as required.
• Follow project specifications and corporate coding standards and policies.
• Coach and mentor junior team members.
• Liaise with fellow developers, DBAs and business analysts to identify and optimise inefficient BI processes and code.
• Recommend improvements to provide optimum reporting solutions.
• Be involved in strategic planning and design sessions.
• Demonstrated ability to work on projects from planning to delivery.

What You’ll Do:

Design, Development and Implementation:

• Responsible for the design, development, maintenance and work towards sustainable, long term Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.
• Ensures the creation of stored procedures, operational reports and dashboards.
• Design, develop and maintain ETL process using SSIS.
• Datawarehouse design, maintenance and re-architecture as required.
• Follow project specifications and corporate coding standards and policies.
• Responsible for coaching and mentoring junior team members.
• Liaise with fellow developers, DBAs and business analysts to identify and optimise inefficient BI processes and code.
• Make recommendations on improvements to provide optimum reporting solutions.
• Should be involved in strategic planning and design sessions.
• Works on highly complex and cross-functional BI solutions. Directs, organises, and leads projects in the implementation and use of new BI software tools and systems.
• Participates in workstream planning process including inception, technical design, development, testing and delivery of BI solutions.
• Develops work plans or reviews other work plan timelines and manages workflows to meet timeframes.
• Participates in project management estimation process.
• Manages and plans for service demand forecasts.
• May participates in the development of business cases to support IT projects.
• Collects, analyses, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.
• Works with the BI Analyst during implementation, gathering additional information when needed and keeping the business informed.
• Responsible for implementing data structures using best practices in data modelling, processes, and technologies.
• Performs data conversions, imports and exports of data within and between internal and external software systems.
• Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance.
• Leads the integration efforts for merging BI platforms with enterprise systems and applications.
• Performs data conversions, imports, and exports of data within and between internal and external software systems.
• Explores the data and discovers patterns, meaningful relationships, anomalies, and trends.
• Performs programming analyses for a wide range of requests using data in different formats and from various platforms.
• Ensures documentation is created and maintained.

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

• Ensures the collected data is within required quality standards.
• Maintains the quality of Metadata Repository by adding, modifying, and deleting data.
• Recommends quality metrics and ensures quality metrics are documented and tracked development, model validation, and model implementation.
• Documents standards and policies for the form, structure, and attributes of the BI tools and systems.
• Ensures adherence to process, policies, and standards.

Research/Evaluation

• Analyses and tests new releases/versions of software.
• Conducts research and makes recommendations on BI products and services.
• Interfaces with vendors to keep abreast of new technologies, pricing, and customer applicability.
• Participates in vendor evaluations.
• Interfaces with Architects to recommend new technology opportunities that will have an impact on BI systems.

Coaching/Mentoring

• Provides guidance, training, and problem-solving assistance to other team members.
• Mentors and contributes to the growth of junior and intermediate team members.
• Designs and delivers end-user training and training materials.