Jobs
Operations BI DeveloperData Engineer
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.