About the Role

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.

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

Qualifications

Must have strong analytical skills, be proficient 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.

Required 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.
• 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.

Preferred Skills

• 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)

Pay range and compensation package

As well as a career in a fast paced environment within an expanding business, we also offer the below benefits as standard:

• Wellness fund or Private Medical Insurance (dependent upon role)
• Pension
• Life Assurance x 3
• 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

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology
• Industries: Software Development