The Business Intelligence and Data Analytics Manager will manage and coordinate the enhancement and ongoing development of business intelligence reporting services to enable data driven and business decisions. The role will be responsible for implementing governance controls that enables rapid, robust and sustainable responses to information requests with constantly evolving information sources and information capture.
You will initiate, plan and carry out the enhancement and development of the BI environment by recommending and implementing best-practice solutions, processes and standards for analytics development, data management and data warehousing. Developing strong relationships with internal and agency partner stakeholders is a key part of the role. You will be utilising BI solutions to provide data driven insight, analysis and forecasting to enhance strategic planning, drive business decisions and implement change.
The key responsibilities of the role are shown below:
Manage and implement a strategic, sustainable and maintainable data warehouse solution.
Provide high level conceptual and technical expertise and understanding of data warehousing and business intelligence best practice.
Develop the vision and lead the maturity model of business intelligence within the organisation and apply industry best practice and standards.
Collaboratively and extensively investigate, analyse and interpret business information needs based on a strong understanding of business processes, drivers and priorities
Develop and implement governance and post-implementation evaluation over all activities to ensure outcomes achieved meet organisational objectives
Provide high level experience in identifying data quality issues and supporting information governance by participating in necessary activities and assisting in the development of and adherence to database and development standards
You will be assessed on your ability to demonstrate the following key capabilities, knowledge and experience, the ideal applicant will be someone who can demonstrate the following:
Demonstrated strategic focus with capacity to shape and drive vision and ability to assume responsibility and accountability for advancing business intelligence objectives
Implement and maintain a suite of reports and dashboards in a complex development environment promoting continuous integration, delivery and deployment
Maintain, define, and promote best practices, processes, and principles for data warehousing, reporting, and analytics
Monitor ETL processes with an aim of improving performance
Analyse business requirements and translate into technical designs for development work that will support reporting and data analysis activities
Ability to articulate and translate technical concepts in business speak and prepare briefings and presentations to audience various levels of technical experience.
Extensive experience and comprehensive working knowledge of business intelligence and data warehouse environments including system administration, database design, dimensional modelling, security, reporting and analytics.
The essential requirements for this role are:
Technical experience in planning, designing, implementing and managing MS SQL Server data warehouses, including data modelling (i.e. star schema, fact constellation, data vault 2.0).
Technical experience designing and developing MS Power BI Dashboards & MS SQL Server Reporting Services (SSRS) Reports.
Technical experience with SQL Server including SSRS, SSIS, Power BI Report Server - Advanced
Technical experience in deployment and release cycles using Redgate toolbelt suite.
If you wish to apply for this position, please submit your resume by clicking the 'Apply Now' button. For further information please contact Gavin Knox at Clicks IT Recruitment on 07 3027 2558.