Senior BI Specialist

collect personal information that may be used to identify potential professional opportunities other than the job you have applied for, but of which we think might be of interest to you;
- use your personal information to confirm references or background checks you have provided us; and
- request your consent to participate in aptitude tests or recruitment assessments.

We also use your personal information to respond to your inquiries, to verify your information and to share information with you.

Job purpose:

- Understand business intelligence, data integration, data warehousing, modelling, database administration, and technical aspects of BI systems.
- Take the data in its raw form, dissect it to see patterns, trends, outliers, using business intelligence tools and collaborate with the technology and business teams to build effective solutions.
- Play a critical role in configuring and maintaining the reporting solutions management reporting utilising both Microsoft Power BI dashboards and BI reporting, Microsoft SQL Analysis Services, and t-SQL scripts to enhance service delivery and user experience.
- Identifying opportunities for innovation and automation within the IT Service Management business
- Understanding of system functionality, data relationships, and the software development lifecycle, as well as strong problem-solving, communication, and collaboration skills.

Key responsibilities and outputs:
**General**
- **Data Governance and Security**: Implement data governance practices, including data access controls, role-level security, and data lineage documentation. Ensure compliance with data protection regulations.
- **Collaboration and Requirements Gathering**: Collaborate closely with business stakeholders, and end-users to gather and refine requirements for required solutions. Function as a bridge between technical and non-technical stakeholders.
- **Project Management**: Project management skills to plan, execute, and manage projects, including scoping, time management, and meeting deadlines. Projects include new customer onboarding, existing customer enhancements for internal governance and management across supported solutions.
- **Documentation**:Draft and maintain all relevant documentation pertaining to solutions supported including functional specifications, business requirements, user guides, and knowledge articles
- **Innovation & Enhancement**:Identify, recommend, scope, and implement opportunities within supported solutions.

**Configuration and Customisation**
- **Data Modelling and Integration**: Develop and maintain complex data models in Microsoft SQL Analysis Services, including establishing relationships, hierarchies, and calculated columns. Manage data integration tasks, including data source connections and data transformation processes.
- **Report and Dashboard Development**: Independently design and create interactive and visually compelling reports and dashboards using Power BI Desktop. Implement advanced features like bookmarks, drill-through actions, custom themes, and custom visuals.
- **Data Transformation and ETL**: Handle more complex data transformation and ETL (Extract, Transform, Load) processes, including handling data from multiple sources and dealing with complex data structures.

**Support and Analysis**
- **Advanced Data Analysis**: Perform complex data analysis tasks using DAX (Data Analysis Expressions) functions to create calculated measures and solve intricate business problems. Develop advanced DAX calculations for financial, statistical, or performance analysis.
- **Performance Optimisation**: Optimise report and dashboard performance by improving data queries, data model efficiency, and report rendering speed. Identify and address bottlenecks and resource constraints on the reporting and modelling platform(s), as well as scheduling of reports via Microsoft Power BI, Analysis Services model optimisation, and large data dumps via SQL.
- **Troubleshooting**: Support, troubleshoot (log file analysis) and resolve issues related to existing Microsoft SQL Analysis Services and SQL reporting functionality, on prem servers and network connectivity in conjunction with Network support teams, as well as the Power Platform components such as the on-premises Power BI data gateway
- **Pro-active maintenance**:Responsible for proactive maintenance on supported solutions
- **Day-to-day Tasks and System Administration**:

- Monitor, maintain and fix any issues identified with reporting solutions supported.
- Assist with system and reporting data quality.

**Educational Qualifications**
- Bachelor’s degree in Informatics, or equivalent qualification and/or experience

**Work experience**
- 3 years’ experience in business analysis and related documentation
- 3 years as a Power BI Developer or Business Intelligence Analyst.
- 2 years’ Microsoft DevOps experience
- 3 years’ experience in Microsoft SQL Analysis Services
- 3 years of experience in t-SQL scripting / querie