Be among the first 25 applicants

OverviewOnce 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 sectors including construction, transport, retail, hospitality, education, facility and property management, manufacturing, local and central government. We manage 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. Buyers access data analytics across their supply chain in areas such as licenses, qualifications and certificates validity, financial health, insurance levels, CSR, infosec and environmental policies, and up-to-date health and safety reports.

Role OverviewThis is a Business Intelligence Engineer role for someone with an analytical mind who can take a big-picture view of the data and transform it into valuable insights for key business decisions. The role involves integrating data from across the business into our data warehouse, requiring someone who can develop and build confidence in the product. This includes requirement gathering and strong knowledge-sharing skills such as writing technical documentation and driving stand-up architecture/data reviews.

The candidate should have strong analytical skills and be proficient in T-SQL and Power BI, with experience in Data Factory or another ETL tool within the Microsoft Azure environment. Knowledge of DAX, Python, and Snowflake would be advantageous. Additional skills that help the project evolve are welcome.

Key Responsibilities

Building and maintaining ETLs

Designing and implementing new data flows

Maintaining high quality BI and analytics, creating competitive views and stored procedures

Integrating new source systems

Key Skills

5+ years of experience in T-SQL queries

2+ years of experience with Data Factory / SSIS (or other ETL tools)

1+ year of experience creating reports using Power BI or other reporting tools

2+ years of experience manipulating data in formats such as JSON and XML

Strong documentation skills

Excellent data modelling and database design skills

Data extraction pipelines, ETL and related toolsets

Version control and CI/CD on the data layer

DevOps experience, Git, Build Pipelines is a bonus

Experience with NoSQL and timeseries stores (e.g., Mongo, Influx)

Understanding of IT directions (Open Source, Cloud, DevOps, API economy, Big Data)

Experience in systems development lifecycle gathering, analysing, and documenting requirements for projects using Waterfall or Agile methodologies

Advantageous

Experience with DAX / MDX

Experience with Databricks

Experience with SQL Synapse

Experience with Data Lakes

Experience developing Cubes using SSAS (on-premises or cloud)

What We OfferAs well as a career in a fast-paced environment within an expanding business, we offer the following benefits:

Wellness fund or private medical insurance (dependent upon role)

Pension

Life Assurance x 3

25 days holiday plus 8 Bank Holidays

Ongoing CPD

Holiday purchase scheme up to 5 days

1 paid and 1 unpaid volunteering day

24/7/365 Employee Assistance Programme

Team and company offsite events

Headspace mindfulness app

Specsavers eye care voucher

Free tea, coffee and fruit

Job Details

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology

Industries: Business Intelligence Platforms

Referrals increase your chances of interviewing at Once For All.

#J-18808-Ljbffr