Jobs

Operations BI Developer/Data Engineer


Job details
  • Collinson
  • London
  • 1 week ago

We use our expertise and products to craft customer experiences. Our range of services helps global brand acquire, engage and retain choice-rich customers.

© 2023 Collinson International Limited. Registered in England & Wales under registration No. 2577557
Registered address : 3 More London Riverside, London, SE1 2AQ, United Kingdom.

Collinson is the global, privately-owned company dedicated to helping the world to travel with ease and confidence. The group offers a unique blend of industry and sector specialists who together provide market-leading airport experiences, loyalty and customer engagement, and insurance solutions for over 400 million consumers.

Collinson is the operator of Priority Pass, the world’s original and leading airport experiences programme. Travellers can access a network of 1,500+ lounges and travel experiences, including dining, retail, sleep and spa, in over 650 airports in 148 countries, helping to elevate the journey into something special. We work with the world’s leading payment networks, over 1,400 banks, 90 airlines and 20 hotel groups worldwide.


We have been bringing innovation to the market since inception – from launching the first independent global VIP lounge access Programme, Priority Pass to being the first to sell direct travel insurance in the UK through Columbus Direct and creating the first loyalty agency of its kind in the travel sector with ICLP. Today we still invest heavily in innovation to ensure that we continue to deliver superior customer experiences.


Key clients include Visa, Mastercard, American Express, Cathay Pacific, British Airways, LATAM, Flying Blue, Accor, EasyJet, HSBC, Chase, HDFC.


Our mission is focused on doing good beyond profit, which for us means we seek out opportunities for our people to share in our success and that we give back to the communities and people within which we work.


Never short of ambition, the success of our business is delivered through the diverse and talented team of over 1,800 global colleagues.


Purpose of the job

Working within the Technical Delivery Team, you will be responsible for data collection, validation and loading of the core business data for Travel Experiences. You will be the quality gate that ensures accurate data is loaded into our Billing and Reporting databases, which reconciles back to a combination of source systems and Excel data sets. You will be required to understand our business and the complexity behind our data and systems and have the ability to improve existing processes that are in place. 

A key responsibility will be to support the monthly Billing processes, working alongside the Operations and Finance teams to ensure billing data is collected, prepared and loaded and then check that it reconciles against the varying sources. As well as supporting the existing SQL Server data solutions, the Business knowledge you gain will support the design and development of a new data platform that will enhance the reporting and analytic capabilities of the business. You will be skilled in using the Microsoft BI stack and be comfortable with SQL, SSRS and Excel. 

You are joining a growing team who are tasked with revolutionising the way we capture and use data.


Key Responsibilities

· Work alongside stakeholders to develop and roll out business critical reporting functions

· Maintain data quality in operational databases

· Follow established change control processes to ensure integrity of code

· Translate business needs into technical requirements

· Generate and deliver quality reports to SLA

· Conduct quality assurance checks on all deliverables

· Perform regular reviews of operational tasks and suggest automation wherever possible

· Acquire expert knowledge of Operational systems and processes

· Provide bespoke and regular insight/reports to Operations, Commercial and Finance teams through analysis of data

· Contribute to the overall programme of business change

· Create and maintain documentation

Knowledge, skills and experience required

· Strong data analysis and data profiling skills with key emphasis on data quality

· Strong analytical and problem solving skills

· Good understanding of relational databases and the ability to query data

· Previous Billing or Operational experience in an analytical or reporting role

· Excellent knowledge of BI Technologies:

o Alteryx development and Gallery job execution essential

o Snaplogic desirable

o Tableau desirable

· Experience of:

o Microsoft SQL server

o SQL Server Reporting Services (SSRS)

o SQL Server Integration Services (SSIS)

· Experience with Microsoft Access DB desirable

· MYSQL experience desirable

· Knowledge of the Payment Card Industry and PCI DSS

· Technical writing and documentation skills

· Attention to detail and accuracy

· A methodical and structured approach to work

· Ability to recommend and suggest data and process improvements based on knowledge gained

· Excellent communicator and aptitude to be internal client facing

· Be able to demonstrate creative thinking to develop innovative solutions

· Able to work independently and multi task effectively

· Organised and able to manage individual workload and operate within the context of a team

· Demonstrate flexibility in thinking and attitude with the ability to manage changing priorities


Collinson is an equal opportunity employer and welcomes differences in all their forms including: colour, race, ethnicity, gender identity, sexual orientation, neurodivergence, family status, age, individuals with disabilities and people from all backgrounds, cultures and experiences as we strongly believe this contributes to our on-going success.

We are focused on continually evolving our purpose driven, high performing culture, providing an environment where our people have the opportunity to achieve their full potential and do interesting and meaningful work. Our company values are: Act smarter, Do the right thing, One team and Be insight led. These help guide everything we do internally in terms of how we think, act and interact, right through to how we deliver value to our customers and clients.

In your application, please feel free to note which pronouns you use (For example - she/her/hers, he/him/his, they/them/theirs, etc).

If you need any extra support throughout the interview process, then please email us at

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Azure Data Engineer (Ref: 1011547)

Azure Data EngineerWe are looking for an Azure Data Engineer to join our Enterprise Applications Team based in Coventry. This role may also be known as BI Developer, SQL Engineer or Data Architect. Duties and ResponsibilitiesAs an Azure Data Engineer you will:Support the development of MTC’s BI Hub and data...

the-mtc Coventry

Senior Business Intelligence Developer

Redbrain is a team full of tech-loving, results-driven data nerds who love helping retailers achieve kickass results (and we really mean that). Our people thrive on applying their tech smarts to the online retail space.We've been shaking up the online affiliate business for years, investing millions into technical solutions to...

Redbrain Birmingham

Developer / Senior / Lead Data Engineer - Business Intelligence Systems

While you’ll have heard our name, there’s a lot you probably don’t know about NEXT. Like how we create most of our systems ourselves – whether it’s a website, mobile app or application. What’s more, we’re growing. Fast. And it’s the kind of growth and investment that is exciting for...

Next Leicester

Developer / Senior / Lead Data Engineer - Business Intelligence Systems

While you’ll have heard our name, there’s a lot you probably don’t know about NEXT. Like how we create most of our systems ourselves – whether it’s a website, mobile app or application. What’s more, we’re growing. Fast. And it’s the kind of growth and investment that is exciting for...

NEXT Leicester

Data Engineer (Hybrid - 3/2 Work Schedule)

Castleton Commodities International is a leading global energy commodities merchant and infrastructure asset investor. As a trader, CCI deploys capital on a proprietary basis in the physical and financial commodity markets, providing the Company with market insights and access. As a strategic investor and developer, CCI leverages its market expertise,...

Castleton Commodities International LLC London

Lead Azure Data Engineer

About Us:Clear Channel Europe, a leader in the advertising world, boasts an impressive portfolio across 13 markets.Our mission is to “Create the future of media”, to revolutionize the media landscape, focusing on data-driven innovations and robust infrastructure.Technology is at the heart of our operations, emphasizing transparency, accountability, and value.Our goal?...

Clear Channel UK London