BI Developer

INEOS; Greater London; On-site; GBP 70,000 - 90,000; Full time

Job summary

INEOS Automotive is seeking a BI Developer to join Global Sales Operations. You will build and maintain the reporting estate supporting global sales, retailer and customer experience.

This hands-on role centers on turning requirements into robust Power BI solutions on top of Snowflake data, spanning leads, orders, handovers, retailer performance, inventory and CX. You will work with a Microsoft Power BI stack, Snowflake, and Power Automate to deliver dashboards.

Qualifications

• Strong Power BI development skills: data modelling, advanced DAX, Power Query, report design.
• Experience with composite models and shared datasets (DirectQuery to SSAS/Power BI datasets).
• Strong SQL with cloud data warehouse (Snowflake preferred).
• Solid dimensional modelling (Kimball) knowledge for warehousing vs semantic model.
• Experience administering the Power BI Platform: licensing, security, permissions, workspaces.

Responsibilities

• Scoping, designing, building, servicing, and supporting reports/dashboards to support strategic aims.
• Transforming data requirements into logical/physical data models for BI initiatives.
• Delivering testing, UAT, and end-user training.
• Maintaining BI estate and providing technical advice and first-line support.

Skills

Power BI

DAX

SQL

Data modelling

Power Query

Report design

English

Tools

Snowflake

Azure Analysis Services

Power Automate

Boomi

SAP S/4HANA

C4C

Job description

Story so far

Since we started our journey to build a no nonsense 4X4, we've come a long way. We've established INEOS Automotive as a serious contender in 4X4 development and manufacturing. We've partnered with some of the biggest names in the automotive industry. We've made our way from vision to prototype. We've secured a world-class production facility and delivery team. We've delivered Grenadiers to customers all around the world. We're building our double cab pick up, the Quartermaster.

INEOS Automotive - Built For More

Story so far

Since we started our journey to build a no nonsense 4X4, we've come a long way. We've established INEOS Automotive as a serious contender in 4X4 development and manufacturing. We've partnered with some of the biggest names in the automotive industry. We've made our way from vision to prototype. We've secured a world-class production facility and delivery team. We've delivered Grenadiers to customers all around the world. We're building our double cab pick up, the Quartermaster.

People and Culture

Easy never changed anything. Not in manufacturing, science, engineering or energy - and certainly not elite sport. At INEOS we tackle every challenge head-on, and we help extraordinary athletes achieve extraordinary things. When it comes to making positive change, we know nothing gets done without grit, rigor and humor. Our Automotive team consist of around 1500 employees, 10 locations and 44 nationalities, we're an international team working together to challenge the ordinary. If this sounds like you, let's talk.

Your role:

We are looking for a BI Developer to join Global Sales Operations, working alongside the Global Sales Reporting Lead to build and maintain the reporting estate that supports INEOS Automotive's global sales, retailer and customer experience operations. This is a hands-on delivery role. Requirements, stakeholder decisions and go-live approvals are owned by the Reporting Lead; your focus is turning agreed requirements into robust, well-modeled Power BI solutions on top of our Snowflake data platform. You will work across a live portfolio of dashboards spanning leads, order take, handovers, retailer performance, inventory and customer experience. Our stack is Microsoft Power BI (including composite models over Azure Analysis Services and shared enterprise datasets), Snowflake as the data warehouse, and Power Automate for reporting workflow automation. This is an excellent opportunity to join a leading company. Our commitment to extending data and reporting products and services across the company provides great scope and opportunity to significantly develop and grow your career.

Responsibilities include (but are not limited to):

• Scoping, designing, building, servicing, and supporting all new and existing reports / dashboards within the organisation with the goal of providing robust analytical solutions that support the strategic aims
• Gathering, inspecting, cleaning, transforming and modelling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making
• Capturing data requirements to design, extend or maintain, logical and physical data models which support new and existing BI initiatives
• Delivering testing, maintaining test scenarios, user acceptance testing and end user training
• Responsible for the BI estate and conducting approved technology upgrades, providing technical advice, product information and 1st line support for the BI user community

What we are looking for:

• Strong, demonstrable Power BI development skill: data modelling, advanced DAX (filter context, time intelligence, performance), Power Query, and report design
• Experience with composite models and shared/enterprise datasets (DirectQuery to Analysis Services or Power BI datasets), including their limitations around relationships and calculated columns
• Strong SQL, with the ability to write, test and tune queries and views against a cloud data warehouse (Snowflake preferred)
• Solid grasp of dimensional modelling (Kimball) and when to solve a problem in the warehouse versus the semantic model
• Experience administering the Power BI Platform: licensing, security roles and permissions, and workspaces
• Ability to work from written requirements independently, flag risks early, and respect approval gates on structural model changes
• Fluent in English, with good verbal and non-verbal communication skills

Desired Experience:

• Experience in report / dashboard development using PowerBI
• Experience in managing the PowerBI Platform (licencing, security, workspaces)
• Exposure to SAP-sourced data (S/4HANA, C4C) and ELT tools such as Dell Boomi
• Power Automate (or similar) for scheduled data exports and workflow automation
• Experience in coding with SQL and manipulating large datasets
• Experience in building data pipelines (extract, transform and load) to transport a wide variety of data types and high volumes of data
• Experience of developing end to end data solutions using the Microsoft stack namely, Microsoft Fabric.
• Experience with data platforms such as Snowflake
• Experience in requirement gathering and report/dashboard design
• Experience in time and project management using Agile or Waterfall principals
• Experience in training, presenting, and communicating technical topics to a non-technical audience at all levels
• Knowledge of Data Warehousing concepts and best practice - architecture and methodology (ideally Kimball) and BI Software Development Life Cycle (SDLC)

Behavioural skills:

• Pro-activity - the drive to actively own the products both in development and in operation
• Communication - explain to the goals, objectives, and limitations of product design
• Positivity - see the opportunities in situations; ensure the team understands the benefit of the work
• Detail - question solutions and situations to ensure the business & team understand positions taken
• Commerciality - understand the business reason for the work beyond the technical challenges
• Pragmatism - pragmatic approach to solving conflict, between ideal solutions and immediate need