As an MI-BI Analyst, you will play an important role in strengthening 2plan’s MI and BI capability to improve decision-making and insight. The role will ensure that 2plan has access to high quality and trusted information to assess performance, provide insight, and inform decisions, predominantly using Power BI.
The focus is pragmatic delivery rather than complex semantic modelling, with potential future growth towards Databricks.
The benefits:
- Salary - up to £60,000
- Bonus scheme - on target bonus 10%
- Pension scheme - contribute up to 5% of your salary and Openwork will match you and put in an extra 5%
- Critical illness cover
- Income protection - 1x salary
- Death in service - 4x salary
- 27 days holiday + bank holidays, with the opportunity to buy up to an additional 10 days
- A range of other flexible benefits to include private medical insurance, dental insurance and much more.
Key Accountabilities
- Provide data visualisation in Power BI, using predominantly SQL based data for consumption by MI/BI consumers across a range of measures and metrics.
- Examples include insight to the business on performance to date, as well as future performance vs plan.
- Manipulate and analyse large data sets for sandboxing potential new data outputs, reports, or dashboards for MI/BI Consumers, and to inform what productionised data may be required.
- Build stored procedures and views as required across our reporting SQL database
- Work with stakeholders to understand requirements and set expectations of what will be delivered.
- Assist in identifying and overcoming data deficiencies and gaps in analytical capabilities.
- Set MI reporting policies, PowerBI Standards, and contribute to reporting security model.
- Lead on the Creation / maintenance of a data dictionary
- Build effective relationships across the Openwork Partnership to ensure successful delivery