MI-BI Analyst

The opportunity

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.

This is a hybrid role, based 3 days a week from our Leeds office.

• 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
• 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.

• 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.

• Experience in delivering data to customers, for example production of reporting and information - Financial Services (Advice) extremely desirable.
• Experience with Agile working for delivery of reports and datasets.
• Knowledge of Microsoft Excel and Microsoft Power BI.
• Understanding of SQL, ETL, and other data structuring concepts.
• Experience of C# (nice to have).
• Investigative – gets to the root of problems.
• Skills in identifying and analysing problems, identifying & evaluating options, and sound decision-making skills.
• Advanced skills for large and multiple data set manipulation & reporting with complex formula.
• Ability to apply judgement to situations requiring balance between time and accuracy.