Jobs

Operations BI DeveloperData Engineer


Job details
  • Collinson
  • London
  • 3 weeks ago
Applications closed

Collinson is the global privatelyownedcompany dedicated to helping the world to travel with ease andconfidence. The group offers a unique blend of industry and sectorspecialists who together provide marketleading airport experiencesloyalty and customer engagement and insurance solutions for over400 million consumers.

Collinson is theoperator of Priority Pass the worlds original and leading airportexperiences programme. Travellers can access a network of 1500lounges and travel experiences including dining retail sleep andspa in over 650 airports in 148 countries helping to elevate thejourney into something special. We work with the worlds leadingpayment networks over 1400 banks 90 airlines and 20 hotel groupsworldwide.


We have been bringinginnovation to the market since inception from launching the firstindependent global VIP lounge access Programme Priority Pass tobeing the first to sell direct travel insurance in the UK throughColumbus Direct and creating the first loyalty agency of its kindin the travel sector with ICLP. Today we still invest heavily ininnovation to ensure that we continue to deliver superior customerexperiences.


Key clients include VisaMastercard American Express Cathay Pacific British Airways LATAMFlying Blue Accor EasyJet HSBC Chase HDFC.


Our mission is focused on doing goodbeyond profit which for us means we seek out opportunities for ourpeople to share in our success and that we give back to thecommunities and people within which we work.


Never short of ambition the successof our business is delivered through the diverse and talented teamof over 1800 globalcolleagues.


Purposeof the job

Working within theTechnical Delivery Team you will be responsible for data collectionvalidation and loading of the core business data for TravelExperiences. You will be the quality gate that ensures accuratedata is loaded into our Billing and Reporting databases whichreconciles back to a combination of source systems and Excel datasets. You will be required to understand our business and thecomplexity behind our data and systems and have the ability toimprove existing processes that are in place.

Akey responsibility will be to support the monthly Billing processesworking alongside the Operations and Finance teams to ensurebilling data is collected prepared and loaded and then check thatit reconciles against the varying sources. As well as supportingthe existing SQL Server data solutions the Business knowledge yougain will support the design and development of a new data platformthat will enhance the reporting and analytic capabilities of thebusiness. You will be skilled in using the Microsoft BI stack andbe comfortable with SQL SSRS and Excel.

You arejoining a growing team who are tasked with revolutionising the waywe capture and usedata.


KeyResponsibilities

Work alongsidestakeholders to develop and roll out business critical reportingfunctions

Maintain data quality in operationaldatabases

Follow established change controlprocesses to ensure integrity of code

Translatebusiness needs into technical requirements

Generate and deliver quality reports to SLA

Conduct quality assurance checks on alldeliverables

Perform regular reviews ofoperational tasks and suggest automation whereverpossible

Acquire expert knowledge of Operationalsystems and processes

Provide bespoke andregular insight/reports to Operations Commercial and Finance teamsthrough analysis of data

Contribute to theoverall programme of business change

Create andmaintaindocumentation

Knowledgeskills and experience required

Strong data analysis and data profiling skills with key emphasis ondata quality

Strong analytical and problemsolving skills

Good understanding of relationaldatabases and the ability to query data

PreviousBilling or Operational experience in an analytical or reportingrole

Excellent knowledge of BITechnologies:

o Alteryx development and Galleryjob execution essential

o Snaplogicdesirable

o Tableau desirable

Experience of:

o Microsoft SQLserver

o SQL Server Reporting Services(SSRS)

o SQL Server Integration Services(SSIS)

Experience with Microsoft Access DBdesirable

MYSQL experiencedesirable

Knowledge of the Payment Card Industryand PCI DSS

Technical writing and documentationskills

Attention to detail andaccuracy

A methodical and structured approach towork

Ability to recommend and suggest data andprocess improvements based on knowledge gained

Excellent communicator and aptitude to be internal clientfacing

Be able to demonstrate creative thinkingto develop innovative solutions

Able to workindependently and multi task effectively

Organised and able to manage individual workload and operate withinthe context of a team

Demonstrate flexibility inthinking and attitude with the ability to manage changingpriorities


Collinsonis an equal opportunity employer and welcomes differences in alltheir forms including: colour race ethnicity gender identity sexualorientation neurodivergence family status age individuals withdisabilities and people from all backgrounds cultures andexperiences as we strongly believe this contributes to our ongoingsuccess.

We are focused oncontinually evolving our purpose driven high performing cultureproviding an environment where our people have the opportunity toachieve their full potential and do interesting and meaningfulwork. Our company values are: Act smarter Do the right thing Oneteam and Be insight led. These help guide everything we dointernally in terms of how we think act and interact right throughto how we deliver value to our customers and clients.

In your application pleasefeel free to note which pronouns you use (For example she/her/hershe/him/his they/them/theirsetc).

If you need any extrasupport 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.