Company DescriptionBlend (previously Forth Point) is an award-winning pure play data consultancy who help people do data right through project delivery across strategy and consulting, data science and BI, and data engineering. As a trusted Data & AI partner we co-create value with clients across a wide variety of industries. Our company has made the Inc. 5000 list of Fastest Growing Companies and currently have offices in Edinburgh, the Netherlands, the US, Uruguay and India. By combining our teams’ expert technical knowledge with a practical approach to value creation, we deliver outcomes that make a real change for our clients. From using computer vision to remotely monitor crops to implementing a BI dashboard to help swimmers win more medals – nothing we do is designed to be left on the shelf.Job DescriptionLife as a BI Consultant at BlendWe are looking for someone who is ready for the next step in their career and is excited by the idea of solving problems and designing solutions using cutting edge tools. However, they also need to be aware of the practicalities of making a difference in the real world – whilst we love innovative advanced solutions, we also believe that sometimes a simple solution can have the most impact. Our BI Consultant is someone who feels the most comfortable around messy data, solving problems and answering questions. We place a high value on the ability to communicate and translate complex analytical thinking into non-technical and commercially oriented concepts, and experience working on difficult projects and/or with demanding stakeholders is always appreciated.Reporting into the Data Science and BI team, and working closely with the Data Engineering team, this role will be responsible for driving high delivery standards and innovation in the company. Typically, this involves using data analytics to conduct in-depth analysis which uncovers actionable insights and then reporting the findings back to stakeholders in a clear and relevant manner.As the Data Science and BI team grows, mentoring junior analysts and contributing to leading project teams will also form part of day-to-day functions.What can you expect from the role?Preparing and presenting compelling analysis findings to clients and senior stakeholders.Use a variety of analytical and BI tools to deliver regular reports and deep dive strategic analytics.Own BI tasks and deliverables within projects.Contributing to brainstorming sessions to help develop methodology for BI solutions.Supporting the development of the DS & BI team within Blend.Support in the road-mapping of analytical projects.QualificationsWhat you need to have?Experience prototyping, designing, and developing data analytics and BI projects in a non-academic setting.Data consolidation, cleansing and validation to provide business insight.Data visualisation using software such as PowerBI (or Tableau, Qlik, etc).Attention to detail.Experience in ingesting and transforming data into Power BI using Power Query.Knowledge of creating Tabular Data Models.Experience in creating measures using DAX.Nice to haveAbility to work and process large amounts of data/experience working with cloud environments.Presenting analysis results to clients and stakeholders.Experience and working knowledge of relevant sectors (e.g. manufacturing, energy, public sector, automotive and utilities industries) is desired but not essential.Ability to be flexible with approaches, techniques and technology.An understanding of the Power BI Service.Awareness of the principles of Kimball methodology, and particularly a star schema.Ability to write basic SQL select queries.Awareness of Power BI External tools and when they can add value to the development process.Additional Information*No agencies please.