The Openwork Partnership
MI-BI Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
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
- 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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
What will you need to succeed?
Experience
- 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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Why us?
2Plan Wealth Management was Launched in July 2007 and we have continuously built on our strengths to become one of the leading wealth management firms in the UK. Our head office administration, technology and regulatory teams provide exceptional support to all our financial advisers around the country, enabling them to deliver the best possible service to clients. The client experience is paramount and all our advisers pride themselves on providing up-to-date advice and building long lasting, professional client relationships. We want all our clients to view 2plan wealth management as their trusted go-to adviser for their financial matters.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location