Business Intelligence Engineer

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 ETLs
• Building/Designing new Data flows
• Quality 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 systems

Key skills:

• Must have 5+ years of experience in T-SQL queries
• Must 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 tool
• Should have 2+years of experience in manipulating the data in different formats like JSON and XML, etc.
• Strong documentation Skills
• Excellent data modelling and database design skills.
• Data extraction pipelines, ETL and associated toolsets
• Version control and CI/CD on the data layer.
• Experience with DevOps, Git, Build Pipelines a bonus
• Experience 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 / MDX
• Have worked with Databricks
• Have worked with SQL Synapse
• Have worked with Data Lakes
• Experience 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)
• Pension
• Life Assurance x 3
• 25 days holiday plus 8 Bank Holidays
• Ongoing continual professional development (CPD)
• Holiday purchase Scheme up to 5 days
• 1 paid and 1 unpaid volunteering day
• 24/7 and 365 Days Employee Assistance Programme
• Team and company offsite events
• Headspace – mindfulness and meditation app
• Specsavers eye care voucher
• Free Tea, Coffee and fruit every week – Basingstoke office