Be among the first 25 applicants
Overview
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 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 Overview
This 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 Offer
As 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