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.