BI Analyst

Job Description

**Candidates must be based in the UK**Optionis is the market-leading provider of accountancy, tax and umbrella employment solutions to contractors and small businesses within the UK. You will be joining a team of 450 staff, who represent highly successful brands such as Parasol, ClearSky, SJDAccountancy and Nixon Williams.Through our brands, we specialise in managing tax, employment, accountancy and legislative compliance for the UKs small businesses and contingent workforce - our solutions are market leading, and were always looking out for the best possible employees.As a successful and growing business, we are always looking to add only the very best talent to our teams. We have experienced significant growth and as a result would like to continue developing our teams. We are now looking to introduce a highly skilled BI/MI Analyst to join our Data & Analytics team on a 6 month fixed-term contract.You will be responsible for ensuring that reporting data is structured to support business stakeholders, generating analytical insight and management information. Enabling measured decision making and support the day-to-day operations for continued growthof the business.Responsibilities:

• Developing, and maintaining a wide array of data-related business reports
• Actively undertaking data analysis and data interpretation, to provide business insight
• Preparing reports and presentations for management
• Develop new reporting insight across a range of operational projects
• Perform extraction, storage, manipulation, processing, and analysis of data

Skills & Experience:

• A minimum of 5 years in a BI/MI Analyst role
• Extensive experience in Microsoft BI technologies:- TSQL, SSIS, SSRS,SSAS (SQL 2016 and above)
• Experience of Azure, Azure ADF, Azure Analytics and Azure SQL Server.
• Experience with Data Warehousing design techniques and methodologies
• Strong skills in Power BI and Reporting Services through end-to-end development
• Excellent communication skills and commercial awareness
• An analytical mind and interest in working with data
• Basic understanding and ability to use coding such as C#/JSON/XM, Python, R
• Good knowledge and experience with Salesforce CRM & SAGE accountancy software
• Financial services background preferred but not essential

What we offer:

• Your Flexibility focuses on providing everyone with the option to choose the way in which they work, be that fully from home, in an office or in an arrangement mixing the best of both. We believe that by providing flexible working options and a fantasticworking environment, in a way which suits your lifestyle, priorities and family, we are building on a culture of trust and ownership.
• 25 days holiday per year (excluding bank holidays). Option to buy and sell an additional 3 days holiday. Following 2 years of service your holiday entitlement will be increased to 26 days and for every subsequent year of service thereafter you will beentitled to one additional days holiday up to a maximum of 29 days per year.
• Exclusive Discounts & Offers from Savings Pal - UKs Leading Benefits Platform
• Private Medical & Dental Insurance
• Pension
• Dress down dress code
• Free parking
• Tusker Car benefit scheme - salary sacrifice green CO2 capped
• Free Mortgage service
• Holiday Buy & Exchange Scheme
• Gym Discount
• Employee Assistance Programme
• Eye Care Vouchers - Specsavers
• The Opportunity to Earn Vouchers for Business Referrals & Reviews