At a Glance
- Tasks: Transform data into insights using Power BI and SQL for impactful decision-making.
- Company: Join 2plan, a forward-thinking company focused on enhancing MI and BI capabilities.
- Benefits: Earn up to £60,000, enjoy a bonus scheme, and flexible benefits including private medical insurance.
- Other info: Dynamic role with opportunities for growth and collaboration across the Openwork Partnership.
- Why this job: Make a real difference by providing high-quality data insights that drive business performance.
- Qualifications: Experience in data delivery, Power BI, SQL, and a knack for problem-solving.
The predicted salary is between 50000 - 60000 £ per year.
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.
What will you need to succeed?
- 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.
MI-BI Analyst employer: The Openwork Partnership
At 2plan, we pride ourselves on being an exceptional employer that fosters a collaborative and innovative work culture. As an MI-BI Analyst, you will benefit from a competitive salary, generous holiday allowance, and a comprehensive benefits package, including a bonus scheme and pension contributions. Our commitment to employee growth is evident through opportunities for professional development and the chance to work with cutting-edge technologies like Power BI and Databricks, all within a supportive environment that values your contributions.
StudySmarter Expert Advice🤫
We think this is how you could land MI-BI Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working at 2plan or similar companies. A friendly chat can open doors and give you insider info on what they're really looking for.
✨Tip Number 2
Show off your skills! If you’ve got experience with Power BI, SQL, or data visualisation, create a portfolio showcasing your best work. This will help you stand out and demonstrate your capabilities beyond just words.
✨Tip Number 3
Prepare for the interview by understanding 2plan’s goals and how your role as an MI-BI Analyst fits into that. Be ready to discuss how you can improve decision-making and insight using your skills.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the team.
We think you need these skills to ace MI-BI Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the MI-BI Analyst role. Highlight your experience with Power BI, SQL, and any relevant projects that showcase your data visualisation skills. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and how your background aligns with our needs. Don’t forget to mention your experience in financial services if you have it – it’s a big plus for us!
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled data deficiencies or gaps in analytical capabilities in the past. We love candidates who can get to the root of problems and come up with effective solutions!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it shows you’re keen to join our team at StudySmarter!
How to prepare for a job interview at The Openwork Partnership
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI, as it’s a key part of the role. Brush up on your data visualisation skills and be ready to discuss how you've used Power BI in past projects. Prepare examples of dashboards or reports you've created that had a real impact.
✨SQL Skills Are Essential
Since SQL is crucial for this position, ensure you can demonstrate your proficiency. Be prepared to answer technical questions or even solve SQL queries on the spot. Practising common SQL problems beforehand can give you a solid edge.
✨Understand the Business Context
Familiarise yourself with the financial services sector, especially how MI and BI can drive decision-making. Research 2plan and its operations so you can speak knowledgeably about how your skills can contribute to their goals.
✨Build Relationships with Stakeholders
This role involves working closely with various stakeholders, so be ready to discuss how you’ve successfully collaborated in the past. Highlight your communication skills and any experience you have in managing expectations and delivering results.
