Once For All is a high growth, cloud-based, SaaS subscription business, providing governance, risk management and compliance services to over 4,000 public and private sector clients and over 60,000 customers across 20 different sectors including construction, transport, retail, hospitality education, facility and property management, manufacturing, local and central government.We manage the qualification, onboarding and audit requirements of individuals, companies, and industry bodies. We provide real-time monitoring and verification of critical data points across all work categories, tenders, and projects. We enable Buyers to access at the touch of a button, data analytics across their entire supply chain in areas such as validity and expiration of specific licenses, qualifications and certificates, accuracy of financial health, insurance levels and exclusions, CSR, infosec and environmental policies and up-to-date health and safety reports.Role overview:This is a Business Intelligence Engineer role for someone who has an analytical mind to take a big-picture view of the data and be able to transform into valuable insights for key business decisions. The role will involve integrating data from across the business into our data warehouse, which, requires someone with the skills to not only develop, but to build confidence in the product. This will consist of requirement gathering as well as having strong knowledge sharing skills such as writing technical documentation to driving stand-up architecture/data reviews.The candidate should have strong analytical skills, be proficient in in the use of Strong T-SQL and Power BI skills and worked with Data Factory or any other ETL tool within the Microsoft Azure environment which are core requirements. It would be very beneficial to have worked with DAX, Python, Snowflake. Any further skills that they believe would allow the project to evolve would be advantageous.Key Responsibilities:Building and maintaining ETLsBuilding/Designing new Data flowsQuality is key and you will be responsible for keeping the BI and analytics at the cutting edge, creating competitive Views/SPs all the time.Integration of new source systemsKey skills:Must have 5+ years of experience in T-SQL queriesMust have 2+ years of experience with Data Factory / SSIS (or any other ETL tool)Should have 1+year of experience in creating reports using preferable Power BI or any other reporting toolShould have 2+years of experience in manipulating the data in different formats like JSON and XML, etc.Strong documentation SkillsExcellent data modelling and database design skills.Data extraction pipelines, ETL and associated toolsetsVersion control and CI/CD on the data layer.Experience with DevOps, Git, Build Pipelines a bonusExperience with NoSQL and timeseries stores (e.g. Mongo, Influx)Understanding of industry IT Direction (Open Source, Cloud, DevOps, API economy, Big Data etc)Experience in systems development lifecycle – gathering, analysing, and documenting requirements for a range of development projects that may utilise Waterfall or Agile methodologies.Advantageous:Have worked with DAX / MDXHave worked with DatabricksHave worked with SQL SynapseHave worked with Data LakesExperience of developing Cubes using SSAS (On-premises or cloud)What we offer:As well as a career in a fast paced environment within a expanding business, we also offer the below benefits as standard:Wellness fund or *Private Medical Insurance (dependent upon role)PensionLife Assurance x 325 days holiday plus 8 Bank HolidaysOngoing continual professional development (CPD)Holiday purchase Scheme up to 5 days1 paid and 1 unpaid volunteering day24/7 and 365 Days Employee Assistance ProgrammeTeam and company offsite eventsHeadspace – mindfulness and meditation appSpecsavers eye care voucherFree Tea, Coffee and fruit every week – Basingstoke office #J-18808-Ljbffr